English Français العربية

DBHub

السجل الرسمي البيانات وقواعدها

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

الشيفرة المصدرية التوثيق

ماذا يمكنك أن تفعل مع 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

التثبيت

أضف هذا إلى إعدادات MCP في عميلك (Claude Desktop: claude_desktop_config.json، وCursor: ‏.cursor/mcp.json، ويستخدم VS Code وغيره الصيغة نفسها «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
إعداد 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>"
            }
        }
    }
}

متغيرات البيئة

  • DSN سري 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 سري 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 سري SSH password
  • SSH_KEY Path to SSH private key
  • SSH_PASSPHRASE سري SSH key passphrase
  • SSH_AUTH_SOCK Path to SSH agent socket

التوثيق

مأخوذ من ملف README للمشروع على GitHub ويُحدَّث أسبوعيًا. تفتح الروابط على GitHub.

المحتويات
  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

الأسئلة الشائعة

ما هو DBHub؟

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

كيف أثبّت 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. وفي العملاء الآخرين، الصق إعداد JSON من هذه الصفحة في إعدادات MCP الخاصة بهم.

هل يحتاج DBHub إلى مفتاح API؟

نعم. يتطلب DSN, DB_PASSWORD, SSH_PASSWORD, SSH_PASSPHRASE، وتضبطها في إعداداته.

هل DBHub مفتوح المصدر؟

نعم. شيفرته متاحة على GitHub بترخيص MIT.

من يصون DBHub؟

ينشره bytebase. يدرجه AI.tn لكنه لا يصونه ولا يوصي به.

من سجل MCP الرسمي. الإدراج ليس توصية: راجع شيفرة الخادم وصلاحياته قبل منحه الوصول إلى بياناتك.