WhoDB

Lightweight, Fast, and Beautiful Database Management

Available on

🚀 Quick Start • 📖 Documentation • 🎮 Live Demo • 💬 Community

---

🎯 What is WhoDB?

WhoDB is the modern database management tool that developers actually want to use.

Built with GoLang and React, WhoDB is a lightweight (<50MB) yet powerful database client that combines blazing-fast performance with an intuitive, beautiful interface. Whether you're debugging a production issue, exploring a new database schema, or managing data for your next feature, WhoDB makes database management feel effortless.

Why WhoDB?

🚀 Lightning Fast

• Instant startup (<1s)
• Real-time query results
• Efficient table virtualization
• 90% less resource usage than traditional tools

🎨 Beautiful & Intuitive

• Clean, modern interface
• Spreadsheet-like data grid
• Interactive schema visualization
• No training required

🤖 AI-Powered

• Natural language to SQL
• Talk to your data conversationally
• Supports Ollama, OpenAI, and Anthropic
• No complex query writing needed

🔧 Developer-Friendly

• Multi-database support
• Query history & management
• Mock data generation
• Flexible export options

✨ Key Features

📊 Visual Data Management

Spreadsheet-Like Data Grid

• View, edit, and manage data intuitively
• Sort, filter, and search with ease
• Inline editing with real-time updates
• Bulk operations for efficiency

🔍 Interactive Schema Explorer

Visual Schema Topology

• Interactive graph visualization
• Explore table relationships
• Understand foreign keys instantly
• Pan, zoom, and navigate easily

💻 Powerful Query Interface

Scratchpad Query Editor

• Jupyter-like notebook interface
• Syntax highlighting & auto-completion
• Query history & reuse
• Multi-cell organization

🗄️ Multi-Database Support

Community Edition (CE): PostgreSQL, MySQL, SQLite3, MongoDB, Redis, MariaDB, ElasticSearch

Enterprise Edition (EE): All CE databases plus Oracle, SQL Server, DynamoDB, Athena, Snowflake, Cassandra, and more

🎯 Advanced Capabilities

• Mock Data Generation - Generate realistic test data for development
• Flexible Export Options - Export to CSV, Excel, JSON, or SQL
• Advanced Filtering - Build complex WHERE conditions visually
• AI-Powered Queries - Convert natural language to SQL with Ollama, OpenAI, or Anthropic

---

🎮 Try WhoDB Now

Experience WhoDB in action without any setup

---

🚀 Quick Start

Option 1: Docker (Recommended)

The fastest way to get started with WhoDB:

docker run -it -p 8080:8080 clidey/whodb

Then open http://localhost:8080 in your browser.

Option 2: Docker Compose

For more control and configuration:

version: "3.8"
services:
  whodb:
    image: clidey/whodb
    ports:
      - "8080:8080"
    environment:
      # AI Integration (Optional)
      # Ollama Configuration
      - WHODB_OLLAMA_HOST=localhost
      - WHODB_OLLAMA_PORT=11434

      # Anthropic Configuration
      - WHODB_ANTHROPIC_API_KEY=your_key_here
      # - WHODB_ANTHROPIC_ENDPOINT=https://api.anthropic.com/v1

      # OpenAI Configuration
      - WHODB_OPENAI_API_KEY=your_key_here
      # - WHODB_OPENAI_ENDPOINT=https://api.openai.com/v1
    # volumes: # (Optional for SQLite)
    #   - ./sample.db:/db/sample.db

What's Next?

1. Connect to your database - Enter your database credentials on the login page
2. Explore your schema - Browse tables and visualize relationships
3. Run queries - Use the Scratchpad to execute SQL queries
4. Manage data - Edit, add, and delete records with ease

📖 For detailed installation options and configuration, see our Documentation

---

🛠️ Development Setup

Prerequisites

• GoLang - Latest version recommended
• PNPM - For frontend package management
• Node.js - Version 16 or higher

Editions

Community Edition (CE)

• PostgreSQL
• MySQL / MariaDB
• SQLite3
• MongoDB
• Redis
• ElasticSearch

Enterprise Edition (EE)

• All CE databases
• Oracle
• SQL Server
• DynamoDB
• Athena
• Snowflake
• Cassandra
• And more...

📚 See BUILD_AND_RUN.md for detailed build instructions and ARCHITECTURE.md for architecture details.

Frontend Development

Navigate to the frontend/ directory and start the development server:

cd frontend
pnpm i
pnpm start

Backend Development

1. Build Frontend (First-Time Setup)

If the core/build/ directory doesn't exist, build the frontend first:

cd frontend
pnpm install
pnpm run build
rm -rf ../core/build/
cp -r ./build ../core/
cd ..

Note: This is only required once, as Go embeds the build/ folder on startup.

2. Setup AI Integration (Optional)

To enable natural language queries:

1. Ollama - Download from ollama.com

   # Install Llama 3.1 8b model
   ollama pull llama3.1

   WhoDB will auto-detect installed models and show a Chat option in the sidebar.

2. OpenAI/Anthropic - Set environment variables (see Docker Compose example above)

3. Start Backend Service

cd core
go run .

The backend will start on http://localhost:8080

---

💼 Use Cases

👨‍💻 For Developers

Local Development

• Quick database inspection during development
• Debug production issues with read-only access
• Test API endpoints with real data
• Explore schema changes

API Development

• Validate data transformations
• Test query performa