Postgres MCP Server
A Model Context Protocol (MCP) server that exposes Postgres database information to VS Code agents and other MCP-compatible clients.
Features
- List available databases
- List schemas in a database
- List tables in a schema
- Get table schema (columns)
- Execute read-only SQL queries
Setup
-
Create a virtual environment and install dependencies:
python3 -m venv venv source venv/bin/activate pip install -r requirements.txt -
Configure your Postgres connection in
.env:DB_HOST=localhost DB_PORT=5432 DB_NAME=postgres DB_USER=postgres DB_PASSWORD=your_password -
Run the server:
source venv/bin/activate python server.py
Usage with VS Code
Add to your .vscode/mcp.json:
{
"servers": {
"postgres-mcp": {
"type": "stdio",
"command": "venv/bin/python",
"args": ["server.py"]
}
}
}
Tools
list_databases: Lists all databaseslist_schemas: Lists schemas in a databaselist_tables: Lists tables in a schemaget_table_schema: Gets column details for a tableexecute_query: Runs SELECT queries (read-only)