What is WhoDB?
WhoDB is a workspace for connecting to databases, exploring and editing records, and understanding how data is structured. It is for developers and data teams who want a browser-based, self-hosted or desktop database client, as well as organizations building internal apps and workflows around their data. The Community edition focuses on database work; WhoDB Platform adds shared projects and operational tools for teams.
WhoDB Features:
Database Connections: Connects to relational, document, key-value, search, and analytical databases, including PostgreSQL, MySQL, SQLite, MongoDB, Redis, and ClickHouse.
Data Grid: Browse records in a spreadsheet-style grid with sorting, filtering, pagination, and inline editing.
Schema Graph: Displays tables and their relationships in an interactive graph to help users inspect how a database is organized.
Query Scratchpad: Provides a space to write queries in multiple cells, with autocomplete, query history, and results kept alongside each query.
AI Questions: Lets users ask database questions in plain English through optional local or hosted providers, including Ollama, OpenAI, and Anthropic.
Apps and Lineage: The platform can model shared business records, trace data lineage, and build apps and workflows with permissions and audit trails.
WhoDB Benefits:
Less Client Setup: Browser, desktop, terminal, and self-hosted options give teams ways to work with databases without relying on a heavyweight database client.
Clearer Data Structure: Seeing tables and relationships together helps users orient themselves in an unfamiliar database before changing records or writing queries.
Faster Data Checks: Filtering and editing records in one grid can reduce the back-and-forth involved in inspecting or correcting database contents.
More Query Context: Keeping query results, history, and multiple query cells together makes it easier to revisit investigative work.
Traceable Workflows: Connected records, permissions, lineage, and audit trails help teams understand how operational work relates to its underlying data.
Use Cases:
Inspect Local Data: A developer can connect to a local database to browse tables, check records, and edit values while building an application.
Explore Unfamiliar Schemas: A teammate joining a project can use the schema graph to follow table relationships and get oriented in the data.
Investigate Query Results: An analyst can use the scratchpad to try queries, compare results, and return to earlier steps during a data investigation.
Ask Database Questions: A user can ask questions in plain English when exploring a database, using a locally configured or hosted AI provider.
Replace Spreadsheet Workflows: An operations team can turn spreadsheet-based pricing or inventory planning into structured records and reviewable workflows.