Postgres MCP Server

# 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 1. Create a virtual environment and install dependencies: ```bash python3 -m venv venv source venv/bin/activate pip install -r requirements.txt ``` 2. Configure your Postgres connection in `.env`: ``` DB_HOST=localhost DB_PORT=5432 DB_NAME=postgres DB_USER=postgres DB_PASSWORD=your_password ``` 3. Run the server: ```bash source venv/bin/activate python server.py ``` ## Usage with VS Code Add to your `.vscode/mcp.json`: ```json { "servers": { "postgres-mcp": { "type": "stdio", "command": "venv/bin/python", "args": ["server.py"] } } } ``` ## Tools - `list_databases`: Lists all databases - `list_schemas`: Lists schemas in a database - `list_tables`: Lists tables in a schema - `get_table_schema`: Gets column details for a table - `execute_query`: Runs SELECT queries (read-only)