MCP Toolbox for Databases

Name: MCP Toolbox for Databases
Author: Google APIs

Lets an assistant explore schemas and query databases: PostgreSQL, MySQL, BigQuery, Spanner, Snowflake.

Official · Google APIs Go Local · stdio Databases

GitHub Website

92 popularity score ★ 17k ↓ 42k/wk

Connect your client

Local (npm)

Add in one click

Add to Cursor Add to VS Code Add to LM Studio Add to Goose

Opens the app, which asks before it adds the server. Then replace each <NAME> in its settings with your value.

Or add it by command or config

It needs POSTGRES_DATABASE, POSTGRES_USER, POSTGRES_PASSWORD. Replace each <NAME> with your value.

Claude CodeTerminal

claude mcp add toolbox-for-databases -e POSTGRES_DATABASE=<POSTGRES_DATABASE> -e POSTGRES_USER=<POSTGRES_USER> -e POSTGRES_PASSWORD=<POSTGRES_PASSWORD> -- npx -y @toolbox-sdk/server --prebuilt=postgres --stdio

Claude Desktopclaude_desktop_config.json

{
  "mcpServers": {
    "toolbox-for-databases": {
      "command": "npx",
      "args": [
        "-y",
        "@toolbox-sdk/server",
        "--prebuilt=postgres",
        "--stdio"
      ],
      "env": {
        "POSTGRES_DATABASE": "<POSTGRES_DATABASE>",
        "POSTGRES_USER": "<POSTGRES_USER>",
        "POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>"
      }
    }
  }
}

Cursor~/.cursor/mcp.json

{
  "mcpServers": {
    "toolbox-for-databases": {
      "command": "npx",
      "args": [
        "-y",
        "@toolbox-sdk/server",
        "--prebuilt=postgres",
        "--stdio"
      ],
      "env": {
        "POSTGRES_DATABASE": "<POSTGRES_DATABASE>",
        "POSTGRES_USER": "<POSTGRES_USER>",
        "POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>"
      }
    }
  }
}

VS Code.vscode/mcp.json

{
  "servers": {
    "toolbox-for-databases": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@toolbox-sdk/server",
        "--prebuilt=postgres",
        "--stdio"
      ],
      "env": {
        "POSTGRES_DATABASE": "<POSTGRES_DATABASE>",
        "POSTGRES_USER": "<POSTGRES_USER>",
        "POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>"
      }
    }
  }
}

Codex~/.codex/config.toml

[mcp_servers.toolbox-for-databases]
command = "npx"
args = ["-y", "@toolbox-sdk/server", "--prebuilt=postgres", "--stdio"]

[mcp_servers.toolbox-for-databases.env]
POSTGRES_DATABASE = "<POSTGRES_DATABASE>"
POSTGRES_USER = "<POSTGRES_USER>"
POSTGRES_PASSWORD = "<POSTGRES_PASSWORD>"

Gemini CLITerminal

gemini mcp add --scope user -e POSTGRES_DATABASE=<POSTGRES_DATABASE> -e POSTGRES_USER=<POSTGRES_USER> -e POSTGRES_PASSWORD=<POSTGRES_PASSWORD> toolbox-for-databases npx -- -y @toolbox-sdk/server --prebuilt=postgres --stdio

Settings 6

`POSTGRES_HOST`	Optional: PostgreSQL host (PostgreSQL prebuilt).
`POSTGRES_PORT`	Optional: PostgreSQL port.
`POSTGRES_DATABASE`	Required: Database name.
`POSTGRES_USER`	Required: Database user.
`POSTGRES_PASSWORD`	Required: Database password.
`POSTGRES_QUERY_PARAMS`	Optional: Extra connection query parameters.

What it does

MCP Toolbox for Databases is Google's open-source MCP server for connecting assistants, IDEs and agents to databases (formerly Gen AI Toolbox for Databases). It serves two purposes. As a ready-to-use server, a --prebuilt flag loads generic tools for one database, so an assistant can list tables and schemas, run SQL, inspect query plans and check performance and configuration. Prebuilt configs cover Google Cloud databases (AlloyDB, BigQuery, Cloud SQL, Spanner, Firestore, Bigtable, Knowledge Catalog) and others including PostgreSQL, MySQL, SQL Server, Oracle, MongoDB, Redis, Elasticsearch, Neo4j, ClickHouse, Snowflake, SQLite and more.

As a framework, a tools.yaml file defines sources, custom tools (structured queries, semantic search, NL2SQL), toolsets and prompts for production agents, with connection pooling, IAM-integrated auth and OpenTelemetry tracing; SDKs exist for Python, JavaScript, Go and Java.

The quick start runs npx -y @toolbox-sdk/server --prebuilt=postgres --stdio, with connection settings in environment variables; change postgres to the database you use (the tools listed here are the PostgreSQL prebuilt set). Binaries and a container image are also published, and the server can run over HTTP. Google also offers managed MCP servers for its cloud databases.

