WhoDB
Lightweight database explorer with optional natural-language chat
4.9k stars 224 forks last commit first released Apache-2.0
Actively maintained
Last commit 28 Jul 2026.
WhoDB is a lightweight, modern database management and exploration tool for working with multiple SQL and NoSQL databases from a single web UI. It focuses on fast startup, a spreadsheet-like data grid, visual schema exploration, and an optional chat interface for natural-language querying.
Key Features
- Multi-database support including PostgreSQL, MySQL/MariaDB, SQLite, MongoDB, Redis, Elasticsearch, and ClickHouse
- Spreadsheet-like table viewer with sorting, filtering, search, inline edits, and bulk operations
- Interactive schema explorer with relationship/topology visualization
- Scratchpad-style query interface with history and reusable queries
- Export options for common formats (such as CSV, Excel, JSON, and SQL)
- Optional natural-language to SQL chat interface with support for Ollama and other LLM providers
- Mock data generation for development and testing workflows
Use Cases
- Day-to-day database inspection and quick data fixes during development or operations
- Ad-hoc analysis and data exports for reporting or debugging
- QA and test workflows such as generating realistic sample data and validating migrations
Limitations and Considerations
- Some advanced database coverage and enterprise-focused capabilities are edition-dependent
WhoDB is a strong fit for teams that want a fast, web-based database GUI with modern UX, broad database connectivity, and optional AI-assisted querying. It is especially useful when you need a single tool to explore schemas, run queries, and manage data across multiple database engines.
Categories:
Tags:
Tech Stack:
Similar to WhoDB
DbGate
Cross-platform SQL & NoSQL database manager
Open-source, cross-platform database client for SQL and NoSQL engines (MySQL, PostgreSQL, SQL Server, MongoDB, Redis, SQLite, etc.), available as desktop apps, web app and Docker.
phpMyAdmin
Web-based administration interface for MySQL and MariaDB
phpMyAdmin is a PHP-based web interface to manage MySQL and MariaDB databases, including schema changes, user privileges, import/export, and SQL execution.
Apache Superset
Data exploration, visualization, and dashboarding platform
Apache Superset is an open-source BI platform for SQL-based data exploration, interactive dashboards, and rich visualizations with a no-code chart builder and SQL editor.
Mathesar
Open-source spreadsheet-like UI for PostgreSQL databases
Self-hosted web app that provides a spreadsheet-like interface to view, edit, query, and manage PostgreSQL data with native Postgres role-based access control.
WebDB
Web-based database client for relational databases
WebDB is a lightweight web database client for browsing, querying, and managing SQL databases from a modern browser-based UI.
ChartDB
Web-based database schema diagram editor from a single query
Open-source, web-based ERD and database schema diagram editor. Import schemas via a single query, edit visually, and export DDL scripts and images for documentation or migrations.
