$ 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.
Let AI query local PostgreSQL data and inspect table schemas.
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.
Query PostgreSQL, inspect schemas, and run SQL safely with natural language.
Connect AI assistants to PostgreSQL for secure querying, management, and analysis.
Let AI query, manage, tune, and administer PostgreSQL databases deeply.