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.

May 4, 2026
GitHub starsLast commit

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:

EngineDefault PortConnection String
PostgreSQL5432postgresql://user:pass@host:5432/dbname
MySQL3306mysql://user:pass@host:3306/dbname
MongoDB27017mongodb://user:pass@host:27017/dbname
Redis6379redis://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