Awesome GitHub RepositoriesMulti-Database Connections

TypeORM is an object-relational mapper for TypeScript and JavaScript that bridges the gap between object-oriented application code and relational database tables. It provides a comprehensive data persistence layer that allows developers to define database entities using class decorators or configuration objects, enabling seamless interaction with data through object-oriented patterns. The project distinguishes itself through a flexible architecture that supports both the data mapper and repository patterns, alongside a fluent query builder that translates high-level method calls into platform

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

Beekeeper Studio is a cross-platform desktop application designed for database management and SQL development. It provides a unified graphical interface to connect to, query, and modify data across a wide range of relational and NoSQL database systems. The application functions as a comprehensive workspace, integrating tools for schema design, record editing, and data visualization. The project distinguishes itself through a focus on secure, flexible connectivity and AI-assisted workflows. It supports advanced authentication methods, including enterprise single sign-on, multi-factor authentic

EntityFramework is a .NET object-relational mapper that translates application objects into database tables and rows. It functions as a query engine that converts high-level expressions into optimized SQL commands for data retrieval. The project provides a mechanism for monitoring modifications to loaded objects to synchronize application state with the database. It also includes a system for synchronizing database structures with data models using versioned migration scripts. The framework supports multi-backend database integration through a plugin system, allowing a single application to

Entity Framework Core is an object-relational mapper that enables developers to interact with database systems using strongly-typed code. It serves as a comprehensive data access framework, providing a unified interface for mapping application objects to relational and non-relational database schemas while managing the lifecycle of data operations through a central context. The project distinguishes itself through a provider-based architecture that decouples core data access logic from specific database engines, allowing for consistent interaction across diverse storage systems. It features a

This project is a self-hosted, cross-platform instant messaging platform featuring a Go backend and a protobuf-based messaging server. It provides a unified communication suite with native clients for iOS, Android, and web, utilizing gRPC and Protocol Buffers for efficient data exchange. The system is distinguished by an extensible chatbot framework that allows for the integration of automated bots and plugins via standardized service interfaces. It supports high-availability clustering with sharded load distribution and a pluggable database backend to ensure reliability and flexible data per

usql is a universal SQL command-line interface used to connect to and manage multiple SQL and NoSQL databases through a single unified tool. It provides a standardized interface for executing queries across various data stores and serves as a multi-database query tool and schema inspector. The tool distinguishes itself by enabling cross-database data migration, allowing users to pipe result sets from one active database connection directly into another. It also features terminal-based data visualization, which renders query results as graphical charts, graphs, and images directly within the t

pgweb is a web-based database client and graphical administration tool for PostgreSQL. It provides a browser-based interface for executing SQL queries, inspecting schemas, and managing database objects. The tool includes a read-only mode that prevents destructive operations by blocking specific SQL keywords. It supports secure remote access to private instances through native SSH tunneling and encrypted database connections. The application covers a broad range of management capabilities, including multi-environment session management, database structure inspection, and the export of query r

Kotlin SQL Framework

JimuReport is an open-source reporting and dashboard engine designed to be embedded directly into Spring Boot applications. Its core identity centers on generating data reports and full-screen dashboards from natural language descriptions, eliminating the need for manual design. The platform also provides a conversational query interface that translates plain-language questions into database queries, returning results as tables and charts without requiring SQL knowledge. What distinguishes JimuReport is its integration of AI skills that can be installed with a single command, enabling report

Archery is a suite of specialized utilities for database schema migration, SQL audit and review, mapping parsing, and performance analysis. It functions as a centralized platform for reviewing, executing, and auditing SQL queries across multiple database environments through controlled workflows. The platform includes a mapping parser that converts XML files into readable SQL statements to simplify the review of application-generated queries. It also provides tools for parsing slow query logs and analyzing execution patterns to optimize database indexes and speeds. The system covers broad da

