Repolode
Submit
clidey

clidey/whodb

A lightweight, self-hosted web workspace for browsing, editing, and querying many kinds of databases, with optional AI-assisted queries.

Open-source alternative to:DBeaverTablePlus

View on GitHubWebsite
Stars
5,050
Forks
243
Open issues
18
Last commit
15 hours ago

What is it?

WhoDB is a self-hosted workspace for exploring databases. It runs in the browser and lets you browse tables in a spreadsheet-style grid with sorting, filtering, pagination, and inline editing, and view schema relationships as an interactive graph.

It supports a wide range of systems, including PostgreSQL, MySQL, SQLite, DuckDB, MongoDB, Redis, Elasticsearch, and ClickHouse. A query scratchpad offers multiple cells, autocomplete, and query history, and you can import, export, and generate mock data. The project is also available as a desktop app, a terminal CLI, and an MCP server for AI tools.

AI features are optional. You can connect local providers such as Ollama and LM Studio, or hosted ones such as OpenAI, Anthropic, and Gemini, to ask questions in plain English.

Key features

  • 01Spreadsheet-style data grid with sorting, filtering, and inline editing
  • 02Interactive graph of tables and relationships
  • 03Query scratchpad with autocomplete and history
  • 04Import, export, and mock-data generation
  • 05Support for SQL, document, key-value, and search databases
  • 06Optional AI queries via local or hosted providers, plus an MCP server

Use cases

  • Inspecting a local database without installing a heavy desktop client
  • Helping a teammate explore unfamiliar data and its relationships
  • Running ad hoc queries and editing records from a browser
  • Generating mock data for development and testing

Quick start

  1. 1

    Run WhoDB with Docker

    docker run --rm -it -p 8080:8080 clidey/whodb
  2. 2

    Open http://localhost:8080 and enter your database connection details

Things to know

  • Some features and database support depend on the Community or Platform edition, and advanced features like SSO and audit logs are only in the commercial Platform.

In collections

Open-source AI agent frameworks & appsMCP serversSelf-hosted appsDatabases & SQL tools

Topics

#database-management#sql-editor#self-hosted#postgresql#mysql#text-to-sql#mcp-server#data-catalog#ai-agent#data-governance

FAQ

What is whodb?
A lightweight, self-hosted web workspace for browsing, editing, and querying many kinds of databases, with optional AI-assisted queries. WhoDB is a self-hosted workspace for exploring databases. It runs in the browser and lets you browse tables in a spreadsheet-style grid with sorting, filtering, pagination, and inline editing, and view schema relationships as an interactive graph.
Is whodb free to use? What license does it have?
whodb is open source under the Apache-2.0 license. Check the license terms before using it in commercial products.
Is whodb still maintained?
Actively maintained. The last commit to whodb was on Nov 6, 2026.
What can I use whodb for?
Inspecting a local database without installing a heavy desktop client Helping a teammate explore unfamiliar data and its relationships Running ad hoc queries and editing records from a browser Generating mock data for development and testing
How do I install whodb?
Run WhoDB with Docker: docker run --rm -it -p 8080:8080 clidey/whodb Open http://localhost:8080 and enter your database connection details
Where can I get whodb?
The source code and installation instructions are on GitHub: https://github.com/clidey/whodb

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects