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
Setup
Test connection:
Configure Amazon Q MCP:
Update C:\Users\%USERNAME%\.aws\amazonq\mcp.json:
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:
List tables:
Describe table structure:
Browse 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