Supported Databases
PostgreSQL, MySQL, SQL Server, MariaDB, and SQLite.Why DBHub?
DBHub brings powerful database capabilities to AI coding assistants:- Universal Gateway: Single interface for PostgreSQL, MySQL, MariaDB, SQL Server, and SQLite
- Secure Access: Read-only mode, SSH tunneling, and SSL/TLS encryption support
- Multi-Database: Connect to multiple databases simultaneously with TOML configuration
- Production-Ready: Row limiting, lock timeout control, and connection pooling
- MCP Native: Full implementation of Model Context Protocol with resources, tools, and prompts
Key Features
Database Exploration
AI assistants can discover and explore your database schema:- List schemas, tables, and columns
- View table structures and relationships
- Inspect indexes and stored procedures
- Understand database constraints
SQL Execution
Execute SQL queries directly from AI tools:- Run SELECT queries for data analysis
- Execute DDL/DML in read-write mode
- Support for parameterized queries
- Multi-statement execution with transaction support
AI-Powered Prompts
Built-in prompts help AI assistants:- Generate optimized SQL queries
- Explain database elements and relationships
- Suggest schema improvements
- Debug complex queries
Security Features
- Read-only Mode: Restrict operations to SELECT queries only
- SSH Tunneling: Secure connections through bastion hosts
- SSL/TLS: Encrypted database connections
- Row Limiting: Prevent accidental large data retrieval