whodb
WhoDB is a lightweight, open-source database explorer and query tool built in Go and React. It connects to 18+ database types, provides visual schema exploration, a Jupyter-style query scratchpad, and optional AI-powered natural language queries. The platform version adds pipelines, governance, and operational intelligence features for teams.
Key facts
Objective fields from the source. Values we can't verify are shown as “Unknown” rather than guessed.
| Field | Value |
|---|---|
| Repository | clidey/whodb |
| Owner | clidey |
| Primary language | Go |
| License | Apache-2.0 — OSI-approved |
| Stars | 4.9k |
| Forks | 219 |
| Open issues | 21 |
| Latest release | 0.119.0 (2026-07-03) |
| Last updated | 2026-07-07 |
| Source | https://github.com/clidey/whodb |
What whodb is
WhoDB Community is a single-binary (~100MB), low-memory database client with a web UI (React/TypeScript frontend, Go backend) supporting PostgreSQL, MySQL, MongoDB, ElasticSearch, ClickHouse, and others. It includes schema graph visualization, data grid editing, SQL autocomplete, and optional LLM integrations (Ollama, OpenAI, Anthropic). WhoDB Platform adds visual ETL pipelines, AES-256-GCM credential encryption, SSO (Okta/Azure AD/Google), audit trails, and role-based access controls.
Get the whodb source
Clone the repository and explore it locally.
git clone https://github.com/clidey/whodb.gitcd whodb# follow the project's README for install & configurationNeed it deployed, integrated, or customized instead? DEV.co ships production installs.
Best use cases
Implementation considerations
- Deploy via Docker (`docker run -it -p 8080:8080 clidey/whodb`) for fastest local setup; also available on Windows, macOS, Snap, and CLI. No complex installation overhead.
- For Platform features (SSO, pipelines, audit, governance), clarify licensing model, self-hosted vs. managed deployment, and cost structure with vendor. Community edition is Apache-2.0; Platform terms not detailed in data.
- Integrating AI features (Ollama, OpenAI, Anthropic) requires network access, API keys, and latency considerations. Test natural language-to-SQL accuracy on your schema and queries before depending on it in production workflows.
- Credential encryption (AES-256-GCM) is stated; verify key management, rotation policy, and decryption audit logging align with your security posture before moving to Platform with multi-user access.
- Database-specific dialect support (SQL Server, Oracle, DynamoDB on Platform) requires testing; community support is GitHub issues (21 open). Plan for community-driven SLA, not vendor-backed response times.
When to avoid it — and what to weigh
- Enterprise BI and Reporting at Scale — If you need production-grade business intelligence with complex multi-dimensional analysis, large concurrent user bases, or deep Tableau/Power BI integration, WhoDB's community edition is a query tool, not a BI platform. Platform may address this, but adoption/track record is early.
- Mission-Critical, Highly Audited Production Systems — Project is ~2 years old (created June 2024) with 4,920 stars and 21 open issues. Security model and audit trail features require verification. Do not assume readiness for regulated environments (healthcare, finance) without comprehensive third-party security review.
- Data Warehouse Operations at Extreme Scale — WhoDB supports ClickHouse, Snowflake, BigQuery (Platform), but is not optimized for managing petabyte-scale data movement or competing with Airflow, Databricks, or specialized data orchestration platforms. Use for smaller to mid-scale pipelines.
- Closed-Source, Proprietary Requirement — Apache-2.0 license requires source code disclosure in derivative works and use under specified attribution and liability terms. If your compliance policy forbids copyleft or source-visible software, this does not fit.
License & commercial use
WhoDB Community is licensed under Apache License 2.0 (permissive, OSI-approved). Allows commercial use, modification, and distribution, provided license copy and disclaimers are included. No warranty or liability assumed by licensor. WhoDB Platform licensing model is not stated in the data; requires vendor review.
Apache-2.0 permits commercial use of WhoDB Community (open-source edition) provided you include the license and attribution. You may use it in proprietary applications, charge for derived products, and run it on commercial infrastructure without additional fees. However, if you modify and redistribute WhoDB itself, source code and license must be disclosed. WhoDB Platform (closed-source, AI/governance features) has an unknown licensing model and likely requires a separate commercial agreement. Consult the vendor before assuming Platform is available for production use without a contract.
DEV.co evaluation signals
Editorial assessment — not user reviews. Directional, with an explicit confidence level.
| Signal | Assessment |
|---|---|
| Maintenance | Active |
| Documentation | Adequate |
| License clarity | Clear |
| Deployment complexity | Low |
| DEV.co fit | Good |
| Assessment confidence | High |
Community edition: no explicit security audit or threat model published in the data. Go and React are mature languages with good supply-chain practices, but no CVE history or pentesting results provided. Platform edition claims AES-256-GCM credential encryption, SSO (Okta/Azure AD/Google Workspace), access controls to data-view level, and audit trails. Before using with sensitive data: (1) independently verify encryption key management, (2) review audit logging completeness, (3) confirm SSO integration is standards-compliant (SAML 2.0, OIDC), (4) request security documentation or third-party assessment. No mention of vulnerability disclosure policy, update cadence, or patching SLA.
Alternatives to consider
DBeaver / DataGrip (JetBrains)
Full-featured, mature database IDEs with extensive built-in tools, but heavier (500MB+), higher memory, and commercial licensing. Better for teams with complex workflows; worse for lightweight, resource-constrained deployments.
Metabase / Apache Superset
Open-source BI and dashboarding platforms with broader SQL support and team governance. Heavier than WhoDB Community, focused on reporting rather than exploration and ad-hoc querying. Better for analytics; worse for schema browsing and development.
Adminer / phpMyAdmin
Lightweight, standalone PHP/web-based database tools for MySQL/MariaDB/PostgreSQL. Simpler than WhoDB, no AI features, limited schema visualization. Better for simple CRUD on legacy stacks; worse for multi-database support and modern UX.
Build on whodb with DEV.co software developers
Evaluate WhoDB Community for your team's database exploration needs. Start with Docker in seconds—no installation required. For governance and AI-powered operational intelligence, explore WhoDB Platform with Devco.
Talk to DEV.coRelated open-source tools
Surfaced by semantic similarity across the DEV.co open-source index.
Related on DEV.co
Explore the category and the services that help you build with it.
whodb FAQ
Can I use WhoDB Community in production?
Does WhoDB store my database credentials?
What databases does WhoDB support?
Is there a vendor-backed SLA or support plan?
Software development & web development with DEV.co
DEV.co helps companies turn open-source tools like whodb into production software. Our software development services cover the full lifecycle — architecture, web development, integration, and maintenance — delivered by software developers and web developers who ship. Engage our software development agency to implement or customize it for your open-source databases stack.
Ready to Simplify Database Access?
Evaluate WhoDB Community for your team's database exploration needs. Start with Docker in seconds—no installation required. For governance and AI-powered operational intelligence, explore WhoDB Platform with Devco.