PostgreSQL MCP Server

@pyljain

Basic information

About PostgreSQL MCP Server

No overview available yet

PostgreSQL MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mcp_server_template": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "mcp/postgres",
        "-f",
        "src/postgres/Dockerfile",
        "."
      ]
    }
  }
}

PostgreSQL MCP Server tools

Execute read-only SQL queries against the connected database

Overview

What is PostgreSQL?

A Model Context Protocol server that provides read-only access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute read-only SQL queries.

How to use PostgreSQL?

Use the server with Claude Desktop by adding configuration to claude_desktop_config.json. Run via Docker (docker run -i --rm mcp/postgres postgresql://...) or NPX (npx -y @modelcontextprotocol/server-postgres postgresql://...). Replace the connection string with your database URL.

Key features of PostgreSQL

Execute read-only SQL queries via the query tool.
All queries run within a READ ONLY transaction.
Automatically discover table schemas as JSON resources.
Schema resources include column names and data types.
Connect to any PostgreSQL database via connection string.

Use cases of PostgreSQL

Let an LLM explore a database schema before generating queries.
Allow an LLM to run safe, read-only analytical queries.
Provide structured schema context to improve LLM query accuracy.

Frequently asked questions

What exactly does this MCP server do?

It provides read-only database access: it can inspect schemas and execute read-only SQL queries, but never writes data.

How do I connect to my PostgreSQL database?

Provide a PostgreSQL connection URL (e.g., `postgresql://user:password@host:port/db-name`) as a command argument when using Docker or NPX.

Is the server read-only?

Yes. All queries are executed within a READ ONLY transaction, preventing any modifications.

What are the runtime requirements?

The server can be run via Docker (using the `mcp/postgres` image) or Node.js via NPX (using the `@modelcontextprotocol/server-postgres` package). No other dependencies are listed.

How is authentication handled?

Authentication is managed through the PostgreSQL connection URL, which can include username and password directly in the URL string.

Comments

More Developer Tools MCP servers

Moxie Docs

Jackalope-Dev

Automated codebase documentation for GitHub: searchable docs, MCP context for AI agents, doc drift detection, and Friday Cleanup PRs.

OrangePro

Aamir Siddiqui

OrangePro local-first CLI + MCP server for behavior mapping, grounded test generation, and dynamic proof.

LastPing

Know when your AI agents, cron jobs and CI pipelines fail, stall or go quiet. Your agent sets up monitors from a plain description, tells you what is broken and why, reads run history and traces, and writes notes on inci

LocalCan

Gives AI agents public URLs (tunnels) for localhost, live HTTP traffic inspection, snapshot publishing, and access control. Part of LocalCan, the ngrok alternative for Mac, Windows and Linux. Free plan.

Nebelus

Nebelus is an enterprise agentic-AI platform for regulated industries. This MCP server exposes the Nebelus Construction API: ~48 tools that give an MCP client full agent build parity — create/update/probe agents, edit ag