readonly-postgres-mcp

MCPReference

by amar141989-dev

Indexed by Glama. No runnable package is published via Glama's API — open the repository for install instructions.

mcpremote-capable

MCP configuration

stdio

Environment

  • PG_SSL

    Enable SSL connection

  • PG_HOST

    PostgreSQL server host

  • PG_PORT

    PostgreSQL server port

  • PG_DATABASE

    Database name

  • PG_MAX_ROWS

    Maximum rows returned by queries

  • PG_PASSWORDsecret

    Database password

  • PG_USERNAME

    Database user with readonly access

  • PG_SEARCH_PATH

    Schema search path

  • PG_MCP_ALLOW_ADHOC

    Allow ad-hoc SQL queries (true/false)

  • PG_STATEMENT_TIMEOUT_MS

    Statement timeout in milliseconds

Install in one click with Zurek

Browse here, install from the native macOS app — pick targets, fill env vars, and write configs safely.