Integrates with Amazon Q to allow users to query and explore PostgreSQL databases directly through the chat interface.
Enables the loading and use of the PostgreSQL MCP server within the IntelliJ IDEA development environment via Amazon Q.
Provides tools for executing SELECT queries, listing tables, and describing schema structures in PostgreSQL databases.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@PostgreSQL MCP ServerDescribe the structure of the ports table"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
PostgreSQL MCP Server
MCP-compliant server for PostgreSQL database integration with Amazon Q.
Installation
pip install -r requirements.txtSetup
Test connection:
python server.py --host host.example.com --port 61025 --database example --username example_user --password example_pwd --testConfigure 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 5List tables:
List all tables in the capacity_planning2 schemaDescribe table structure:
Describe the structure of the ports table in capacity_planning2 schemaBrowse schemas:
Show me all available database schemasAvailable 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
This server cannot be installed
Resources
Looking for Admin?
Admins can modify the Dockerfile, update the server description, and track usage metrics. If you are the server author, to access the admin panel.