Whodb

Name: Whodb
Author: clidey

@clidey

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

基本情報

カテゴリ

その他

トランスポート

stdio

公開者

clidey

投稿者

Anguel

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

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.