clidey/whodb
Whodb
whodb is a multi-database management interface and notebook client designed for exploring and managing data across various engines, including Postgres, MySQL, MongoDB, and Redis. It functions as a graphical interface for managing database connections, records, and schemas through a unified layer.
The project features a natural language query interface that uses large language models to translate plain English into executable SQL or NoSQL queries. This is supported by schema-aware prompting that injects database metadata into the model context to ensure generated queries match actual table definitions.
Additional capabilities include a schema visualizer that transforms foreign key metadata into interactive graph networks and a synthetic data generator for creating mock datasets. The tool also provides a notebook-style execution model for organizing queries into sequential cells, data export options for formats like CSV and JSON, and a command line interface for environment administration.
Features
- Database Management Interfaces - Provides a graphical management interface for exploring and managing data across various database engines.
- Natural Language Query Interfaces - Offers a natural language interface powered by LLMs to execute database queries without writing code.
- Database Record Managers - Offers a graphical grid for editing, sorting, and filtering database records with support for bulk operations.
- Natural Language to SQL - Translates natural language prompts into executable SQL and NoSQL queries using large language models.
- Database Abstraction Layers - Provides a unified API layer to normalize operations across multiple database engines like Postgres, MySQL, MongoDB, and Redis.
- Notebook Query Editors - Implements a notebook-style execution model that organizes database queries into sequential cells with stored results.
- Database Connection Managers - Provides a centralized graphical interface to connect to and explore multiple database types.
- Database Query Execution - Executes and organizes data requests within a notebook editor featuring syntax highlighting and history.
- Database Schema Visualizers - Maps database relationships by transforming foreign key metadata into an interactive visual network of connected nodes.
- Natural Language Querying - Uses large language models to translate natural language prompts into executable database queries.
- Unified Database Interfaces - Provides a unified interface that abstracts multiple database engines through a common connection layer.
- Notebook Execution Environments - Implements a notebook-style execution model where database interactions are organized into sequential cells.
- Notebook Code Execution - Organizes database interactions into a sequential history of cells combining executable code with result sets.
- Schema Context Exposers - Exposes database schemas to AI assistants through a standardized protocol to facilitate automated interaction.
- General Synthetic Data Generators - Generates realistic mock datasets based on database schemas for populating test and development environments.
- Schema-Aware Prompting - Injects structural database metadata into LLM prompts to ensure generated queries match actual table definitions.
- Cluster Topology Visualization - Provides a graphical visualization of database table relationships and foreign keys as a network graph.
- Database Record Exports - Allows exporting database records into portable formats including CSV and JSON for external analysis.
- Test Data Generators - Provides a synthetic data generation engine to create realistic mock datasets for database testing and validation.
- Database Connection Environments - Offers a terminal-based administration layer for managing database connections and environments.
- Database CLI Administration Tools - Provides a command-line interface for administering database instances and managing connections outside the graphical UI.
- Database CLI Tools - Provides a terminal-based command line interface for administering database environments across multiple operating systems.
- Schema-to-Graph Transformation - Transforms database foreign key metadata into a node-and-edge structure for visual mapping.
- Mock Data Generators - Creates realistic test datasets to populate databases and validate application behavior during development.
- AI Coding Assistants - AI-powered chat interface for exploring various database types.
- Database GUIs - Lightweight database explorer for SQL, NoSQL, and caches.
Star history
How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.
