PluginBench
MCP Server
Maintained
MIT

PostgreSQL MCP Server MCP Server

io.github.musaddiq-dev/postgresql-mcp-server

RepositoryRegistry
How to choose

What this kind of tool is for

  • Query, inspect, or seed a database without writing a one-off script.
  • Let your agent look up schema details before it writes migration code.
  • Move a small dataset between tools without leaving the terminal.

How to compare servers like this

Engine match:
Confirm it speaks your exact database and version, not just the family.
Access scope:
Read-only connections are the safe default — start there before granting writes.
Safety rails:
Check whether destructive statements need an explicit confirmation before they run.
Maintenance signal:
Database drivers change; a recently updated tool is less likely to break mid-query.

This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.

What is the PostgreSQL MCP Server MCP server?

Python MCP server for PostgreSQL database inspection and querying

How to install PostgreSQL MCP Server

Copy-paste configuration for popular MCP clients.

transport: stdio
Config generated by PluginBench — verify against the source before use.
Environment / auth
  • POSTGRES_HOST
    required

    PostgreSQL host

  • POSTGRES_PORT
    required

    PostgreSQL port

  • POSTGRES_USER
    required

    PostgreSQL username

  • POSTGRES_PASSWORD
    secret

    PostgreSQL password

  • POSTGRES_DB
    required

    PostgreSQL database name

  • POSTGRES_READ_QUERY_LIMIT

    Maximum rows returned by read queries

~/Library/Application Support/Claude/claude_desktop_config.json
JSON config
{
  "mcpServers": {
    "postgresql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "<YOUR_POSTGRES_HOST>",
        "POSTGRES_PORT": "<YOUR_POSTGRES_PORT>",
        "POSTGRES_USER": "<YOUR_POSTGRES_USER>",
        "POSTGRES_PASSWORD": "<YOUR_POSTGRES_PASSWORD>",
        "POSTGRES_DB": "<YOUR_POSTGRES_DB>",
        "POSTGRES_READ_QUERY_LIMIT": "<YOUR_POSTGRES_READ_QUERY_LIMIT>"
      }
    }
  }
}

Related MCP servers

AWAWS CLI MCP Server logo

Python MCP server for AWS CLI inspection and operations

0
Python
MIT
View repository →
MYMySQL MCP Server logo

Python MCP server for MySQL database inspection and querying

0
Python
MIT
View repository →

Find & fetch research datasets across 17 archives, omics registries, and literature sources.

2
Python
MIT
View repository →
PHphylokit-mcp logo

Phylogenetic inference via IQ-TREE 3 — never returns a topology without its support

0
Python
GPL-2.0
View repository →
DEDeoochform logo

Create forms, read submissions, and build invitations from Claude, ChatGPT, or any MCP client.

0
MIT
View repository →

Write to Figma from any MCP client (Claude Code, Cursor). Complements the read-only official MCP.

1
Astro
MIT
View repository →