WhoDB is a self-hosted workspace for database exploration and editing, with CLI, frontend, and AI provider integration options. It supports multiple databases and offers a browser-based UI plus a terminal interface.
Collecting history — the radar snapshots this repo daily. The trend line appears after 3 days of data (2 so far).
What it is
WhoDB is described as a lightweight, self-hosted workspace for databases. It runs in the browser and is available as a desktop app or terminal CLI, with optional AI features that connect to providers like OpenAI, Anthropic, Gemini, Ollama, or LM Studio. The repository is Apache-2.0 licensed and primarily written in Go with a React/TypeScript frontend.
How it works
The project comprises a Go backend and a React/TypeScript frontend. It supports browsing and editing data in a grid, visual schema graphs, a scratchpad for queries, data import/export, and AI question-asking capabilities via configured providers. The CLI includes an interactive terminal UI and an MCP server for AI tools. AI provider configuration is done through environment variables and a provider setup in the UI. The frontend communicates with the backend over localhost:8080, while the frontend itself runs on port 3000 when started locally.
Getting started
Quick start guidance included:
- Run with Docker: docker run --rm -it -p 8080:8080 clidey/whodb
- Access at http://localhost:8080 and provide database connection details.
- CLI setup commands are provided:
# macOS and Linux curl -fsSL https://raw.githubusercontent.com/clidey/whodb/main/cli/install/install.sh | bash # or install with npm npm install -g @clidey/whodb-cli - Start backend: in core directory, run:
go run ./cmd/whodb - Start frontend: in frontend directory, run:
pnpm install pnpm start
Recent releases
Latest releases listed:
- 0.121.0 Release 0.121.0 (2026-07-16): Move to opaque cookie session usage in the browser and docker builds - desktop remains unchanged; Library updates; Update to how analytics are set up; Doc updates
- 0.120.0 Release 0.120.0 (2026-07-11): Update libraries; CLI functionality updates for platform; Update translations; Backend refactoring to clean up code
- 0.119.0 Release 0.119.0 (2026-07-03): Library updates; MongoDB parsing changes; General bug fixes
- 0.118.0 Release 0.118.0 (2026-06-27): Update French translations; Fix bug related to login with pre-configured env profiles; Update documentation
- 0.117.0 Release 0.117.0 (2026-06-23): Full changelog available
Traction
Stars: 4931; Forks: 222; Open issues: 15
Behind the repo
This repository contains WhoDB Community (Apache-2.0-licensed). WhoDB Platform is the commercial, self-hosted edition with additional features.
Caveats
License: Apache-2.0. Age: created 2024-06-11. Last push: 2026-07-20. Supported databases include PostgreSQL, CockroachDB, YugabyteDB, QuestDB, MySQL, MariaDB, TiDB, SQLite, DuckDB, MongoDB, FerretDB, Redis, Valkey, Dragonfly, Elasticsearch, OpenSearch, ClickHouse, Memcached; support varies by database. Other configuration notes include Docker-based sessions with a key for encrypted login sessions (WHODB_ENCRYPTION_KEY) and optional WHODB_SECURE=true for HTTPS cookie security. AI providers can be configured via environment variables such as WHODB_OPENAI_, WHODB_ANTHROPIC_, WHODB_OLLAMA_, WHODB_LMSTUDIO_, or WHODB_AI_GENERIC_<ID>_*.