Awesome GitHub RepositoriesSQL Query Generation

This project is a SQL database abstraction layer that provides a consistent object-oriented interface for interacting with multiple relational database systems. It includes a driver wrapper to standardize connections and result sets, a fluent query builder for constructing portable SQL statements, and a type mapper for converting database-specific data types into native application types and vice versa. The library enables programmatic schema management through a schema manager that can introspect database metadata, model structures as objects, and generate the SQL required to migrate between

Jeesite is a full-stack low-code development framework designed for building enterprise administrative portals using Spring Boot, MyBatis, and Vue. It functions as a comprehensive platform for creating administrative dashboards with integrated role-based access control and organizational data permission systems. The framework distinguishes itself through a combination of automated CRUD code generation and an integrated RAG platform that connects large language models to enterprise data via vector stores. It further incorporates a BPMN-based workflow engine to automate complex business process

SQLDelight is a Kotlin database library that validates SQL schema, statements, and migrations at compile time, generating type-safe Kotlin query functions from labeled SQL files. It treats SQL as the source of truth for database definitions, catching schema errors during the build process before they reach production. The library supports multiple database dialects including SQLite, MySQL, PostgreSQL, HSQL, and H2, and generates platform-specific code for Android, iOS, JVM, and JavaScript targets. It provides a platform-specific driver abstraction that handles database connectivity difference

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

JSqlParser 是一个 Java SQL 查询解析库，将原始 SQL 字符串转换为强类型 Java 对象的结构化层级。它通过将数据库查询表示为对象树，提供了程序化分析和操作数据库查询的方法。 该库支持解析现有 SQL 文本以及通过流畅 API 程序化生成新语句。它包括转换查询树并将结构化对象模型序列化回格式化 SQL 文本的机制。 其他功能包括数据库模式分析（例如提取表名以映射数据依赖关系）和 SQL 语法验证。该解析器可配置以处理不同的语法方言，并包括容错恢复功能，以便在遇到无效标记后继续处理脚本。

Querydsl 是一个用于构建类型安全查询的框架。它使用流畅的 API 和基于注解的代码生成从领域模型创建镜像类，从而实现数据库查询的编译时验证，并消除了手动字符串拼接的需要。 该项目提供了一种统一的查询语法，可转换为多个后端的特定方言，包括 SQL、MongoDB、Lucene 和 JDO。它支持高级查询功能，如公用表表达式（CTE）、窗口函数、地理空间操作和复杂的嵌套子查询。 除了数据检索外，该框架还涵盖了用于批量更新和删除的类型安全 DML 执行，以及将结果映射到 Java Bean、构造函数或元组。它包括对内存集合查询的支持，并与 Spring 框架集成以进行事务管理和连接处理。

本项目是一个用于 Laravel 应用程序的 Eloquent 查询构建器封装器和 REST API 查询解析器。它将 HTTP 请求参数转换为数据库查询，为 API 端点提供动态过滤、排序和关系加载。 该系统通过基于别名的模式抽象将外部 API 接口与存储层解耦，允许公共字段名映射到私有数据库列。它支持嵌套关系的动态包含和聚合计数，以及通过可调用类和闭包为过滤器和排序执行自定义程序逻辑。 功能覆盖面包括通过字段选择进行数据投影，以及基于请求参数的结果排序。它进一步提供了使用点符号进行基于关系的过滤的机制，与本地模型作用域的集成，以及对软删除记录可见性的控制。

Sqlcoder 是一个文本转 SQL 的大语言模型，专门用于将自然语言问题转换为结构化的、可执行的数据库查询。它作为数据库接口和查询生成器，允许在无需手动编写代码的情况下进行数据检索。 该系统利用指令微调模型，结合模式感知提示（schema-aware prompting）和动态上下文注入。通过摄取数据库元数据并使用带有示例查询对的上下文学习，它能生成符合连接数据库特定模式的语法有效查询。 该项目涵盖了更广泛的能力，包括商业智能自动化和自助式数据分析。它为数据库连接管理以及用于查询执行和元数据摄取的可视化界面提供了基础设施。

dbtpl 是一个数据库模型生成器和模式内省工具，可从 SQL 数据库模式生成类型安全的源代码和数据模型。它作为一个命令行工具，将 SQL 类型映射到 Go 结构体和执行函数，同时提供了一个基于模板的系统，用于创建自定义源代码和模式定义。 该工具支持多种数据库引擎，包括 PostgreSQL、MySQL、SQLite、Oracle 和 SQL Server。它的独特之处在于允许用户通过文本模板定义自定义输出格式，并能为 Django Web 框架生成兼容的模型定义。 其功能还包括生成用于数据库迁移和镜像的 SQL 脚本，以及以 JSON 或 YAML 格式导出模式表示。此外，它还可以生成 dot 文件以可视化数据库关系和结构图。

xo 是一个用于从 SQL 数据库模式和查询生成类型安全的 Go 模型和查询执行代码的工具。它是一个多方言 SQL 工具，支持 PostgreSQL、MySQL、SQLite、Oracle 和 Microsoft SQL Server，以生成地道的源代码。 该项目使用基于模板的生成系统，允许通过可自定义的文本模板定义生成的数据库源代码的结构和逻辑。它还包括一个数据库模式可视化器，用于分析表关系和定义，以创建可视化图表和结构化文档。 该工具的功能涵盖自动化 SQL 代码生成和创建专门的数据库模型。它提供了将自定义 SQL 查询映射到 Go 函数以及生成模式脚本以记录数据库迁移的实用程序。

Langroid is a multi-agent orchestration framework and tool integration suite designed for building complex AI applications. It serves as a multi-modal integration layer that connects diverse local and remote language models with an agentic retrieval-augmented generation system. The project distinguishes itself through a collaborative message-exchange paradigm, allowing specialized agents to delegate tasks hierarchically and coordinate via structured communication. It features an advanced state management system for conversational AI, including the ability to rewind and prune conversation hist

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

DataFlow is an agent-based workflow orchestrator and data pipeline designed to synthesize, clean, and augment large-scale datasets for training large language models. It functions as a synthetic data generator and text curation tool, utilizing an intelligent assistant to assemble modular processing operators into functional pipelines based on user requirements. The project distinguishes itself through a low-code approach, providing a web-based visual interface for designing and monitoring multi-stage execution flows. It features an operator-based registry system that allows for the integratio

Ormar is an asynchronous object-relational mapper for Python that integrates database persistence with data validation. It functions as a bridge between relational database management and application-level data structures, allowing developers to define database schemas that serve simultaneously as validation models. The project distinguishes itself by using validation classes to enforce schema integrity, ensuring that all persisted records conform to defined types and structures. It supports complex relational associations, including one-to-many and many-to-many relationships, and provides ev

This project is a database toolkit for Go that provides schema-to-object mapping, fluent query construction, and automated code generation. It functions as a framework for type-safe database access, enabling developers to interact with relational databases by generating models and interfaces directly from existing database schemas. The toolkit distinguishes itself through a workflow that parses hand-written SQL files to generate type-safe functions, allowing for the integration of custom SQL while maintaining consistent result mapping. It supports modular customization through a plugin-based