MCP.so
Sign In
W

Whodb MCP Server

@clidey

Basic information

Category

Other

Transports

stdio

Author

clidey

Submitted by

Anguel

About Whodb MCP Server

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

Whodb MCP Server config

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

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

Whodb MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

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

Frequently asked questions

1

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.

2

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.

3

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.

4

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.

5

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.

Comments

More Other MCP servers