$ loading_
Query and explore PostgreSQL databases with SQL, tables, and schema inspection.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "mcp-postgres" yet — see the docs or source repo.
Connect to the PostgreSQL database and run this SQL: SELECT order_date, SUM(amount) AS total_sales FROM orders WHERE order_date >= CURRENT_DATE - INTERVAL '30 days' GROUP BY order_date ORDER BY order_date; Then summarize the sales trend over the last 30 days in English.
Returns the query results with a brief analysis of the 30-day sales trend.
List all tables in the database, and describe the columns, types, and primary/foreign key relationships for the users, orders, and products tables.
Provides a table list plus schema and relationship details for the specified tables.
This SQL query is too slow: SELECT * FROM events WHERE user_id = 12345 AND created_at >= '2024-01-01'; Please inspect the related schema and indexes, then suggest optimizations.
Analyzes the relevant tables and indexes, then suggests actionable SQL optimizations.
Explore PostgreSQL schemas and run safe read-only queries for analysis.
Lets AI assistants run SQL and inspect PostgreSQL schemas via MCP tools.
Let AI query local PostgreSQL data and inspect table schemas.
Enable AI assistants to run PostgreSQL SQL queries and inspect schema metadata.
Query PostgreSQL databases and schemas through natural language with read-only AI access.
Let AI query, inspect, and modify a local PostgreSQL database with SQL.