clidey/whodb

What it solves

WhoDB is a lightweight, self-hosted workspace for database management. It replaces heavyweight database clients by providing a single interface to explore, edit, and query data across various database types, helping users understand complex schemas and collaborate with teammates on data exploration.

How it works

WhoDB provides a browser-based interface (also available as a desktop app or CLI) that connects to your databases. It allows you to interact with data using a spreadsheet-style grid for editing and filtering, an interactive graph to visualize schema relationships, and a multi-cell scratchpad for writing queries. It also includes an optional AI layer that connects to providers like Ollama, OpenAI, Anthropic, or LM Studio, allowing users to ask questions about their data in plain English.

Who it’s for

It is designed for developers and data analysts who need to inspect local databases, explore unfamiliar data, or manage multiple database sources without installing complex software.

Highlights

• Multi-database support: Supports a wide range of systems including PostgreSQL, MySQL, SQLite, MongoDB, Redis, ClickHouse, and more.
• AI-powered queries: Optional integration with local or hosted AI providers to translate plain English questions into database queries.
• Visual schema exploration: Interactive graphs that map out table relationships.
• Flexible deployment: Available via Docker, desktop applications (macOS, Windows), or a terminal CLI with an MCP server.
• Data management tools: Includes features for importing, exporting, and generating mock data for testing.