PostgreSQL

MCP server for querying PostgreSQL databases. Run SELECT queries for analytics and investigation, describe table schemas, list databases and tables, and execute INSERT/UPDATE statements with confirmation. Supports parameterized queries to prevent SQL injection.

Useful for data analysis, reporting, debugging application state, investigating anomalies in production data, and building dashboards from live database queries.

Install

amodal install mcp postgres

Tools exposed

• query — Execute a SQL query and return results as JSON rows. Supports parameterized queries with $1, $2 placeholders. SELECT queries run directly; INSERT/UPDATE/DELETE require confirmation.
• describe_table — Return column names, types, nullability, defaults, and constraints for a table. Includes primary keys, foreign keys, and indexes.
• list_tables — List all tables in a schema with row counts and table descriptions.
• list_schemas — List all schemas in the database with table counts.
• get_table_indexes — Return all indexes on a table with column lists and uniqueness.
• explain_query — Run EXPLAIN ANALYZE on a query and return the execution plan. Useful for debugging slow queries.

Configuration

env:
  POSTGRES_CONNECTION_STRING: "postgresql://user:password@localhost:5432/mydb"

• POSTGRES_CONNECTION_STRING — Standard PostgreSQL connection string. Supports all libpq parameters including SSL mode. Required.
• POSTGRES_READ_ONLY — Set to true to block all write operations. Defaults to false.
• POSTGRES_STATEMENT_TIMEOUT — Query timeout in milliseconds. Defaults to 30000 (30 seconds).

Example usage

• "Show me all orders from the last 7 days with amounts over $1000"
• "Describe the users table and show me its indexes"
• "How many active subscriptions do we have by plan type?"
• "Find duplicate email addresses in the contacts table"