io.github.bytebase/dbhub

Name: io.github.bytebase/dbhub
Rating: 5 (2785 reviews)
Author: bytebase

数据与存储编辑精选

by bytebase

DBHub 是让 Claude 等 AI 助手直接查询和探索多种数据库的轻量级网关。

如果你想让 AI 助手帮你分析数据库结构或执行安全查询，DBHub 就是那个桥梁。它支持 PostgreSQL、MySQL 等主流数据库，配置简单，还内置了只读模式和行数限制来防止误操作。不过，目前它只提供两个核心工具，复杂的数据操作还得靠你自己写 SQL。适合需要快速探索数据库的开发者，但别指望它替代完整的数据库管理工具。

2.8kGitHub

什么是 io.github.bytebase/dbhub？

DBHub 是让 Claude 等 AI 助手直接查询和探索多种数据库的轻量级网关。

README

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

bash

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

DBHub is a zero-dependency, token efficient MCP server implementing the Model Context Protocol (MCP) server interface. This lightweight gateway allows MCP-compatible clients to connect to and explore different databases:

Local Development First: Zero dependency, token efficient with just two 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

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
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

See the full Installation Guide for detailed instructions.

Quick Start

Docker:

bash

docker run --rm --init \
   --name dbhub \
   --publish 8080:8080 \
   bytebase/dbhub \
   --transport http \
   --port 8080 \
   --dsn "postgres://user:password@localhost:5432/dbname?sslmode=disable"

NPM:

bash

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

Demo Mode:

bash

npx @bytebase/dbhub@latest --transport http --port 8080 --demo

See Command-Line Options for all available parameters.

Multi-Database Setup

Connect to multiple databases simultaneously using TOML configuration files. Perfect for managing production, staging, and development databases from a single DBHub instance.

See Multi-Database Configuration for complete setup instructions.

Development

bash

# 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

常见问题