@mhdd_24/pgadmin-mcp

MCP server for PostgreSQL / pgAdmin-style exploration and SQL from Cursor (or any MCP client). Follows the same architecture as flyway-mcp.

Say "pg status", "list postgres tables", or "run this SQL on Dev" in chat — the assistant calls the matching tools.

Full documentation: docs/WIKI.md

Tools

Profiles (no connection details in chat)

1. Put both Dev and QA credentials in mcp.json (PG_DEV_*, PG_QA_*).

2. Say pgprofile=qa or pgprofile=dev — the assistant calls pg_set_profile.

3. Later tools reuse that sticky profile until you switch or the MCP process restarts.

4. Optional one-shot: pass profile: "qa" on a single tool without changing sticky.

5. database still means the logical DB name on that server (e.g. transboard), not the env profile.

Related MCP server: Database Assistant MCP Server

Safety

• Read-only by default — only SELECT / WITH…SELECT / EXPLAIN / SHOW / VALUES

• Set PG_ALLOW_WRITE=true to allow writes (still subject to DB user privileges)

• PG_MAX_ROWS caps returned rows; PG_QUERY_TIMEOUT_MS sets statement timeout

Install / run

cd C:/workspace/pgadmin-mcp
npm install
npm run build
node dist/index.js

Cursor mcp.json

"pgadmin": {
  "command": "node",
  "args": ["C:/workspace/pgadmin-mcp/dist/index.js"],
  "env": {
    "PG_PROFILE": "dev",
    "PG_DEV_HOST": "192.168.1.141",
    "PG_DEV_PORT": "5432",
    "PG_DEV_USER": "postgres",
    "PG_DEV_PASSWORD": "YOUR_PASSWORD",
    "PG_DEV_DATABASE": "postgres",
    "PG_ALLOW_WRITE": "false",
    "PG_MAX_ROWS": "500"
  }
}

Or use discrete PGHOST / PGUSER / PGPASSWORD / PGDATABASE, or a single DATABASE_URL.

Restart Cursor after saving.

Example prompts

• pgprofile=qa

• pgprofile=dev

• pg status

• list databases

• list tables in schema transc for database transboard

• describe table translations schema transc database transboard

• run: SELECT version();