DBHub

[!NOTE] Brought to you by Bytebase, open-source database DevSecOps 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 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.

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

Installation

See the full Installation Guide for detailed instructions.

Quick Start

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: (requires Node.js >= 22.5.0)

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

Demo Mode:

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

Restrict to loopback (recommended for production):

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

The HTTP transport defaults to --host 0.0.0.0, exposing DBHub on every network interface. For production, bind to 127.0.0.1 and front DBHub with a reverse proxy (nginx/Caddy) or firewall — DBHub does not authenticate HTTP clients.

The HTTP transport also has built-in DNS-rebinding protection: it only accepts requests whose Host is loopback, this machine's own hostname/IPs, or a name you allow via --allowed-hosts. If a client behind a reverse proxy or custom DNS name gets a 403, add that hostname with --allowed-hosts.

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.