WhoDB MCP Server
Connect AI assistants to WhoDB, the all-in-one database management tool, for querying and exploring PostgreSQL, MySQL, SQLite, MongoDB, Redis, and more through MCP.
Overview
The WhoDB MCP Server brings database management capabilities to AI assistants, powered by WhoDB's versatile multi-engine architecture. Through the Model Context Protocol, AI models can query, explore, and manage data across PostgreSQL, MySQL, SQLite, MongoDB, Redis, Cassandra, Elasticsearch, DuckDB, and ClickHouse — all from a single MCP server. This makes WhoDB one of the most flexible database MCP integrations available.
Open Source:
Developed by Clidey with 4,700+ stars on GitHub
Key Features
Multi-Engine Support
Query PostgreSQL, MySQL, SQLite, MongoDB, Redis, Cassandra, Elasticsearch, DuckDB, ClickHouse, and more from one interface.
Schema Exploration
Browse tables, collections, indexes, and schemas across different database types.
Ad-Hoc Querying
Execute raw SQL or NoSQL queries directly through AI assistant conversations.
Record Management
View, insert, update, and delete records with natural language commands.
Connection Management
Configure multiple database connections and switch between them seamlessly.
Web UI Included
Comes with a built-in web interface alongside the MCP server for visual database management.
Installation
{
"mcpServers": {
"whodb": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-p",
"8787:8787",
"clidey/whodb"
]
}
}
}
Database Connection:
WhoDB connects to databases via its built-in web UI at http://localhost:8787. Configure your database connections there, and the MCP server will use the same connections for queries.
Configuration
WhoDB requires connection configuration for each database engine you want to access. These are configured through the WhoDB web interface:
| Engine | Default Port | Connection String |
|---|---|---|
| PostgreSQL | 5432 | postgresql://user:pass@host:5432/dbname |
| MySQL | 3306 | mysql://user:pass@host:3306/dbname |
| MongoDB | 27017 | mongodb://user:pass@host:27017/dbname |
| Redis | 6379 | redis://user:pass@host:6379 |
| SQLite | — | /path/to/database.db |
Common Use Cases
- Multi-Database AI Assistants: Give AI models access to multiple database engines through a single MCP server integration
- Development & Debugging: Let AI assistants explore database schemas and run diagnostic queries during development
- Data Migration & Analysis: Use AI to write and execute cross-engine queries for data analysis and transformation
- Natural Language Database Management: Query and manage databases without leaving your AI chat interface
Sources
Related Articles
Travel & Transportation MCP Servers: Flights, Stays & Navigation
Explore MCP servers for travel and transportation, providing standardized interfaces for AI models to search flights, book accommodations, discover places, and access navigation data.
Gmail MCP Server
Gmail MCP server provides AI assistants with the ability to read, search, send, and manage Gmail messages including thread management, label organization, and inbox triage.
Perplexity AI MCP Server: Real-time Search & Reasoning for AI
Explore Perplexity AI MCP Server for real-time web search, advanced reasoning, and comprehensive research. Empower your AI with up-to-date information and detailed answers.