PostgreSQL MCP Server

Example Use Cases

• 1

  Discover and inspect table schemas and column types in a PostgreSQL database before composing queries.

• 2

  Execute read-only SQL queries against a PostgreSQL database in a safe, read-only transaction.

• 3

  An easy-to-launch MCP endpoint (via Docker or npx) to integrate database inspection and read-only querying into LLM workflows such as Claude Desktop.

Description

This server exposes PostgreSQL database schemas and provides a tool to run read-only SQL queries within a READ ONLY transaction. It automatically discovers table schema metadata and serves per-table JSON schema endpoints, making it easy for LLMs to understand database structure. The project includes examples for running via Docker or npx and is intended for safe, read-only inspection and querying by agents (e.g., integrations like Claude Desktop).