DBeast PostgreSQL MCP

Official

by snss10 · Python

PostgreSQL MCP server for schema, query, health, security, and performance analysis.

PostgreSQL management tool for schema, queries, health checks, and performance analysis.

Topics

ai-toolsasyncpgclaudecursordatabasedbamcpmodel-context-protocolpostgresqlpythonsqlmcp-serverstdio-mcp

Install

Configuration

Environment variables

DATABASE_URLsecret

PostgreSQL connection URL, for example postgresql://user:password@host:5432/database.

DB_HOST

PostgreSQL host when DATABASE_URL is not used.

DB_PORT

PostgreSQL port when DATABASE_URL is not used.

DB_USER

PostgreSQL user when DATABASE_URL is not used.

DB_PASSWORDsecret

PostgreSQL password when DATABASE_URL is not used.

DB_NAME

PostgreSQL database name when DATABASE_URL is not used.

AWS_SECRET_NAME

AWS Secrets Manager secret containing PostgreSQL credentials.

AWS_REGION

AWS region for Secrets Manager lookup.

Add to VS Code Add to Cursor

claude_desktop_config.json

json

{
  "mcpServers": {
    "dbeast": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/snss10/dbeast:2.0.2"
      ],
      "env": {
        "DATABASE_URL": "<YOUR_DATABASE_URL>",
        "DB_HOST": "<YOUR_DB_HOST>",
        "DB_PORT": "<YOUR_DB_PORT>",
        "DB_USER": "<YOUR_DB_USER>",
        "DB_PASSWORD": "<YOUR_DB_PASSWORD>",
        "DB_NAME": "<YOUR_DB_NAME>",
        "AWS_SECRET_NAME": "<YOUR_AWS_SECRET_NAME>",
        "AWS_REGION": "<YOUR_AWS_REGION>"
      }
    }
  }
}