What it needs

Runtime	Node.js

Tools 29

execute_sql: Executes a SQL query (PostgreSQL prebuilt).
list_tables: Lists tables in the database (PostgreSQL prebuilt).
list_schemas: Lists schemas in the database (PostgreSQL prebuilt).
list_views: Lists views with schema name, view name and owner (PostgreSQL prebuilt).
list_indexes: List available user indexes (PostgreSQL prebuilt).
list_sequences: List sequences in the database (PostgreSQL prebuilt).
list_triggers: Lists triggers in the database (PostgreSQL prebuilt).
list_stored_procedure: Lists stored procedures (PostgreSQL prebuilt).
get_query_plan: Generate the execution plan of a statement (PostgreSQL prebuilt).
database_overview: Fetches current state of the PostgreSQL server (PostgreSQL prebuilt).
list_active_queries: Lists ongoing queries (PostgreSQL prebuilt).
long_running_transactions: Identifies transactions exceeding a specified time limit (PostgreSQL prebuilt).
list_locks: Identifies all locks held by active processes (PostgreSQL prebuilt).
list_query_stats: Lists query statistics (PostgreSQL prebuilt).
list_table_stats: Lists table statistics (PostgreSQL prebuilt).
list_database_stats: Lists key performance statistics for each database (PostgreSQL prebuilt).
get_column_cardinality: Gets column cardinality (PostgreSQL prebuilt).
list_top_bloated_tables: List top bloated tables (PostgreSQL prebuilt).
list_invalid_indexes: Lists invalid indexes (PostgreSQL prebuilt).
list_available_extensions: Discover all PostgreSQL extensions available (PostgreSQL prebuilt).
list_installed_extensions: List all installed PostgreSQL extensions (PostgreSQL prebuilt).
list_autovacuum_configurations: Lists autovacuum configurations (PostgreSQL prebuilt).
list_memory_configurations: Lists memory-related configurations (PostgreSQL prebuilt).
list_pg_settings: List configuration parameters for the PostgreSQL server (PostgreSQL prebuilt).
replication_stats: Lists each replica's process ID and sync state (PostgreSQL prebuilt).
list_replication_slots: Lists replication slots (PostgreSQL prebuilt).
list_publication_tables: List publication tables (PostgreSQL prebuilt).
list_tablespaces: Lists tablespaces in the database (PostgreSQL prebuilt).
list_roles: Lists all user-created roles in the database (PostgreSQL prebuilt).

Popularity

92 popularity score, on our list (the bar is 36)

★ 17k ↓ 42k/wk

GitHub stars, whole repository	16,819	37 points
Stars in 30 days	+207	10 points
npm downloads, last week	42,037	37 points
Official server	Yes	8 points

It lives in the folder npm/server of googleapis/mcp-toolbox, which holds more than this server. Its stars are the whole repository's, so in the score they never count for more than its own downloads.

Measured 2026-11-07. How the score works.

Where it is published

Code	googleapis/mcp-toolbox/npm/server ★ 17k, the whole repository
npm	@toolbox-sdk/server 1.16.0, 2026-11-05

What it can reach

Runs	On your machine
Reaches	A database, The internet, Cloud resources
Changes things	Yes: it can write, send, create or delete
Sign-in	Other
Licence	Apache-2.0 (npm)
Last code change	2026-11-05 (a release)

Runs on your machine (or as your own server) and connects to the database with the credentials you provide, so it can do what that database user can. The prebuilt execute_sql tool runs arbitrary SQL, including writes, so a read-only database user limits it; toolsets such as --prebuilt=postgres/data narrow the tools loaded. Custom tools defined in tools.yaml can restrict access to structured queries. For Google Cloud databases it uses your Google Cloud credentials (IAM). Telemetry is exported only when you configure an OpenTelemetry endpoint.

Over time

GitHub stars, whole repository 17k +207 (+1 %)

17k17k

7 Oct 20267 Nov 2026

npm downloads a week 42k +41k (+3456 %)

116k912

8 Dec 20257 Nov 2026

Before the site measured it, read from npm's daily download counts.

Popularity score 92 +33 (+57 %)

938

7 Oct 20267 Nov 2026

What is rising across the directory

Sources

Page checked 2026-10-07.

Badge for your README

Shows this server's rank in its category, and stars for a server that runs on your machine. It updates every hour.

MarkdownREADME.md

[![MCP Toolbox for Databases on EveryMCPServer](https://everymcpserver.com/badge/mcp-toolbox-for-databases-2.svg)](https://everymcpserver.com/servers/mcp-toolbox-for-databases-2)

Connect your client

Add in one click

Or add it by command or config

Settings 6

What it does

What it needs

Tools 29

Similar servers

MCPQL

PostgreSQL MCP Server

MySQL MCP Server

ClickHouse MCP Server

PostgREST MCP Server

OmniSQL MCP