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.
Query and explore PostgreSQL databases with SQL, tables, and schema inspection.
Connect AI assistants to PostgreSQL for secure querying, management, and analysis.
Query PostgreSQL, inspect schemas, and run SQL safely with natural language.
Query PostgreSQL databases and schemas through natural language with read-only AI access.
Connect AI to databases for queries, schema management, and data export.
Provides PostgreSQL skills and docs so AI coding tools write better database code.