Is the DBHub Analytics MCP server free to use?

Yes. DBHub Analytics is listed on AllMCPs as a free, open Model Context Protocol server you can install into Claude Desktop, Cursor, or any MCP-compatible client.

Is the DBHub Analytics MCP server free to use?

Yes. DBHub Analytics is listed on AllMCPs as a free, open Model Context Protocol server you can install into Claude Desktop, Cursor, or any MCP-compatible client.

DBHub Analytics

MCP server for Databricks, BigQuery, PostgreSQL, MySQL, SQL Server, SQLite, MariaDB

Quick Install

Automated & IDE Setup

Copy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.

Add to Cursor Add to VS Code

Manual Client & Custom JSON ConfigExpand JSON ▾

Install Config Generator

Choose your client

claude_desktop_config.json

{
  "mcpServers": {
    "dbhub-analytics": {
      "command": "npx",
      "args": [
        "-y",
        "dbhub-analytics"
      ]
    }
  }
}

💡 Paste into ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)

Documentation Overview

DBHub Analytics

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

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.

Code

            +------------------+    +--------------+    +------------------+
            |                  |    |              |    |                  |
            |  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

Database	DSN Protocol	Status
PostgreSQL	`postgres://`	Stable
MySQL	`mysql://`	Stable
MariaDB	`mariadb://`	Stable
SQL Server	`sqlserver://`	Stable
SQLite	`sqlite:///`	Stable
Databricks SQL	`databricks://`	Stable
Google BigQuery	`bigquery://`	Stable

MCP Tools

Tool	Description
`execute_sql`	Execute SQL queries with read-only enforcement and row limiting
`search_objects`	Browse catalogs, schemas, tables, columns, indexes, and routines
Custom Tools	Define reusable, parameterized SQL queries in `dbhub.toml`

Quick Start

NPM (recommended)

Terminal

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

Databricks SQL

Terminal

npx dbhub-analytics --dsn "databricks://token:YOUR_TOKEN@your-workspace.cloud.databricks.com/sql/2.0/warehouses/your_warehouse_id"

Google BigQuery

Terminal

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

Docker

Terminal

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

Terminal

npx dbhub-analytics --demo

Connect to Your AI Assistant

Claude Desktop / Claude Code

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

config.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:

config.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):

config.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):

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:

config.json

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

Configuration

DSN Connection Strings

Database	Format
PostgreSQL	`postgres://user:pass@host:5432/dbname?sslmode=require`
MySQL	`mysql://user:pass@host:3306/dbname`
MariaDB	`mariadb://user:pass@host:3306/dbname`
SQL Server	`sqlserver://user:pass@host:1433/dbname`
SQLite	`sqlite:///path/to/file.db` or `sqlite:///:memory:`
Databricks	`databricks://token:TOKEN@host/sql/2.0/warehouses/ID?catalog=CAT&schema=SCH`
BigQuery	`bigquery://PROJECT_ID/DATASET?keyFile=/path/to/key.json&location=US`

Multi-Database Setup (TOML)

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

toml

