# WhoDB — Lightweight Database Explorer with AI Integration

> An open-source, lightweight database management tool that connects to PostgreSQL, MySQL, SQLite, MongoDB, Redis, ClickHouse, and Elasticsearch with a clean web UI and optional AI-powered query assistance.

## Install

Save as a script file and run:

# WhoDB — Lightweight Database Explorer with AI Integration

## Quick Use
```bash
docker run -p 8080:8080 clidey/whodb
# Open http://localhost:8080 in your browser
# Connect to your database using the web interface
```

## 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

---
Source: https://tokrepo.com/en/workflows/asset-6b454b0c
Author: Script Depot