Skip to content

GaussDB Read-Only MCP vs Pg Readonly MCP

GaussDB Read-Only MCP is an open-source MCP server for databases. Pg Readonly MCP is an open-source MCP server for databases.

  • GaussDB Read-Only MCP is best for letting a coding agent explore a gaussdb schema while writing application code.
  • Pg Readonly MCP is best for let an agent explore a production schema safely.
What it is
GaussDB Read-Only MCP is an open-source MCP server for databases.
Pg Readonly MCP is an open-source MCP server for databases.
Best for
Letting a coding agent explore a GaussDB schema while writing application code
Let an agent explore a production schema safely
Kind
MCP server
MCP server
Pricing
Open source
Open source
Platforms
CLI, Linux, macOS, Windows, self-hosted
CLI, self-hosted
Runs
Locally
GitHub stars
1
Last commit
Oct 2026
License
Apache-2.0
Open source
Good for
Letting a coding agent explore a GaussDB schema while writing application code; Checking table structure, indexes and partitions before writing a migration; Running ad hoc read queries against a production-like database without write risk
Let an agent explore a production schema safely; Answer data questions with SELECT-only access; Replace a read-only transaction approach with a parser-based guard

What GaussDB Read-Only MCP does

  • Static SQL validation

    Rejects DML, DDL, SELECT INTO, row locks, multi-statement input and a configurable list of dangerous functions before execution.

  • Server-side read-only transactions

    Each query runs in an explicit transaction set to READ ONLY, with a statement timeout applied.

  • Multi-instance configuration

    A single YAML file defines several database instances, and tools pick one through the instance argument.

  • Schema and table inspection

    Tools list schemas and tables and describe columns, constraints, indexes, views and partitions.

  • Row-limited SELECT execution

    Returns column names, rows and a truncation flag, with default and capped row limits.

  • Single static binary

    Built with CGO disabled and an embedded driver copy, so it can be deployed offline on intranet hosts.

What Pg Readonly MCP does

  • SQL parsed, not scanned

    Builds a syntax tree instead of pattern-matching text.

  • Single statement only

    Multi-statement payloads are refused before reaching the database.

  • Deep write detection

    Walks the whole tree to find writes hidden inside CTEs.

  • Startup privilege check

    Refuses roles with superuser, create or non-SELECT grants.

  • Row caps and timeout

    Limits the cost of legal but heavy queries.

  • Honest limits

    Documents what the guards cannot catch.

GaussDB Read-Only MCP vs Pg Readonly MCP: questions

Is GaussDB Read-Only MCP or Pg Readonly MCP cheaper?

Both are open source. Compare current plans on each official site.

What is the difference between GaussDB Read-Only MCP and Pg Readonly MCP?

GaussDB Read-Only MCP is an open-source MCP server for databases. Pg Readonly MCP is an open-source MCP server for databases.

Keep comparing