PostgreSQL MCP Server

Connects Claude to PostgreSQL databases with a full suite of inspection and querying tools. You get schema discovery, read-only query execution with automatic row limits and transaction rollback, query plan explanations, foreign key relationship mapping, and index analysis. The write query tool accepts single INSERT, UPDATE, DELETE, or DDL statements and commits them, so you'll want a read-only user for most workflows. Exposes MCP resources for table lists and schema definitions. Ships with configurable row limits and runs queries in explicit read-only transaction mode for safety. Install via uvx and configure with standard Postgres connection parameters.