Awesome
<img src="./docs/images/logo.png" width="30px" height="auto" /> WhoDB
Build Status: <img src="https://hello.clidey.com/api/flows/status?id=b32257fa-1415-4847-a0f3-e684f5f76608&secret=cd74dbd5-36ec-42f9-b4f0-12ce9fcc762b" alt="Clidey build status" height="20px" />
"Is it magic? Is it sorcery? No, it's just WhoDB!"
<p align="center"><img src="./docs/images/trailer.png" alt="Trailer" width="100%" height="auto" /></p> <details> <summary>View screenshots of WhoDB</summary> <img src="./docs/images/album_table_view.png" alt="View of the Album table" width="100%" height="auto" /> <img src="./docs/images/edit_view.png" alt="Edit view pop-up" width="100%" height="auto" /> <img src="./docs/images/export_delete_btns.png" alt="Export and delete buttons in action" width="100%" height="auto" /> <img src="./docs/images/scratchpad2.png" alt="The scratchpad functionality" width="100%" height="auto" /> <img src="./docs/images/table_view.png" alt="All available tables in the current database" width="100%" height="auto" /> </details> <div style="width:100%;border-bottom:0.5px solid white;margin:50px 0px;"></div>Table of Contents
- Description
- Key Features
- Demo
- Documentation
- Quick Start
- Development Setup
- Frontend
- Backend
- FAQs
- Contributing
- Infrastructure
- Contact details
Description
WhoDB is a lightweight (~20MB), powerful, and user-friendly database management tool designed to streamline your database administration tasks. Combining the simplicity of Adminer with enhanced UX and performance, WhoDB is built with GoLang to deliver optimal speed and efficiency. With features like interactive schema visualization and inline editing, WhoDB caters to both small projects and complex enterprise systems.
WhoDB offers you the opportunity to talk to your data using natural language thanks to our integration with Ollama, ChatGPT, and Anthropic. This feature allows you to perform queries and manage your data through conversation instead of complex SQL.
Key Features
- Conversate With Your Data: No more wasting time crafting complex SQL queries - ask away!
- Enhanced UX: A clean, intuitive interface that’s easy to navigate.
- Blazing Fast Performance: Built with GoLang for exceptional speed, including table virtualization on the frontend.
- Schema Visualization: Interactive graphs to easily visualize your database schema.
- Inline Editing & Preview: Edit and preview data directly in the interface.
- Broad Database Support: Compatible with PostgreSQL, MySQL, SQLite3, MongoDB, Redis, MariaDB, & ElasticSearch.
- Scratchpad: A Jupyter notebook-like interface for performing database queries.
Try the demo
Experience WhoDB firsthand with our live demo.
Note: This demo is populated with a sample database from postgresDBSamples, with credentials pre-filled.
Or checkout our demo video
Documentation
For more detailed information, check out our Documentation.
<div style="width:100%;border-bottom:0.5px solid white;margin:50px 0px;"></div>Quick Start
Get up and running with WhoDB quickly using Docker:
docker run -it -p 8080:8080 clidey/whodb
If you are using a remote Ollama server, please start Docker with Ollama Environments like this:
docker run -it -e WHODB_OLLAMA_HOST=YOUR_OLLAMA_HOST -e WHODB_OLLAMA_PORT=YOUR_OLLAMA_PORT -p 8080:8080 clidey/whodb
Or, use Docker Compose:
version: "3.8"
services:
whodb:
image: clidey/whodb
# volumes: # (optional for sqlite)
# - ./sample.db:/db/sample.db
# environment:
# WHODB_OLLAMA_HOST:YOUR_OLLAMA_HOST
# WHODB_OLLAMA_PORT:YOUR_OLLAMA_PORT
ports:
- "8080:8080"
Access WhoDB by navigating to http://localhost:8080 in your browser.
<div style="width:100%;border-bottom:0.5px solid white;margin:20px 0px;"></div>Development Setup
Prerequisites
- GoLang (latest version recommended)
- PNPM (latest version recommended)
Frontend Setup
To start the frontend service, navigate to the frontend/ directory and run:
pnpm i && pnpm start
Backend Setup
1. Preparing the Frontend for the Backend (Only if you don’t have a build/ directory in core/):
If the core/ directory doesn't have a build/ folder, you'll need to build the frontend and move it to the backend directory. From the root directory, run:
cd frontend && pnpm install && pnpm run build && rm -rf ../core/build/ && cp -r ./build ../core/ && cd -;
This command will compile the frontend and copy the build/ folder to core/.
This step is required because Go will attempt to embed the build/ folder on each launch.
You only need to do this once.
2. Setting up Ollama (if you'd like to enable the natural conversation integration)
Go to https://ollama.com/ and download it for your system. Once that is done, we recommend that you start out with the Llama 3.1 8b model. WhoDB will automatically detect your installed model(s) and will show you a Chat option on the left sidebar.
3. Starting the Backend Service
If the core/ directory already has a build/ folder, or once you've completed the step above, you can start the backend service by running:
cd core/
go run .
FAQs
What inspired the creation of WhoDB?
WhoDB was inspired by Adminer for its lightweight nature and ease of use. We aimed to build on these qualities with enhanced visualization and a consistent user experience across various databases.
How does WhoDB handle large queries?
WhoDB supports lazy loading, ensuring smooth performance even with large datasets.
What makes WhoDB different from DBeaver?
Unlike DBeaver, which is feature-rich but resource-heavy, WhoDB is designed to be lightweight and efficient, running on minimal resources—perfect for smaller setups or resource-constrained environments.
Is WhoDB compatible with any database? WhoDB supports a wide range of databases, providing a consistent experience across SQL, NoSQL, and Graph databases. Currently, it supports PostgreSQL, MySQL, SQLite3, MongoDB, Redis, MariaDB, & ElasticSearch.
How do I deploy WhoDB? WhoDB can be deployed easily using Docker or Docker Compose. See the "Quick Start" section for details.
Q: Is WhoDB suitable for production environments?
While WhoDB is lightweight and efficient, we recommend evaluating its suitability for your specific production environment.
Contributing
We welcome contributions from the community! Feel free to open issues or submit pull requests to help improve WhoDB. We have a contribution guide here.
Infrastructure
WhoDB's deployment and CI/CD are managed by Clidey, a no-code DevOps platform. For more information, visit https://clidey.com
Clidey Build Status: <img src="https://hello.clidey.com/api/flows/status?id=b32257fa-1415-4847-a0f3-e684f5f76608&secret=cd74dbd5-36ec-42f9-b4f0-12ce9fcc762b" alt="Clidey build status" height="20px" />
Contact
For any inquiries or support, please reach out to support@clidey.com.
"Is it magic? Is it sorcery? No, it's just WhoDB!"