postgres-mcp-server

What is postgres-mcp-server?

A PostgreSQL Model Context Protocol server that lets an LLM interact with a local database. It is experimental and not intended for real databases.

How to use postgres-mcp-server?

Install Node.js, run npm install, and set the environment variables DATABASE_NAME, DATABASE_USER, DATABASE_PASSWORD, and DATABASE_SCHEMA_NAME. A VSCode configuration snippet is provided to integrate the server via stdio.

Key features of postgres-mcp-server

• Experimental PostgreSQL MCP server for local databases
• Connects using environment variable configuration
• Supports read and write SQL queries
• Runs via npm start with stdio transport
• Integrates with VSCode chat’s MCP discovery

Use cases of postgres-mcp-server

• Letting an LLM query a local development database
• Experimenting with database interactions in a safe environment

FAQ from postgres-mcp-server

Is postgres-mcp-server safe for production databases?

No, it is experimental; do not use it on real databases and be careful with write queries.

What are the prerequisites to run postgres-mcp-server?

You need Node.js installed and must run npm install to install dependencies.

What environment variables are required?

DATABASE_NAME, DATABASE_USER, DATABASE_PASSWORD, and DATABASE_SCHEMA_NAME (typically public).

How do I configure postgres-mcp-server in VSCode?

Add a configuration block in your settings.json with the command npm, type stdio, args ["start", "--prefix", "/path/to/code/postgres-mcp-server"], and set the required environment variables.

What transport does postgres-mcp-server use?

It uses stdio transport, as shown in the VSCode configuration example.