PostgreSQL MCP Server

Example Use Cases

• 1

  Inspect database schemas and column types before formulating queries or answering data-related questions.

• 2

  Run safe, read-only SQL queries against a PostgreSQL database to retrieve facts or generate reports without risking data modification.

• 3

  Integrate database-backed context into LLM workflows (e.g., Claude Desktop) via a simple MCP-compatible server using Docker or npx.

Description

This MCP server exposes PostgreSQL database metadata and executes read-only SQL queries within a READ ONLY transaction. It automatically discovers table schemas (column names and types) and exposes them as JSON resources, and provides a single 'query' tool for executing safe read-only queries. The project includes examples for running via Docker or npx and is distributed under the MIT License. It's designed to let LLM-based agents inspect schema structure and retrieve data without risking writes.