$ loading_
Run PostgreSQL queries, inspect metadata, and diagnose performance via natural language.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "mcp-pgSQL" yet — see the docs or source repo.
Connect to the local PostgreSQL instance, query the top 10 orders by sales amount in the last 7 days, and return them sorted by amount descending.
A ranked list of the top 10 orders by sales amount in the last 7 days.
Inspect the customers table's columns, primary key, indexes, and foreign keys, then summarize the schema in concise English.
A schema summary of the customers table with key constraints.
Analyze the most time-consuming SQL statements in the current database, identify likely bottlenecks, and suggest optimizations.
A slow-query analysis with actionable optimization recommendations.
Query any Postgres database in natural language for fast insights.
Connect AI assistants to PostgreSQL for secure querying, management, and analysis.
Inspect PostgreSQL schemas and run read-only SQL queries through MCP tools.
Connect to PostgreSQL via MCP for queries, schema inspection, and database changes.
Securely query and manage PostgreSQL databases for operations and automation.
Safely run PostgreSQL SQL with index tuning, explain plans, and health checks.