Whodb

Name: Whodb
Author: clidey

@clidey

About Whodb

WhoDB CLI - a powerful database management tool with interactive TUI, programmatic commands, and MCP server for AI assistants.

#database #data #cli #claude #codex #postgres #mysql #sqlite #elasticsearch #redis #mongodb #memcached #duckdb #mariadb

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "whodb": {
      "command": "npx",
      "args": [
        "-y",
        "@clidey/whodb-cli",
        "mcp",
        "serve"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Whodb?

Whodb is a lightweight (<50MB) database management tool that supports PostgreSQL, MySQL, SQLite3, MongoDB, Redis, MariaDB, ElasticSearch (Community Edition) and additional databases in the Enterprise Edition. It includes a CLI with an MCP (Model Context Protocol) server for AI assistants like Claude and Cursor.

How to use Whodb?

Install the CLI via curl -fsSL https://raw.githubusercontent.com/clidey/whodb/main/cli/install/install.sh | bash, npm install -g @clidey/whodb-cli, or upcoming Homebrew. Launch the interactive TUI with whodb-cli or run the MCP server with whodb-cli mcp serve. The server listens on port 8080 by default.

Key features of Whodb

Multi-database support (PostgreSQL, MySQL, SQLite3, MongoDB, Redis, etc.)
AI-powered natural language to SQL via Ollama, OpenAI, Anthropic, or any OpenAI-compatible provider
Spreadsheet-like data grid with inline editing and bulk operations
Interactive schema topology visualization
Jupyter-like scratchpad query editor
Mock data generation and flexible export (CSV, Excel, JSON, SQL)

Use cases of Whodb

Quickly inspect and debug databases during local development
Manage production data with read-only access
Run AI-assisted queries by converting natural language to SQL
Explore schema relationships visually for database design
Generate realistic test data for development and testing

FAQ from Whodb

What databases does Whodb support?

Community Edition supports PostgreSQL, MySQL, SQLite3, MongoDB, Redis, MariaDB, and ElasticSearch. Enterprise Edition adds Oracle, SQL Server, DynamoDB, Athena, Snowflake, Cassandra, and more.

How do I enable AI natural language queries?

Set environment variables for your AI provider: WHODB_OLLAMA_HOST for Ollama, WHODB_OPENAI_API_KEY for OpenAI, WHODB_ANTHROPIC_API_KEY for Anthropic, or WHODB_AI_GENERIC_<ID>_* for any OpenAI-compatible endpoint.

Does Whodb require Docker?

No. Docker is a recommended quick start (run docker run -it -p 8080:8080 clidey/whodb), but you can also install the CLI directly or build from source with Go and Node.js.

What is the Whodb CLI MCP server?

The MCP server allows AI assistants like Claude and Cursor to interact with databases through the Model Context Protocol. Run whodb-cli mcp serve to start it.

Where does data persist?

Data is stored in the connected databases (not in Whodb itself). For SQLite, you can mount a volume to persist the file. Whodb is stateless and does not store your data.