DBHub

Registre officiel Données et bases de données

Token-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite

Que pouvez-vous faire avec DBHub ?

  • 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

Installation

Ajoutez ceci à la configuration MCP de votre client (Claude Desktop : claude_desktop_config.json ; Cursor : .cursor/mcp.json ; VS Code et les autres utilisent la même forme « mcpServers »).

NPM package @bytebase/dbhub
Claude Code
claude mcp add dbhub -e 'DSN=<your dsn>' -e 'DB_TYPE=<DB_TYPE>' -e 'DB_HOST=<DB_HOST>' -e 'DB_PORT=<DB_PORT>' -e 'DB_USER=<DB_USER>' -e 'DB_PASSWORD=<your db_password>' -e 'DB_NAME=<DB_NAME>' -e 'TRANSPORT=<TRANSPORT>' -e 'PORT=<PORT>' -e 'ID=<ID>' -e 'SSH_HOST=<SSH_HOST>' -e 'SSH_PORT=<SSH_PORT>' -e 'SSH_USER=<SSH_USER>' -e 'SSH_PASSWORD=<your ssh_password>' -e 'SSH_KEY=<SSH_KEY>' -e 'SSH_PASSPHRASE=<your ssh_passphrase>' -e 'SSH_AUTH_SOCK=<SSH_AUTH_SOCK>' -- npx -y @bytebase/dbhub@1.5.0
Configuration JSON (Claude Desktop, Cursor, VS Code)
{
    "mcpServers": {
        "dbhub": {
            "command": "npx",
            "args": [
                "-y",
                "@bytebase/dbhub@1.5.0"
            ],
            "env": {
                "DSN": "<your dsn>",
                "DB_TYPE": "<DB_TYPE>",
                "DB_HOST": "<DB_HOST>",
                "DB_PORT": "<DB_PORT>",
                "DB_USER": "<DB_USER>",
                "DB_PASSWORD": "<your db_password>",
                "DB_NAME": "<DB_NAME>",
                "TRANSPORT": "<TRANSPORT>",
                "PORT": "<PORT>",
                "ID": "<ID>",
                "SSH_HOST": "<SSH_HOST>",
                "SSH_PORT": "<SSH_PORT>",
                "SSH_USER": "<SSH_USER>",
                "SSH_PASSWORD": "<your ssh_password>",
                "SSH_KEY": "<SSH_KEY>",
                "SSH_PASSPHRASE": "<your ssh_passphrase>",
                "SSH_AUTH_SOCK": "<SSH_AUTH_SOCK>"
            }
        }
    }
}

Variables d'environnement

  • DSN secret Database connection string (e.g., postgres://user:pass@host:5432/db)
  • DB_TYPE Database type: postgres, mysql, mariadb, sqlserver, oracle, sqlite
  • DB_HOST Database hostname
  • DB_PORT Database port
  • DB_USER Database username
  • DB_PASSWORD secret Database password
  • DB_NAME Database name or SQLite file path
  • TRANSPORT Transport mode: stdio or http
  • PORT HTTP server port (default: 8080)
  • ID Instance identifier for tool names
  • SSH_HOST SSH server hostname
  • SSH_PORT SSH server port (default: 22)
  • SSH_USER SSH username
  • SSH_PASSWORD secret SSH password
  • SSH_KEY Path to SSH private key
  • SSH_PASSPHRASE secret SSH key passphrase
  • SSH_AUTH_SOCK Path to SSH agent socket

Documentation

Tirée du README du projet sur GitHub, actualisée chaque semaine. Les liens ouvrent GitHub.

Sommaire
  1. Token Efficiency
  2. Use Cases
  3. Supported Databases
  4. MCP Tools
  5. Workbench
  6. Installation
  7. Development
  8. Contributors
  9. Star History

[!NOTE]
If you need an enterprise-level database MCP server with built-in guardrails like approval flow, access control, data masking, and audit logging beyond what DBHub offers, check out Bytebase.

            +------------------+    +--------------+    +------------------+
            |                  |    |              |    |                  |
            |  Claude Desktop  +--->+              +--->+    PostgreSQL    |
            |                  |    |              |    |                  |
            |  Claude Code     +--->+              +--->+    SQL Server    |
            |                  |    |              |    |                  |
            |  Cursor          +--->+    DBHub     +--->+    Oracle        |
            |                  |    |              |    |                  |
            |  VS Code         +--->+              +--->+    SQLite        |
            |                  |    |              |    |                  |
            |  Copilot CLI     +--->+              +--->+    MySQL         |
            |                  |    |              |    |                  |
            |                  |    |              +--->+    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, Oracle, 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, Oracle, 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.

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

Questions fréquentes

Qu'est-ce que DBHub ?

Token-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite

Comment installer DBHub ?

Il s'exécute sur votre machine. Dans Claude Code : claude mcp add dbhub -e 'DSN=<your dsn>' -e 'DB_TYPE=<DB_TYPE>' -e 'DB_HOST=<DB_HOST>' -e 'DB_PORT=<DB_PORT>' -e 'DB_USER=<DB_USER>' -e 'DB_PASSWORD=<your db_password>' -e 'DB_NAME=<DB_NAME>' -e 'TRANSPORT=<TRANSPORT>' -e 'PORT=<PORT>' -e 'ID=<ID>' -e 'SSH_HOST=<SSH_HOST>' -e 'SSH_PORT=<SSH_PORT>' -e 'SSH_USER=<SSH_USER>' -e 'SSH_PASSWORD=<your ssh_password>' -e 'SSH_KEY=<SSH_KEY>' -e 'SSH_PASSPHRASE=<your ssh_passphrase>' -e 'SSH_AUTH_SOCK=<SSH_AUTH_SOCK>' -- npx -y @bytebase/dbhub@1.5.0. Pour les autres clients, collez la configuration JSON de cette page dans leurs réglages MCP.

Faut-il une clé API pour DBHub ?

Oui. Il attend DSN, DB_PASSWORD, SSH_PASSWORD, SSH_PASSPHRASE, à renseigner dans sa configuration.

DBHub est-il open source ?

Oui. Son code est sur GitHub sous licence MIT.

Qui maintient DBHub ?

Il est publié par bytebase. AI.tn le référence sans le maintenir ni le recommander.

Issu du registre MCP officiel. Être listé n'est pas une recommandation : vérifiez le code et les permissions d'un serveur avant de lui donner accès à vos données.