Awesome GitHub RepositoriesSQL Enhancement

Chat2DB is an AI-powered SQL client and multi-database management GUI. It serves as a centralized graphical interface for administering diverse relational and non-relational database engines, integrating large language models to transform natural language prompts into executable SQL statements and application code. The tool utilizes schema-aware prompt engineering to inject database metadata into AI requests, ensuring generated queries match the actual schema. It also functions as an AI data reporting tool, using artificial intelligence to create dashboards and visual reports directly from da

Vanna is a Python framework designed to build conversational interfaces that translate natural language into executable database queries. It functions as an enterprise-grade toolkit that connects language models to relational databases, allowing users to retrieve information through conversational prompts rather than manual code. The system maintains context across interactions by utilizing vector databases to store historical query patterns and schema metadata. The framework distinguishes itself through a focus on security and schema-aware generation. It incorporates granular access control,

WrenAI is a platform designed to enable natural language interaction with relational and analytical databases. By combining a text-to-SQL engine with semantic data modeling, it allows users to explore structured data through plain language questions, removing the requirement for manual code generation. The system functions by grounding natural language requests in a predefined business logic layer rather than raw database schemas. This semantic approach, supported by context-aware prompt engineering, ensures that generated queries remain consistent and accurate across an organization. The pla

SQL Chat is a Docker-deployed chat interface that translates natural language questions into SQL queries and executes them against connected databases. It uses a large language model to generate SQL from plain English instructions, supporting both querying and record modification through INSERT, UPDATE, and DELETE statements within the chat conversation flow. The application connects to MySQL, PostgreSQL, MSSQL, TiDB Cloud, and OceanBase databases through a unified driver abstraction layer, allowing users to interact with multiple database types from a single chat interface. Users provide the

Supersonic este o platformă de analiză a datelor bazată pe LLM și un motor de strat semantic care traduce întrebările în limbaj natural în interogări SQL executabile. Funcționează ca un dashboard de business intelligence și interfață text-to-SQL, permițând utilizatorilor să recupereze metrici de business și insight-uri printr-o interfață conversațională. Sistemul decuplează definițiile de business de schemele fizice ale bazelor de date prin utilizarea unui strat logic guvernat pentru a defini metrici și dimensiuni unificate. Această modelare semantică permite platformei să mapeze tiparele limbajului uman la modele curatoriate și să traducă declarațiile semantice abstracte în SQL fizic adaptat pentru motoare de baze de date specifice. Platforma oferă un gateway de date enterprise cu control de acces granular și bazat pe roluri la nivel de dataset, coloană și rând. Capabilitățile sale includ gestionarea dialogului multi-turn, conectivitate multi-bază de date și o arhitectură de plugin-uri pentru integrarea instrumentelor terțe. Proiectul își expune funcționalitatea printr-un API programatic headless și un API de strat semantic pentru consumul extern de date.

DataHerald is a natural language text-to-SQL interface and data analytics tool that translates English questions into executable database queries using a large language model. It functions as a query generator and connectivity layer capable of retrieving database records and summarizing the results into human-readable explanations. The project features a dedicated business logic layer for defining database constraints and managing verified query pairs to improve translation accuracy. It acts as a multi-warehouse data connector, allowing for the indexing and querying of multiple SQL databases