databasesdeveloper-tools

DBHub (Universal Database Gateway)▌

by bytebase

DBHub: Universal database gateway to view SQLite database, run sequel queries & browse tables. Secure, safe, and easy-to

Provides a universal database gateway for connecting to PostgreSQL, MySQL, SQLite, and DuckDB, enabling table browsing, schema inspection, and read-only SQL queries with built-in safety checks

github stars

★ 2.3K

GitHub Website npm

Zero dependenciesRead-only with safety checksUniversal gateway for 4+ database types

best for

/ Database administrators managing multiple database types
/ Developers querying databases from AI tools
/ Data analysts exploring database schemas

capabilities

/ Execute SQL queries across multiple database types
/ Browse database tables and schemas
/ Search database objects like tables and columns
/ Inspect database structure and metadata

what it does

Connects to PostgreSQL, MySQL, SQLite, and DuckDB databases through a unified interface. Execute read-only SQL queries and browse database schemas safely.

about

DBHub (Universal Database Gateway) is an official MCP server published by bytebase that provides AI assistants with tools and capabilities via the Model Context Protocol. DBHub: Universal database gateway to view SQLite database, run sequel queries & browse tables. Secure, safe, and easy-to It is categorized under databases, developer tools. This server exposes 2 tools that AI clients can invoke during conversations and coding sessions.

how to install

You can install DBHub (Universal Database Gateway) in your AI client of choice. Use the install panel on this page to get one-click setup for Cursor, Claude Desktop, VS Code, and other MCP-compatible clients. This server runs locally on your machine via the stdio transport.

license

MIT

DBHub (Universal Database Gateway) is released under the MIT license. This is a permissive open-source license, meaning you can freely use, modify, and distribute the software.

readme

[!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.

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:

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

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

# 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