Awesome GitHub RepositoriesLLM-Based SQL Generation

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

mycli is a MySQL command line client, database administration tool, and SQL query editor. It functions as a terminal interface for executing queries and managing MySQL connections, incorporating an integrated assistant that uses large language models to generate and analyze SQL statements based on the current database schema. The tool provides specialized query authoring capabilities, including context-sensitive syntax suggestions, fuzzy-matching identifier completion for tables and columns, and the ability to handover query buffers to external system text editors. It distinguishes its connec

This project is a collection of tutorials and guides for building large language model applications using the LangChain framework, written in Chinese. It serves as a learning resource for developing software that integrates language models with memory and chain-based logic. The resource provides specific walkthroughs for implementing retrieval augmented generation systems using vector stores and document loaders. It includes guides on creating autonomous agents that dynamically select and execute external tools, as well as tutorials for translating plain text queries into executable database

🔥 基于大模型和 RAG 的智能问数系统，对话式数据分析神器。Text-to-SQL Generation via LLMs using RAG.

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 是一个基于 LLM 的数据分析平台和语义层引擎，可将自然语言问题转换为可执行的 SQL 查询。它作为一个商业智能仪表板和 Text-to-SQL 接口，允许用户通过对话界面检索业务指标和洞察。 该系统通过使用受控的逻辑层来定义统一的指标和维度，将业务定义与物理数据库模式解耦。这种语义建模允许平台将人类语言模式映射到精选模型，并将抽象的语义陈述转换为针对特定数据库引擎定制的物理 SQL。 该平台提供了一个企业级数据网关，具有数据集、列和行级别的基于角色的细粒度访问控制。其能力包括多轮对话管理、多数据库连接以及用于第三方工具集成的插件架构。 该项目通过无头编程 API 和用于外部数据消费的语义层 API 暴露其功能。

该项目是一个开发人员工具，作为人工智能驱动的数据库查询管理助手。它提供了一个交互式界面，用于在自然语言和结构化数据库代码之间进行转换，简化了编写、调试和维护复杂查询的过程。 该工具通过结合模式感知上下文注入脱颖而出，这使其能够将生成的查询与特定的表定义和关系元数据对齐。通过维护有状态的对话历史并利用大语言模型提示，它使用户能够迭代地优化查询，并接收考虑到其数据库环境特定逻辑和结构的解释。 除了核心翻译外，该工具还支持分析现有代码以识别语法错误，并提供复杂查询逻辑的通俗易懂的分解。它还包括用于格式化数据库代码和管理本地翻译日志历史记录的功能，以促进过去工作的重用。

Briefer is an interactive data notebook platform and business intelligence dashboard tool used for collaborative data analysis and reporting. It provides a containerized environment for building reports that combine SQL, Python, and Markdown with native visualizations. The platform features an integrated code assistant that uses large language models to generate SQL and Python snippets from natural language prompts. It is designed as a Kubernetes data application, deploying via Helm charts to manage isolated compute environments and ensure separate resources per page through pod-based isolati

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