$ loading_
Let AI query, inspect, and modify a local PostgreSQL database with SQL.
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 the local PostgreSQL database, list all schemas, tables, and key columns, and summarize the purpose of each table in English.
A schema overview listing tables and key columns, plus a summary of each table’s purpose.
Using the orders and customers tables, write SQL to find the top 10 customers by revenue in the last 30 days, showing customer name, order count, and total revenue.
Executable SQL plus the matching query results or a clear result summary.
First inspect the users table schema, then mark users who have not logged in for the past year and are inactive as archived, and explain the SQL to be executed.
A schema check and update plan, followed by executed or ready-to-run SQL and the expected impact.
Let AI clients run PostgreSQL queries, inspect schemas, and analyze query plans.
Connect AI to PostgreSQL for querying, analysis, and database development tasks.
Safely manage PostgreSQL databases with schema exploration, procedure analysis, and test data generation.
Lets AI assistants run SQL and inspect PostgreSQL schemas via MCP tools.
Lets AI securely query, modify, and inspect PostgreSQL databases.
Connect to PostgreSQL and query schemas and data using plain English.