Yugabytedb MCP Server

An [MCP](https://modelcontextprotocol.io/) server for YugabyteDB and PostgreSQL — lets LLMs (Claude Desktop, Cursor, Windsurf, etc.) summarize

Remote serverstreamable-httpPython

What is the Yugabytedb MCP Server?

Yugabytedb mcp server connects Yugabytedb to AI assistants that speak the Model Context Protocol. An MCP server for YugabyteDB and PostgreSQL — lets LLMs (Claude Desktop, Cursor, Windsurf, etc.) summarize schemas, run read-only queries, and execute write statements behind a configurable guardrail layer.

What Yugabytedb does

An MCP server for YugabyteDB and PostgreSQL — lets LLMs (Claude Desktop, Cursor, Windsurf, etc.) summarize schemas, run read-only queries, and execute write statements behind a configurable guardrail layer.

Key capabilities

  • summarize_database — — list tables with columns and row counts for a schema (read-only)
  • run_read_only_query — — execute a SELECT under BEGIN READ ONLY; results returned as JSON (read-only)
  • run_write_query — — INSERT/UPDATE/DELETE/MERGE/TRUNCATE/DDL gated by a guardrail blocklist (destructive, disabled by default — enable with --enable-write-query or YB_MCP_ENABLE_WRITE_QUERY=true)

Requirements

  • Python 3.10+ - uv (recommended) or pip - A reachable YugabyteDB or PostgreSQL database - An MCP client (Claude Desktop, Cursor, Windsurf, etc.)

Practical notes

  • Maintained by yugabyte, written in Python.

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

How to install the Yugabytedb MCP Server

{
  "mcpServers": {
    "yugabytedb": {
      "command": "uvx",
      "args": ["yugabytedb-mcp-server"],
      "env": {
        "YUGABYTEDB_URL": "host=… port=5433 dbname=… user=… password=…"
      }
    }
  }
}

Configuration as documented by the project. Restart the client after saving.

Configuration

  • Python 3.10+ - uv (recommended) or pip - A reachable YugabyteDB or PostgreSQL database - An MCP client (Claude Desktop, Cursor, Windsurf, etc.)
VariableDescriptionRequired
YUGABYTEDB_URLEndpoint or connection string the server talks to.Yes
YB_LOG_LEVELConfiguration value read at startup.Optional
MCP_AUTH_PROVIDERConfiguration value read at startup.Optional
MCP_BASE_URLEndpoint or connection string the server talks to.Yes
COGNITO_USER_POOL_IDConfiguration value read at startup.Optional
COGNITO_AWS_REGIONConfiguration value read at startup.Optional
COGNITO_CLIENT_IDConfiguration value read at startup.Optional
COGNITO_CLIENT_SECRETCredential the server authenticates with.Yes

Frequently asked questions

An [MCP](https://modelcontextprotocol.io/) server for YugabyteDB and PostgreSQL — lets LLMs (Claude Desktop, Cursor, Windsurf, etc.) summarize schemas, run Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.