[[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 = 5432
database = "production"
user = "dbuser"
password = "secret"

Then run:

Terminal

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

bash

# Install dependencies
pnpm install

# Run in development mode
pnpm dev

# Build for production
pnpm build

# Run tests
pnpm test

Credits

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

Related MCP Servers

View all in Databases View all alternatives

Frequently Asked Questions about DBHub Analytics

Add the following block to your claude_desktop_config.json under mcpServers: "mcpServers": { "dbhub-analytics": { "command": "npx", "args": ["-y", "DBHub Analytics"] } }

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:

Live Dynamic SVG Preview

Markdown (GitHub README)

[![AllMCPs](https://allmcps.com/api/badge/dbhub-analytics?style=directory)](https://allmcps.com/mcp/dbhub-analytics)

HTML Embed

<a href="https://allmcps.com/mcp/dbhub-analytics"><img src="https://allmcps.com/api/badge/dbhub-analytics?style=directory" alt="DBHub Analytics on AllMCPs" /></a>

Technical Specs & Signals

CategoryDatabases

27Quality signal: Emerging · 27/100How this signal is calculated ▾

Server availabilityNot measured

Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.

Verified ownership8/20

Documentation & tools11/30

Adoption & activity1/15

Community engagement0/10

A guidance signal from public completeness & health data — not a user rating. New listings start lower and rise as they add docs, get verified, and grow adoption. Signals we can't observe for a listing are skipped, not counted against it.

★ Featured

Moxie Docs MCP

MCP & Agent Skills for Automated Documentation, and codebase conventions + context

Explore Server →

Own this project?

This directory is pre-filled from public sources. Claim via GitHub README, site badge, or DNS TXT to get the verified badge and attach your website.

Free dofollow backlink: after claiming, verify your product site and place a dofollow AllMCPs badge — we recheck it stays live.

Claim & get free dofollow

Share & Embed

Add our SVG badge (dark/light directory styles) or embeddable widget to your site.

Explore more

More in 🗄️ Databases →Best MCP servers for Databases →Alternatives to DBHub Analytics →Install in Claude Desktop Install in Cursor Install in VS Code

DBHub Analytics

MCP server for Databricks, BigQuery, PostgreSQL, MySQL, SQL Server, SQLite, MariaDB

Quick Install

Automated & IDE Setup

Copy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.

Add to Cursor Add to VS Code

Manual Client & Custom JSON ConfigExpand JSON ▾

Install Config Generator

Choose your client

claude_desktop_config.json

{
  "mcpServers": {
    "dbhub-analytics": {
      "command": "npx",
      "args": [
        "-y",
        "dbhub-analytics"
      ]
    }
  }
}

💡 Paste into ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)

Documentation Overview

DBHub Analytics

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

Built on top of DBHub by Bytebase.

What is DBHub Analytics?

Code

            +------------------+    +--------------+    +------------------+
            |                  |    |              |    |                  |
            |  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

Database	DSN Protocol	Status
PostgreSQL	`postgres://`	Stable
MySQL	`mysql://`	Stable
MariaDB	`mariadb://`	Stable
SQL Server	`sqlserver://`	Stable
SQLite	`sqlite:///`	Stable
Databricks SQL	`databricks://`	Stable
Google BigQuery	`bigquery://`	Stable

MCP Tools

Tool	Description
`execute_sql`	Execute SQL queries with read-only enforcement and row limiting
`search_objects`	Browse catalogs, schemas, tables, columns, indexes, and routines
Custom Tools	Define reusable, parameterized SQL queries in `dbhub.toml`

Quick Start

NPM (recommended)

Terminal

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

Databricks SQL

Terminal

npx dbhub-analytics --dsn "databricks://token:YOUR_TOKEN@your-workspace.cloud.databricks.com/sql/2.0/warehouses/your_warehouse_id"

Google BigQuery

Terminal

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

Docker

Terminal

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

Terminal

npx dbhub-analytics --demo

Connect to Your AI Assistant

Claude Desktop / Claude Code

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

config.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:

config.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):

config.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):

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:

config.json

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

Configuration

DSN Connection Strings

Database	Format
PostgreSQL	`postgres://user:pass@host:5432/dbname?sslmode=require`
MySQL	`mysql://user:pass@host:3306/dbname`
MariaDB	`mariadb://user:pass@host:3306/dbname`
SQL Server	`sqlserver://user:pass@host:1433/dbname`
SQLite	`sqlite:///path/to/file.db` or `sqlite:///:memory:`
Databricks	`databricks://token:TOKEN@host/sql/2.0/warehouses/ID?catalog=CAT&schema=SCH`
BigQuery	`bigquery://PROJECT_ID/DATASET?keyFile=/path/to/key.json&location=US`

Multi-Database Setup (TOML)

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

toml

[[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 = 5432
database = "production"
user = "dbuser"
password = "secret"

Then run:

Terminal

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

bash

# Install dependencies
pnpm install

# Run in development mode
pnpm dev

# Build for production
pnpm build

# Run tests
pnpm test

Credits

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

Related MCP Servers

View all in Databases View all alternatives

Frequently Asked Questions about DBHub Analytics

Add the following block to your claude_desktop_config.json under mcpServers: "mcpServers": { "dbhub-analytics": { "command": "npx", "args": ["-y", "DBHub Analytics"] } }

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:

Live Dynamic SVG Preview

Markdown (GitHub README)

[![AllMCPs](https://allmcps.com/api/badge/dbhub-analytics?style=directory)](https://allmcps.com/mcp/dbhub-analytics)

HTML Embed

<a href="https://allmcps.com/mcp/dbhub-analytics"><img src="https://allmcps.com/api/badge/dbhub-analytics?style=directory" alt="DBHub Analytics on AllMCPs" /></a>

Technical Specs & Signals

CategoryDatabases

27Quality signal: Emerging · 27/100How this signal is calculated ▾

Server availabilityNot measured

Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.

Verified ownership8/20

Documentation & tools11/30

Adoption & activity1/15

Community engagement0/10

★ Featured

Moxie Docs MCP

MCP & Agent Skills for Automated Documentation, and codebase conventions + context

Explore Server →

Own this project?

This directory is pre-filled from public sources. Claim via GitHub README, site badge, or DNS TXT to get the verified badge and attach your website.

Free dofollow backlink: after claiming, verify your product site and place a dofollow AllMCPs badge — we recheck it stays live.

Claim & get free dofollow

Share & Embed

Add our SVG badge (dark/light directory styles) or embeddable widget to your site.

Explore more

More in 🗄️ Databases →Best MCP servers for Databases →Alternatives to DBHub Analytics →Install in Claude Desktop Install in Cursor Install in VS Code