PostgreSQL MCP Server

PostgreSQL MCP Server

MCP-compliant server for PostgreSQL database integration with Amazon Q.

Installation

pip install -r requirements.txt

Setup

1. Test connection:

python server.py --host host.example.com --port 61025 --database example --username example_user --password example_pwd --test

2. Configure Amazon Q MCP:

Update C:\Users\%USERNAME%\.aws\amazonq\mcp.json:

{
  "mcpServers": {
    "local-postgres-mcp": {
      "command": "C:\\Users\\sk\\AppData\\Local\\Programs\\Python\\Python313\\python.exe",
      "args": [
        "C:\\Workspace\\GitLab\\capacity-planning2\\postgresql-mcp\\server.py",
        "--host", "host.example.com",
        "--port", "61025",
        "--database", "example",
        "--username", "example_user",
        "--password", "example_pwd"
      ],
      "env": {"PYTHONUNBUFFERED": "1"},
      "timeout": 60000
    }
  }
}

3. Restart IntelliJ IDEA to load the new MCP server

Using with Amazon Q Chat

Once configured, you can use these commands in Amazon Q chat:

Query database:

Query the database: SELECT * FROM "capacity_planning2".ports LIMIT 5

List tables:

List all tables in the capacity_planning2 schema

Describe table structure:

Describe the structure of the ports table in capacity_planning2 schema

Browse schemas:

Show me all available database schemas

Available Tools

• query_database: Execute SELECT queries with automatic LIMIT
• describe_table: Get detailed table column information
• list_tables: List tables in specific schema or all schemas

Security

• Read-only access (SELECT queries only)
• Automatic query limits (100 rows max)
• Connection timeout protection