WhoDB

Free

SQL/NoSQL/Graph/Cache/Object data explorer with AI-powered chat + other useful features

FreeFree tier

Type

Open Source

Company

Clidey

Visit Website GitHub (40 stars)

About WhoDB

WhoDB is a lightweight, self-hosted workspace for exploring, editing, and querying databases directly from your browser, desktop, or terminal. It supports a wide range of database engines including PostgreSQL, MySQL, SQLite, MongoDB, Redis, Elasticsearch, and more. Key capabilities include a spreadsheet-style data grid with sorting, filtering, pagination, and inline editing; an interactive schema graph for visualizing table relationships; a multi-cell query scratchpad with autocomplete and history; data import/export and mock-data generation for development; and optional AI-powered natural language querying via Ollama, OpenAI, Anthropic, or LM Studio. WhoDB is designed to be lightweight and self-hosted, making it ideal for inspecting local databases, helping teammates explore unfamiliar schemas, or working without installing a heavyweight client.

Key Features

Browse and edit data in a spreadsheet-style grid with sorting, filtering, pagination, and inline editing

Interactive schema graph for visualizing table relationships

Multi-cell query scratchpad with autocomplete, history, and side-by-side results

Data import/export and mock-data generation for development and testing

Optional AI-powered natural language querying via Ollama, OpenAI, Anthropic, or LM Studio

Multiple interfaces: web browser, desktop app (Electron), and terminal CLI with MCP server support

Supports over 15 database systems including PostgreSQL, MySQL, SQLite, MongoDB, Redis, Elasticsearch, ClickHouse, and more

Self-hosted with simple Docker deployment and persistent encrypted sessions

Pros & Cons

Pros

Lightweight and self-hosted with simple Docker setup
Supports a broad array of databases (SQL, NoSQL, cache, search, etc.)
Optional AI integration for natural language queries with choice of providers
Available as web app, desktop app, and CLI for flexibility
Open source with active development on GitHub
Spreadsheet-like data editing with inline capabilities

Cons

AI features require external provider setup (Ollama, OpenAI, etc.) and are not built-in
Advanced enterprise features may be limited in the community edition
Documentation and community resources are still growing

Best For

Inspecting and editing local or remote databases without installing a heavy clientHelping teammates explore unfamiliar database schemas and dataRunning ad-hoc queries and saving results for collaborationGenerating mock data and importing/exporting datasets for development and testingAsking questions about data in plain English using an optional AI provider

FAQ

What databases does WhoDB support?

WhoDB Community supports PostgreSQL, CockroachDB, YugabyteDB, QuestDB, MySQL, MariaDB, TiDB, SQLite, DuckDB, MongoDB, FerretDB, Redis, Valkey, Dragonfly, Elasticsearch, OpenSearch, ClickHouse, and Memcached. Support varies by database due to differing concepts and capabilities.

How do I install WhoDB?

The quickest way is with Docker: run 'docker run --rm -it -p 8080:8080 clidey/whodb' and open http://localhost:8080. It also runs as a desktop app and terminal CLI.

Is WhoDB free and open source?

Yes, WhoDB is free and open source under an open source license (see LICENSE in the repository). The community edition is available on GitHub.

Can I use AI with WhoDB without sharing data externally?

Yes, AI is optional. You can connect to a local AI provider like Ollama or LM Studio to keep data completely private, or choose cloud providers like OpenAI or Anthropic if desired.