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 codeLet an agent explore a production schema safely
- Kind
- MCP serverMCP server
- Pricing
- Open sourceOpen source
- Platforms
- CLI, Linux, macOS, Windows, self-hostedCLI, 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 riskLet 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.