Repository files navigation

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

DBHub is a Minimal Database MCP Server implementing the Model Context Protocol (MCP) server interface. This lightweight gateway allows MCP-compatible clients to connect to and explore different databases:

• Minimal Design: Just two general MCP tools (execute_sql, search_objects) for token-efficient operations, plus support for custom tools
• Multi-Database Support: Single interface for PostgreSQL, MySQL, MariaDB, SQL Server, and SQLite
• Secure Access: Read-only mode, SSH tunneling, and SSL/TLS encryption support
• Multiple Connections: Connect to multiple databases simultaneously with TOML configuration
• Production-Ready: Row limiting, lock timeout control, and connection pooling
• MCP Native: Full implementation of Model Context Protocol with comprehensive tools

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

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 yourdbhub.toml configuration file

See the fullInstallation Guide for detailed instructions.

Docker:

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:

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

Demo Mode:

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

SeeServer Options for all available parameters.

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

SeeMulti-Database Configuration for complete setup instructions.

1. Install dependencies:

   pnpm install

2. Run in development mode:

   pnpm dev

3. Build for production:

   pnpm buildpnpm start --transport stdio --dsn"postgres://user:password@localhost:5432/dbname?sslmode=disable"

SeeTESTING.md.

SeeDebug.