DbGate is a universal database management tool and SQL client that provides a unified interface for querying and administering multiple SQL and NoSQL databases. It functions as a multi-database administration GUI and SQL IDE, allowing users to write and execute scripts and manage database schemas. The project distinguishes itself by acting as an API client and explorer for REST, GraphQL, and OData services, enabling users to fetch and export data from these endpoints. It also serves as a data integration tool, facilitating the movement of records between diverse databases and file formats suc

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

Harlequin is a terminal-based SQL IDE that runs queries against DuckDB and SQLite databases, with a plug-in adapter system for connecting to additional database engines. It provides a full-screen text editor with syntax highlighting and fuzzy autocomplete for writing SQL, and displays query results in a scrollable table within the terminal. The application distinguishes itself through a tree-based data catalog that lets you browse database schemas, local files, and remote S3 objects, with the ability to insert or copy paths directly into the query editor. It supports custom key bindings throu

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

Blog.Core 是一个生产就绪的后端样板，用于使用 ASP.NET Core 构建企业级 API 和微服务。它为分布式系统提供了基础架构，包括用于数据库优先（database-first）脚手架和实现多租户 API 框架的工具。 该项目的特色在于自动数据层生成，可直接从数据库模式生成实体模型和存储库层。它使用标准身份服务器协议实现了集中式身份管理系统，以处理跨多个客户端和项目的身份验证和授权。 该框架涵盖了广泛的企业级功能，包括通过事件总线进行的异步消息处理、分布式内存缓存以及读写数据库流量分离。它结合了具有部门数据限制的基于角色的访问控制，并通过 API 性能分析和活动审计提供系统可观测性。 该系统还包括对用于推送通知的双向服务器-客户端通信、全文搜索集成以及集中式服务配置的支持。

CloudBeaver 是一个基于 Web 的数据库管理器和云数据库 IDE，提供了一个用于管理 SQL 和 NoSQL 数据库的集中式浏览器界面。它作为一个多数据库管理工具和 RBAC 数据库访问网关，允许用户通过单一的服务器端安装来管理各种关系型和文档型数据库引擎。 该平台通过集成用于自然语言 SQL 生成和优化的 AI 助手而脱颖而出。它进一步通过集中式访问管理和基于角色的权限，协调团队间的数据库操作，从而支持协作式数据工程。 该系统涵盖了广泛的功能，包括通过树状模式浏览器和网格编辑器进行可视化数据探索，以及全面的连接管理和数据传输工具。它还包括用于发现和管理云服务提供商托管的数据库资源的专门工具。 该应用程序作为客户端-服务器系统部署，支持通过 Web 浏览器进行远程数据库管理。

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

Bun 是一个 Go 语言的类型安全对象关系映射器（ORM），优先考虑 SQL 优先的查询构建和结果映射。它作为一个可编程 SQL 查询构建器、数据库连接管理器以及将数据库表映射到 Go 结构体的工具。 该项目通过多方言 SQL 支持系统脱颖而出，允许单个代码库通过一致的接口与不同的数据库引擎交互。它包括一个用于查询拦截、分布式跟踪和日志记录的内置数据库可观测性工具，以及一个用于版本化结构变更的模式迁移工具。 该库涵盖了广泛的数据操作，包括批量处理、Upsert、软删除以及多态关联等关系数据的管理。它提供使用公用表表达式（CTE）和窗口函数进行高级 SQL 分析的功能，以及原子事务管理和连接池。 模式管理通过用于应用版本化迁移脚本的命令行界面支持。

Rainfrog is a terminal-based database client that connects to multiple database engines, combining schema browsing, interactive SQL query execution, and inline data editing into a single terminal interface. It provides a tree navigator for exploring tables, columns, and indexes, and an inline cell editor that automatically constructs and executes the necessary UPDATE statements when a cell value is changed. The application also supports modal Vim-style keyboard shortcuts for cursor movement and editing, making it usable entirely from the keyboard. Query results are fetched in chunks and pagin