Whodb
@clidey
About Whodb
WhoDB CLI - a powerful database management tool with interactive TUI, programmatic commands, and MCP server for AI assistants.
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"whodb": {
"command": "npx",
"args": [
"-y",
"@clidey/whodb-cli",
"mcp",
"serve"
]
}
}
}Tools
No tools detected
Fetch the live tool list by running this server in a temporary sandbox using the button above.
Overview
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.
Frequently asked questions
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.
Basic information
More Other MCP servers
MCP Go ๐
mark3labsA Go implementation of the Model Context Protocol (MCP), enabling seamless integration between LLM applications and external data sources and tools.
ICSS
chokcocoไธๆญขไบ CSS
Lemon.io
lemon-ioRequest dedicated senior developers to work on your project, write job descriptions, and prep technical interviews โ all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1โ3
MCP Registry
modelcontextprotocolA community driven registry service for Model Context Protocol (MCP) servers.
EverArt
modelcontextprotocolModel Context Protocol Servers
Comments