DBHub Analytics

DBHub Analytics

Universal Database MCP Server for Databricks, Google BigQuery, PostgreSQL, MySQL, SQL Server, SQLite, MariaDB

[npm version] [License: MIT]

Built on top of DBHub by Bytebase.

What is DBHub Analytics?

DBHub Analytics is an open-source MCP (Model Context Protocol) server that connects AI assistants like Claude Desktop, Claude Code, Cursor, VS Code Copilot, and other MCP-compatible clients to your databases. Query Databricks SQL warehouses, Google BigQuery datasets, PostgreSQL, MySQL, and more — all through a single unified interface.

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

Key Features

• Cloud Data Warehouses: Connect to Databricks SQL and Google BigQuery for analytics workloads
• Traditional Databases: Full support for PostgreSQL, MySQL, MariaDB, SQL Server, SQLite
• Multi-Database: Connect to multiple databases simultaneously with a single TOML config file
• Schema Explorer: Progressive disclosure — browse catalogs, datasets, schemas, tables, and columns
• Safety Guardrails: Read-only mode, row limits, and query timeouts to prevent runaway operations
• Secure Access: SSH tunneling, SSL/TLS encryption, and service account authentication
• Zero Config: Just provide a DSN — no drivers to install, no complex setup

Supported Databases

MCP Tools

Quick Start

NPM (recommended)

npx dbhub-analytics --dsn "postgres://user:password@localhost:5432/dbname"

Databricks SQL

npx dbhub-analytics --dsn "databricks://token:[email protected]/sql/2.0/warehouses/your_warehouse_id"

Google BigQuery

npx dbhub-analytics --dsn "bigquery://your-gcp-project/your_dataset?keyFile=/path/to/service-account.json&location=US"

Docker

docker run --rm --init \   --name dbhub-analytics \   --publish 8080:8080 \   amansingh63/dbhub-analytics \   --transport http \   --port 8080 \   --dsn "postgres://user:password@localhost:5432/dbname"

Demo Mode

npx dbhub-analytics --demo

Connect to Your AI Assistant

Claude Desktop / Claude Code

Add to your claude_desktop_config.json or .mcp.json:

{  "mcpServers": {    "dbhub-analytics": {      "command": "npx",      "args": ["-y", "dbhub-analytics", "--dsn", "bigquery://your-project/your_dataset?keyFile=/path/to/sa.json&location=US"]    }  }}

GitHub Copilot (VS Code)

Add to your .vscode/mcp.json:

{  "servers": {    "dbhub-analytics": {      "command": "npx",      "args": ["-y", "dbhub-analytics", "--dsn", "postgres://user:pass@localhost:5432/dbname"]    }  }}

Cursor

Add to your Cursor MCP settings (~/.cursor/mcp.json):

{  "mcpServers": {    "dbhub-analytics": {      "command": "npx",      "args": ["-y", "dbhub-analytics", "--dsn", "databricks://token:YOUR_TOKEN@host/sql/2.0/warehouses/ID"]    }  }}

Windsurf

Add to your Windsurf MCP config (~/.codeium/windsurf/mcp_config.json):

{  "mcpServers": {    "dbhub-analytics": {      "command": "npx",      "args": ["-y", "dbhub-analytics", "--dsn", "mysql://user:pass@localhost:3306/dbname"]    }  }}

Multi-Database via TOML Config

For connecting to multiple databases, use a TOML config file with any of the above clients:

{  "mcpServers": {    "dbhub-analytics": {      "command": "npx",      "args": ["-y", "dbhub-analytics", "--config", "/path/to/dbhub.toml"]    }  }}

Configuration

DSN Connection Strings

Multi-Database Setup (TOML)

Connect to multiple databases simultaneously. Create a dbhub.toml file:

[[sources]]id = "databricks_prod"type = "databricks"host = "adb-xxx.azuredatabricks.net"password = "dapi..."path = "/sql/2.0/warehouses/abc123"
[[sources]]id = "bigquery_analytics"type = "bigquery"project = "my-gcp-project"database = "analytics_dataset"location = "US"
[[sources]]id = "postgres_prod"type = "postgres"host = "localhost"port = 5432database = "production"user = "dbuser"password = "secret"

Then run:

npx dbhub-analytics --config dbhub.toml

See Multi-Database Configuration and Command-Line Options for complete documentation.

Use Cases

• Data Analysts: Ask Claude to query your Databricks or BigQuery data warehouse in natural language
• Backend Engineers: Explore database schemas, run diagnostic queries, and debug issues via AI
• DevOps/SRE: Connect to production read-replicas safely with read-only mode and row limits
• Data Scientists: Query multiple databases simultaneously — join insights across PostgreSQL and BigQuery

Development

# Install dependenciespnpm install
# Run in development modepnpm dev
# Build for productionpnpm build
# Run testspnpm test

Credits

Built on top of DBHub by Bytebase, an open-source database DevSecOps platform. Licensed under MIT.