About WhoDB
WhoDB is an open source, self hosted workspace for exploring and working with databases. It runs in the browser, and it is also available as a desktop app for Windows and macOS, a Snap package and a terminal command line tool. It can be started with a single Docker command and then pointed at a database by entering connection details. The project is written in Go and TypeScript and is released under the Apache 2.0 license.
The workspace offers a spreadsheet style grid for browsing and editing data with sorting, filtering and inline edits, and an interactive graph that shows tables and their relationships. A query scratchpad has multiple cells, autocomplete, history and results kept next to each query. Data can be imported and exported, and mock data can be generated for development and testing. AI features are optional: a user can connect Ollama, OpenAI, Anthropic, LM Studio or another OpenAI compatible provider to ask questions about the data in plain English. The command line tool also includes a Model Context Protocol server, so AI agents can work with connected databases. Supported systems include PostgreSQL, MySQL, SQL Server and Oracle.
It suits developers and teams who want to inspect a local database or help a colleague explore unfamiliar data without installing a heavy database client. The software is free to use, and a live demo and documentation are published. The repository lists no paid plans.