PostgreSQL MCP Server

Example Use Cases

• 1

  Inspect database table schemas and column types before composing queries or answering questions about data structure.

• 2

  Run read-only SQL queries against a PostgreSQL database to fetch data for analysis, summaries, or decision-making without risking data modification.

• 3

  Integrate database access into developer tooling workflows (e.g., Claude Desktop, VS Code) via Docker or NPX for rapid local deployment.

Description

This MCP server connects to a PostgreSQL database, automatically discovers table schemas, and runs read-only SQL queries inside a READ ONLY transaction. It exposes table schema metadata as JSON resources and provides a 'query' tool for executing SQL safely. The project includes Docker and NPX installation options and is distributed under the MIT License, making it easy to run locally or inside developer tooling such as Claude Desktop and VS Code.