clidey/whodb
Whodb
whodb est une interface de gestion multi-base de données et un client de type notebook conçu pour explorer et gérer les données à travers divers moteurs, incluant Postgres, MySQL, MongoDB et Redis. Il fonctionne comme une interface graphique pour gérer les connexions, les enregistrements et les schémas de bases de données via une couche unifiée.
Le projet propose une interface de requête en langage naturel qui utilise des grands modèles de langage pour traduire l'anglais courant en requêtes SQL ou NoSQL exécutables. Ceci est soutenu par un prompting conscient du schéma qui injecte les métadonnées de la base de données dans le contexte du modèle pour garantir que les requêtes générées correspondent aux définitions réelles des tables.
Les capacités supplémentaires incluent un visualiseur de schéma qui transforme les métadonnées de clés étrangères en réseaux de graphes interactifs et un générateur de données synthétiques pour créer des jeux de données fictifs. L'outil fournit également un modèle d'exécution de type notebook pour organiser les requêtes en cellules séquentielles, des options d'exportation de données pour des formats comme CSV et JSON, et une interface en ligne de commande pour l'administration de l'environnement.
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.
