WhoDB — Lightweight Database Explorer with AI Integration

Introduction

WhoDB is an open-source, lightweight database management tool that provides a clean web UI for exploring and querying multiple database types. It supports PostgreSQL, MySQL, SQLite, MongoDB, Redis, ClickHouse, and Elasticsearch out of the box. The tool also integrates optional AI assistance for generating and explaining SQL queries, making it useful for both daily database work and learning.

What WhoDB Does

• Connects to PostgreSQL, MySQL, SQLite, MongoDB, Redis, ClickHouse, and Elasticsearch
• Provides a web-based UI for browsing tables, collections, and keys
• Supports SQL query execution with syntax highlighting and result formatting
• Offers AI-powered query generation and explanation via configurable LLM backends
• Visualizes table relationships and data distributions

Architecture Overview

WhoDB is built with a Go backend and a React/TypeScript frontend. The backend uses database-specific drivers to connect to each supported engine, abstracting differences behind a unified query and schema interface. The frontend presents a tabbed workspace where users can manage multiple database connections, browse schemas, run queries, and view results in table or JSON format. The AI integration sends schema context and natural language questions to an LLM endpoint, returning generated queries or explanations.

Self-Hosting & Configuration

• Deploy with a single Docker command for instant setup
• Configure database connections through the web UI or environment variables
• Optional AI features require an LLM API key (supports OpenAI, Ollama, and compatible endpoints)
• Runs as a single container with no external dependencies
• Data and connection configs persist in a local volume

Key Features

• Multi-database support covering SQL, NoSQL, search, and cache engines
• Single Docker container deployment with no additional infrastructure
• AI-powered SQL generation and query explanation
• Clean, modern web UI with syntax highlighting and result formatting
• Lightweight resource footprint suitable for development and homelab use

Comparison with Similar Tools

• DBeaver — desktop Java application; WhoDB is a lightweight web-based tool
• Adminer — PHP-based with limited database support; WhoDB covers more engines including MongoDB and Redis
• pgAdmin — PostgreSQL-only; WhoDB supports 7+ database types
• Chat2DB — AI database client; WhoDB is lighter and supports more backends
• pgweb — PostgreSQL web browser; WhoDB adds multi-database and AI features

FAQ

Q: Is WhoDB suitable for production database management? A: It is designed for development, exploration, and learning. For production, use it behind authentication and network restrictions.

Q: Can I connect to remote databases? A: Yes. Provide the host, port, and credentials for any reachable database instance.

Q: Does the AI feature send my data to external services? A: The AI feature sends schema metadata and your question to the configured LLM endpoint. Row-level data is not sent unless included in your query context.

Q: Which LLM providers are supported for AI features? A: OpenAI, Ollama, Anthropic, and any OpenAI-compatible API endpoint.

Sources

• https://github.com/clidey/whodb