Back to Browse

Dbhub MCP Server

Developer ToolsLow Risk8.7MCP RegistryLocal
Free

Server data from the Official MCP Registry

Minimal, token-efficient Database MCP Server for PostgreSQL, MySQL, SQL Server, SQLite, MariaDB

About

Minimal, token-efficient Database MCP Server for PostgreSQL, MySQL, SQL Server, SQLite, MariaDB

Security Report

8.7
Low Risk8.7Low Risk

Valid MCP server (3 strong, 1 medium validity signals). 1 code issue detected. 3 known CVEs in dependencies ⚠️ Package registry links to a different repository than scanned source. Imported from the Official MCP Registry. 2 finding(s) downgraded by scanner intelligence.

9 files analyzed · 5 issues found

Security scores are indicators to help you make informed decisions, not guarantees. Always review permissions before connecting any MCP server.

Permissions Required

This plugin requests these system permissions. Most are normal for its category.

file_system

Check that this permission is expected for this type of plugin.

Shell Command Execution

Runs commands on your machine. Be cautious — only use if you trust this plugin.

env_vars

Check that this permission is expected for this type of plugin.

database

Check that this permission is expected for this type of plugin.

What You'll Need

Set these up before or after installing:

Database connection string (e.g., postgres://user:pass@host:5432/db)Required

Environment variable: DSN

Database type: postgres, mysql, mariadb, sqlserver, sqliteOptional

Environment variable: DB_TYPE

Database hostnameOptional

Environment variable: DB_HOST

Database portOptional

Environment variable: DB_PORT

Database usernameOptional

Environment variable: DB_USER

Database passwordRequired

Environment variable: DB_PASSWORD

Database name or SQLite file pathOptional

Environment variable: DB_NAME

Transport mode: stdio or httpOptional

Environment variable: TRANSPORT

HTTP server port (default: 8080)Optional

Environment variable: PORT

Instance identifier for tool namesOptional

Environment variable: ID

SSH server hostnameOptional

Environment variable: SSH_HOST

SSH server port (default: 22)Optional

Environment variable: SSH_PORT

SSH usernameOptional

Environment variable: SSH_USER

SSH passwordRequired

Environment variable: SSH_PASSWORD

Path to SSH private keyOptional

Environment variable: SSH_KEY

SSH key passphraseRequired

Environment variable: SSH_PASSPHRASE

How to Install

Add this to your MCP configuration file:

{
  "mcpServers": {
    "io-github-bytebase-dbhub": {
      "env": {
        "ID": "your-id-here",
        "DSN": "your-dsn-here",
        "PORT": "your-port-here",
        "DB_HOST": "your-db-host-here",
        "DB_NAME": "your-db-name-here",
        "DB_PORT": "your-db-port-here",
        "DB_TYPE": "your-db-type-here",
        "DB_USER": "your-db-user-here",
        "SSH_KEY": "your-ssh-key-here",
        "SSH_HOST": "your-ssh-host-here",
        "SSH_PORT": "your-ssh-port-here",
        "SSH_USER": "your-ssh-user-here",
        "TRANSPORT": "your-transport-here",
        "DB_PASSWORD": "your-db-password-here",
        "SSH_PASSWORD": "your-ssh-password-here",
        "SSH_PASSPHRASE": "your-ssh-passphrase-here"
      },
      "args": [
        "-y",
        "@bytebase/dbhub"
      ],
      "command": "npx"
    }
  }
}

Documentation

View on GitHub

From the project's GitHub README.

[!NOTE]
Brought to you by Bytebase, open-source database governance platform.

            +------------------+    +--------------+    +------------------+
            |                  |    |              |    |                  |
            |                  |    |              |    |                  |
            |  Claude Desktop  +--->+              +--->+    PostgreSQL    |
            |                  |    |              |    |                  |
            |  Claude Code     +--->+              +--->+    SQL Server    |
            |                  |    |              |    |                  |
            |  Cursor          +--->+    DBHub     +--->+    SQLite        |
            |                  |    |              |    |                  |
            |  VS Code         +--->+              +--->+    MySQL         |
            |                  |    |              |    |                  |
            |  Copilot CLI     +--->+              +--->+    MariaDB       |
            |                  |    |              |    |                  |
            |                  |    |              |    |                  |
            +------------------+    +--------------+    +------------------+
                 MCP Clients           MCP Server             Databases

DBHub is a minimal MCP server: token-efficient, zero-dependency, and just two tools by default with opt-in extras. This lightweight gateway allows MCP-compatible clients to connect to and explore different databases:

  • Minimal: Zero dependency, token efficient with a minimal set of MCP tools to maximize context window
  • Multi-Database: PostgreSQL, MySQL, MariaDB, SQL Server, and SQLite through a single interface
  • Multi-Connection: Connect to multiple databases simultaneously with TOML configuration
  • Guardrails: Read-only mode, row limiting, and query timeout to prevent runaway operations
  • Secure Access: SSH tunneling and SSL/TLS encryption

DBHub is the official example in the Claude Code docs for connecting to PostgreSQL via MCP.

Token Efficiency

DBHub loads just 2 tools by default at 1.4k tokens — 13-14x fewer than alternatives — keeping the context window open for your actual work.

MCP ServerDefault ConfigDefault Tools
DBHub1.4k2 (execute_sql, search_objects)
MCP Toolbox19.0k28
Supabase MCP19.3kall

Use Cases

  • Local Development: Schema exploration, query validation, and data debugging with Claude Code, VS Code, Cursor, etc.
  • Non-Technical Access: Expose curated, read-only views to non-technical staff via Claude Desktop, VS Code, Cursor, etc.
  • Multi-Database Consolidation: Replace separate MCP servers for each database with a single DBHub process
  • Production Troubleshooting: Read-only diagnostics with guardrails against runaway queries

Supported Databases

PostgreSQL, MySQL, SQL Server, MariaDB, and SQLite.

MCP Tools

DBHub implements MCP tools for database operations:

  • execute_sql: Execute SQL queries with transaction support and safety controls
  • search_objects: Search and explore database schemas, tables, columns, indexes, and procedures with progressive disclosure
  • explain_sql (opt-in): Show a query's execution plan without running it
  • health_check (opt-in): Report connection pool state and buffer cache hit ratio
  • Custom Tools: Define reusable, parameterized SQL operations in your dbhub.toml configuration file

Workbench

DBHub includes a built-in web interface for interacting with your database tools. It provides a visual way to execute queries, run custom tools, and view request traces without requiring an MCP client.

workbench

Installation

npx @bytebase/dbhub@latest --transport http --port 8080 --dsn "postgres://user:password@localhost:5432/dbname?sslmode=disable"

Also available as:

See the Installation Guide for all options, Command-Line Options for parameters, and Multi-Database Configuration for connecting several databases at once.

Development

Requires Node.js >= 22.5.0 (DBHub uses the built-in node:sqlite module).

# Install dependencies
pnpm install

# Run in development mode
pnpm dev

# Build and run for production
pnpm build && pnpm start --transport stdio --dsn "postgres://user:password@localhost:5432/dbname"

See Testing and Debug.

Contributors

Star History

Reviews

No reviews yet

Be the first to review this server!