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 is a production-ready backend boilerplate for building enterprise APIs and microservices using ASP.NET Core. It provides a foundational infrastructure for distributed systems, including tools for database-first scaffolding and the implementation of multi-tenant API frameworks. The project distinguishes itself through automated data layer generation, which produces entity models and repository layers directly from database schemas. It implements a centralized identity management system using standard identity server protocols to handle authentication and authorization across multiple

CloudBeaver ist ein webbasierter Datenbankmanager und eine Cloud-Datenbank-IDE, die ein zentralisiertes Browser-Interface für die Administration von SQL- und NoSQL-Datenbanken bereitstellt. Es fungiert als Multi-Datenbank-Administrationstool und RBAC-Datenbank-Zugriffs-Gateway, das es Nutzern ermöglicht, diverse relationale und dokumentenbasierte Datenbank-Engines über eine einzige serverbasierte Installation zu verwalten. Die Plattform zeichnet sich durch die Integration eines KI-Assistenten für die Generierung und Optimierung von SQL in natürlicher Sprache aus. Zudem unterstützt sie kollaboratives Data-Engineering durch die Koordination von Datenbankoperationen über Teams hinweg mittels zentralisiertem Zugriffsmanagement und rollenbasierten Berechtigungen. Das System deckt ein breites Spektrum an Funktionen ab, einschließlich visueller Datenexploration über baumbasierte Schema-Browser und rasterbasierte Editoren sowie umfassende Verbindungsverwaltung und Datentransfer-Utilities. Es enthält zudem spezialisierte Tools zum Entdecken und Verwalten von Datenbankressourcen, die von Cloud-Service-Anbietern gehostet werden. Die Anwendung wird als Client-Server-System bereitgestellt, was die Remote-Datenbankadministration über einen Webbrowser ermöglicht.

Supersonic ist eine LLM-basierte Datenanalyseplattform und eine Engine für semantische Layer, die natürlichsprachliche Fragen in ausführbare SQL-Abfragen übersetzt. Sie fungiert als Business-Intelligence-Dashboard und Text-zu-SQL-Schnittstelle, die es Benutzern ermöglicht, Geschäftskennzahlen und Erkenntnisse über eine Konversationsschnittstelle abzurufen. Das System entkoppelt Geschäftsdefinitionen von physischen Datenbankschemata, indem es einen verwalteten logischen Layer verwendet, um einheitliche Metriken und Dimensionen zu definieren. Diese semantische Modellierung ermöglicht es der Plattform, menschliche Sprachmuster auf kuratierte Modelle abzubilden und abstrakte semantische Aussagen in physisches SQL zu übersetzen, das auf spezifische Datenbank-Engines zugeschnitten ist. Die Plattform bietet ein Enterprise-Data-Gateway mit rollenbasierter und granularer Zugriffskontrolle auf Datensatz-, Spalten- und Zeilenebene. Zu ihren Fähigkeiten gehören Multi-Turn-Dialogmanagement, Multi-Datenbank-Konnektivität und eine Plugin-Architektur für die Integration von Drittanbieter-Tools. Das Projekt stellt seine Funktionalität über eine Headless-Programmatic-API und eine Semantic-Layer-API für den externen Datenkonsum bereit.

Bun ist ein typsicherer Object-Relational-Mapper für Go, der SQL-first-Abfragekonstruktion und Result-Mapping priorisiert. Er fungiert als programmierbarer SQL-Abfrage-Builder, Datenbank-Verbindungsmanager und Tool zur Abbildung von Datenbanktabellen auf Go-Structs. Das Projekt zeichnet sich durch ein Multi-Dialekt-SQL-Unterstützungssystem aus, das es einer einzigen Codebasis ermöglicht, über eine konsistente Schnittstelle mit verschiedenen Datenbank-Engines zu interagieren. Es enthält ein integriertes Datenbank-Observability-Tool für Abfrage-Interzeption, verteiltes Tracing und Logging sowie ein Schema-Migrations-Tool zur Versionierung struktureller Änderungen. Die Bibliothek deckt ein breites Spektrum an Datenoperationen ab, einschließlich Bulk-Verarbeitung, Upserts, Soft-Deletes und der Verwaltung relationaler Daten wie polymorpher Assoziationen. Sie bietet Funktionen für fortgeschrittene SQL-Analysen unter Verwendung von Common Table Expressions und Window-Funktionen, neben atomarem Transaktionsmanagement und Connection-Pooling. Das Schema-Management wird über eine Kommandozeilenschnittstelle zur Anwendung versionierter Migrationsskripte unterstützt.

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