WhoDB (https://github.com/clidey/whodb) is a database management tool for SQL and NoSQL databases, runs in your browser, can be launched via Docker, and is available on the Apple, Microsoft, and Snap store. The WhoDB cli is both an interactive and command driven client that shares the same WhoDB Go backend and provides a TUI around it alongside an MCP server.
I use the mcp within Claude Code to help me when I develop with local databases (checking schemas, data, running actual SQL, etc) although CC is pretty good with this in general. I haven't yet tried it out with Codex so cannot comment on that.
We've added (in no particular order):
- DuckDB support
- TiDB support
- Updated layout system to support multiple windows
- SQL formatter and extended autocomplete
- SSH support (still testing this one)
- ER diagram generation
- EXPLAIN plan generation
- Mock data generation
- Simple table data audit functionality
- Read-only mode
- Streaming AI chat
- CLI profiles
- Different theme support
- JSON, NDJSON, CSV outputs
Disclaimer: a lot of the CLI code was AI-generated (mostly Claude Code). I point it to existing repos using the same libraries as reference, which helps since I don't have deep CLI development experience.
If you want to install it, there are several ways:
(1) curl -fsSL https://raw.githubusercontent.com/clidey/whodb/main/cli/inst... | bash
(2) brew install whodb-cli
(3) npm install -g @clidey/whodb-cli
(4) docker pull clidey/whodb-cli:latest
(5) Grab the executables from our latest Github release
If you want to add it to CC:
(1) claude mcp add whodb -- npx -y @clidey/whodb-cli mcp serve
(2) or you can configure it with database credentials via an env variable profile: claude mcp add whodb -e WHODB_POSTGRES='[{"alias":"dev","host":"localhost","user":"user","password":"pass","database":"mydb","port":"5432"}]' -- whodb-cli mcp serve
It should work with Codex as such: codex mcp add whodb -- whodb-cli mcp serve
Happy to hear your thoughts on how you might use this, or what additions you might find interesting. Thanks for reading!
No comments yet.
