amansingh63 avatar

DBHub Analytics

amansingh63/dbhub-analytics

Connects Claude to seven database systems through a single interface: Databricks SQL, BigQuery, PostgreSQL, MySQL, MariaDB, SQL Server, and SQLite. Exposes two core MCP tools: execute_sql for running queries with read-only enforcement and row limits, and search_objects for browsing catalogs, schemas, tables, and columns. You can connect to multiple databases simultaneously via a TOML config file, which makes it useful when you need to query across different data sources in one conversation. Built on Bytebase's DBHub project. Supports SSH tunneling, SSL/TLS, and service account auth for BigQuery. The progressive schema disclosure is handy when you're exploring unfamiliar databases and don't want to dump entire schemas at once.

tools
2
auth
Secret needed
transport
STDIO
env vars
16
last updated
Apr 2, 2026

Tools

2 tools

Public tool metadata for what this MCP can expose to an agent.

execute_sqlExecute SQL queries with read-only enforcement and row limiting

Execute SQL queries with read-only enforcement and row limiting

No parameter schema in public metadata yet.

search_objectsBrowse catalogs, schemas, tables, columns, indexes, and routines

Browse catalogs, schemas, tables, columns, indexes, and routines

No parameter schema in public metadata yet.

Sponsors

Configuration

DSNsecret

Database connection string (e.g., postgres://user:pass@host:5432/db)

DB_TYPE

Database type: postgres, mysql, mariadb, sqlserver, sqlite, databricks, bigquery

DB_HOST

Database hostname

DB_PORT

Database port

DB_USER

Database username

DB_PASSWORDsecret

Database password

DB_NAME

Database name or SQLite file path

TRANSPORT

Transport mode: stdio or http

PORT

HTTP server port (default: 8080)

ID

Instance identifier for tool names

SSH_HOST

SSH server hostname

SSH_PORT

SSH server port (default: 22)

SSH_USER

SSH username

SSH_PASSWORDsecret

SSH password

SSH_KEY

Path to SSH private key

SSH_PASSPHRASEsecret

SSH key passphrase

Readme

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.


View the full README on GitHub

Details

Repository
github.com/amansingh63/dbhub-analytics
Categories
Databases, Monitoring & Observability, Data & Analytics
Package
dbhub-analytics
Transport
STDIO
Auth
Required
Registry
MCP registry, active

Related Databases MCP servers

View all
1thinair avatarDataco.thinair/dataPostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.0stars
2shyamolkonwar avatarRivtorshyamolkonwar/rivtor-cliDeploy full-stack apps (frontend, backend, Postgres, Redis) from your agent and get live URLs.0stars
3daedalus avatarMcp Psycopg2daedalus/mcp-psycopg2MCP server exposing psycopg2 PostgreSQL database adapter functionality0stars
4mironovisa avatardatamcp — Hosted Model Context Protocol for Databases, APIs, and Agent Memoryio.github.mironovisa/datamcpPostgreSQL, MySQL, OpenAPI/Swagger, and shared Agent Memory with scoped access.0stars
5mukundakatta avatarSqlfmt Mcpmukundakatta/mcp-stackDeterministic SQL formatting across 19 dialects (postgres, mysql, snowflake, bigquery, etc.).0stars
6optisol-business avatarDb Metadata Extractor Mcpoptisol-business/db-metadata-extractor-mcpExtract database metadata from PostgreSQL, Snowflake, SQL Server, BigQuery, and Oracle.0stars