PostgreSQL MCP Server

Example Use Cases

• 1

  Inspect database schemas and understand table and column structures before generating queries.

• 2

  Run safe, read-only SQL queries against PostgreSQL to answer data questions without risking data modification.

• 3

  Integrate PostgreSQL access into LLM workflows (e.g., Claude Desktop) via Docker or an NPM package for easy deployment.

Description

This server provides Model Context Protocol access to PostgreSQL databases, enabling language models and agents to inspect schemas and run read-only SQL queries inside READ ONLY transactions. It emphasizes safety by enforcing read-only access and recommends using a read-only database user. The project includes Docker support and can be installed via Smithery or used as an NPM package, making it easy to integrate with Claude Desktop and other LLM workflows.