dbhub
DBHub is a universal database gateway enabling MCP-compatible clients to explore and interact with various databases. It supports secure connections, read-only modes, and is equipped with tools for SQL execution and database analysis. The gateway facilitates integration with clients using either `stdio` or `sse` transports.
Overview
DBHub is a universal database gateway that implements the Model Context Protocol (MCP) server interface. It allows MCP-compatible clients to connect and interact with various databases including PostgreSQL, SQL Server, SQLite, MySQL, MariaDB, and Oracle. Key features include SQL execution, listing of database connectors, generating SQL commands, and explaining database elements. The gateway supports SSL connections, read-only mode for added security, and demo mode with a sample employee database.
Installation
- Docker: Use Docker to run DBHub with support for multiple databases.
- NPM: Install via NPM for direct usage in Node.js environments.
Usage
- Supports both
stdio
andsse
transport modes for integration with different clients. - Read-only mode restricts operations to non-destructive queries.
Supported Databases
-
PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, Oracle
-
Provides command-line options for transport modes, server ports, and demo settings.