$ loading_
Safely query, inspect, and analyze PostgreSQL databases in read-only mode.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "postgres-mcp" yet — see the docs or source repo.
Connect to PostgreSQL in read-only mode and list all tables in the public schema, including column types, primary keys, and indexes, then output a table-by-table summary.
A table-by-table schema summary with columns, types, primary keys, and indexes.
Here is a PostgreSQL query. Analyze its execution plan in read-only mode, identify likely performance bottlenecks, and suggest indexing or rewrite improvements: SELECT * FROM orders WHERE customer_id = 123 AND created_at >= NOW() - INTERVAL '30 days';
An explanation of the execution plan, bottleneck diagnosis, and actionable optimization suggestions.
Run read-only queries on PostgreSQL to calculate daily order count, total revenue, and average order value for the last 90 days, then summarize notable trends or anomalies.
A data overview with key metrics and a summary of trends or anomalies.
Safely explore PostgreSQL schemas and run controlled read or write queries.
Inspect PostgreSQL schemas and run read-only SQL queries through MCP tools.
Safely inspect and query PostgreSQL databases using natural language.
Safely query and inspect PostgreSQL databases without enabling risky write operations by default.
Connect to PostgreSQL via MCP for queries, schema inspection, and database changes.
Safely query read-only PostgreSQL data and inspect schemas, tables, and columns.