PostgreSQL MCP Server
MCP-compliant server for PostgreSQL database integration with Amazon Q.
Installation
pip install -r requirements.txt
Setup
- Test connection:
python server.py --host host.example.com --port 61025 --database example --username example_user --password example_pwd --test
- 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
}
}
}
- 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