clidey/whodb

docker run --rm -it -p 8080:8080 clidey/whodb
Desktop: macOS App Store, Windows Microsoft Store, or Snap
CLI: curl -fsSL https://raw.githubusercontent.com/clidey/whodb/main/cli/install/install.sh | bash
CLI via npm: npm install -g @clidey/whodb-cli

Usage

• •Open http://localhost:8080 and enter your database connection details
• •whodb-cli opens the terminal UI; whodb-cli mcp serve starts the MCP server for AI tools
• •Browse/filter/edit data, follow relationships through the schema graph, work through queries in the scratchpad
• •Open Chat → Add Provider to connect Ollama, OpenAI, Anthropic, or LM Studio and ask questions in plain English

Key features

• ✓Spreadsheet-style data grid with sorting, filtering, pagination, and inline editing
• ✓Interactive schema graph of tables and relationships; query scratchpad with multiple cells, autocomplete, and history
• ✓Imports, exports, and mock-data generation for development and testing
• ✓Plain-English AI Q&A via Ollama, LM Studio, OpenAI, Anthropic, or any OpenAI-compatible provider
• ✓Supports PostgreSQL, CockroachDB, YugabyteDB, QuestDB, MySQL, MariaDB, TiDB, SQLite, DuckDB, MongoDB, FerretDB, Redis, Valkey, Dragonfly, Elasticsearch, OpenSearch, ClickHouse, and Memcached
• ✓CLI with interactive terminal UI and an included MCP server

Best for

A lightweight, self-hosted alternative to heavyweight database clients for exploring and editing multiple databases from one browser or terminal workspace.

Caveats

• ⚠This repo is WhoDB Community (Apache-2.0, free to self-host); WhoDB Platform is the commercial edition with shared projects, SSO, audit logs, pipelines, and reporting
• ⚠Support varies by database since not every system has the same concepts
• ⚠Persistent encrypted login sessions require generating and mounting a WHODB_ENCRYPTION_KEY (changing it invalidates existing sessions)