Overview
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.
