Introduction

 +------------------+    +--------------+    +------------------+
 |                  |    |              |    |                  |
 |                  |    |              |    |                  |
 |  Claude Desktop  +--->+              +--->+    PostgreSQL    |
 |                  |    |              |    |                  |
 |  Claude Code     +--->+              +--->+    SQL Server    |
 |                  |    |              |    |                  |
 |  Cursor          +--->+    DBHub     +--->+    SQLite        |
 |                  |    |              |    |                  |
 |  VS Code         +--->+              +--->+    MySQL         |
 |                  |    |              |    |                  |
 |  Other Clients   +--->+              +--->+    MariaDB       |
 |                  |    |              |    |                  |
 |                  |    |              |    |                  |
 +------------------+    +--------------+    +------------------+
     MCP Clients           MCP Server             Databases

DBHub is the official example in the Claude Code docs for connecting to PostgreSQL via MCP.

​

Token Efficiency

​

Use Cases

• Local Development: Schema exploration, query validation, and data debugging with Claude Code, VS Code, Cursor, etc.
• Non-Technical Access: Expose curated, read-only views to non-technical staff via Claude Desktop, VS Code, Cursor, etc.
• Multi-Database Consolidation: Replace separate MCP servers for each database with a single DBHub process
• Production Troubleshooting: Read-only diagnostics with guardrails against runaway queries

​

Supported Databases

​

Why DBHub?

• Minimal: Zero dependency, token efficient with a minimal set of 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

​

Key Features

​

MCP Tools

• execute_sql: Run queries with transaction support and safety controls
• search_objects: Explore schemas, tables, columns, indexes, and procedures
• explain_sql (opt-in): Show a query’s execution plan without running it
• health_check (opt-in): Report connection pool state and buffer cache hit ratio
• Custom Tools: Define reusable, parameterized SQL operations

​

Workbench

​

Architecture

​

Getting Started