Awesome GitHub RepositoriesSQL Query Editors

Chat2DB is an AI-powered SQL client and multi-database GUI manager designed for managing various relational and NoSQL database systems. It serves as a visual database management tool and a natural language to SQL interface, allowing users to convert plain text descriptions into executable and optimized queries. The platform distinguishes itself through automated business intelligence capabilities, which include the generation of real-time data visualization dashboards and AI-driven data analysis from spreadsheets. To ensure data privacy, it supports secure local AI deployment, enabling large

This project is a collection of educational resources and reference implementations for the Apache Flink stream processing framework. It provides a learning resource focused on mastering distributed stream processing through implementation guides, performance tuning tutorials, and practical examples. The repository features detailed walkthroughs for building real-time data pipelines using the DataStream and Table APIs. It includes specific integration examples for connecting Apache Flink with Kafka brokers and Elasticsearch indices, as well as reference implementations for real-time deduplica

Buf is a toolchain for managing the full lifecycle of Protocol Buffers schemas. It provides a set of tools for schema governance, including linting to enforce style guides, a breaking change detector to ensure backward compatibility, and a system for producing language-specific source code via local or remote plugins. The project distinguishes itself through a remote schema registry that centralizes the hosting, versioning, and distribution of Protocol Buffers modules. This registry allows for server-side enforcement of governance policies, such as blocking updates that introduce backward-inc

Adminer is a PHP-based database management tool and multi-engine database client. It provides a web-based graphical interface for administering various relational and document database engines. The application is distributed as a single file to simplify installation and deployment on web servers. It supports customization through external stylesheets for visual themes and a plugin architecture to extend core functionality and system behaviors. The tool covers database schema administration, including the creation of views and management of foreign keys. It includes a SQL query editor with au

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

Feast is an open-source feature store for machine learning that provides a central platform for defining, storing, and serving features across both training and inference workflows. It operates as a declarative system where feature definitions are written as code in Python files, synchronized to a central registry, and made available for low-latency online retrieval or point-in-time correct historical joins for training datasets. The project abstracts storage behind a pluggable architecture, allowing offline and online backends to be swapped without changing retrieval logic, and coordinates ma

Stack Auth is an open-source authentication and authorization platform that provides pre-built UI components, OAuth integration, team management, and session handling for web applications. It offers a complete authentication lifecycle covering sign-in, sign-up, session management, password recovery, and multi-factor security, with support for passkey authentication and OAuth providers including Google, GitHub, and Apple. The platform includes a team-based permission system with role-based access control, allowing users to be organized into teams with granular permissions for membership manage

jOOQ is a type-safe SQL query builder for Java that generates code from live database schemas, enabling compile-time validation of SQL syntax and data types. Its core identity is built around a fluent DSL that mirrors SQL structure, a code generator that maps tables, views, and routines to Java objects, and a multi-dialect engine that translates the same DSL into vendor-specific SQL for over 30 databases. The project also includes a SQL parser and transformer for refactoring or dialect conversion, reactive stream integration for non-blocking query execution, and a JDBC proxy diagnostics tool f

SQLiteStudio is an open-source graphical tool for browsing, editing, and managing SQLite database files. It combines a full-featured SQL editor with syntax highlighting, a visual database schema designer for creating entity-relationship diagrams, and a plugin-based extensibility platform that allows adding custom functionality through C/C++, JavaScript, Tcl, or Python. The application distinguishes itself through its multi-language scripting engine, which embeds JavaScript, Tcl, and Python interpreters to enable user-defined functions and scripts within SQL queries. It supports encrypted data

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

A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase and Firebird, written in Delphi and Lazarus/FreePascal

Pinot is a distributed, columnar analytical database designed for high-concurrency, low-latency query processing. It functions as a real-time OLAP datastore, enabling interactive, user-facing analytics by ingesting and querying massive datasets from both streaming and batch sources. The system architecture relies on a centralized controller for cluster coordination and a distributed segment-based storage model to ensure horizontal scalability. The platform distinguishes itself through a hybrid ingestion pipeline that unifies real-time event streams and historical batch data into a single quer

Fleet is an open-source device management platform that provides centralized control over computing devices running macOS, Linux, Windows, Chromebooks, iOS, and Android. It enables organizations to enroll devices, collect real-time telemetry, enforce security compliance policies, and manage software remotely from a single system. The platform can be deployed as a single binary, run locally for testing, or scaled horizontally across cloud infrastructure on AWS, Kubernetes, GCP, or Render, with support for high availability through database replication and load balancing. The platform distingui

Studio este un instrument containerizat de gestionare a bazelor de date SQL care oferă o interfață grafică bazată pe browser pentru executarea interogărilor și gestionarea datelor în diverse baze de date SQL. Constă într-un editor de interogări specializat și o interfață grafică de administrare concepută pentru administrarea bazelor de date bazată pe web. Proiectul dispune de un editor de interogări SQL de înaltă performanță cu auto-completare și sugestii de funcții pentru rularea simultană a mai multor comenzi de bază de date. Include un editor vizual de schemă pentru crearea și modificarea coloanelor tabelelor și un editor de înregistrări care stadiul și previzualizează schimbările înainte ca acestea să fie comise în sursă. Platforma acoperă conectivitatea bazelor de date și sincronizarea profilurilor, integrarea SQL multi-dialect și un framework de extensie a interfeței utilizator pentru adăugarea de logică personalizată în meniuri, tab-uri și bare laterale. Utilizează un wrapper desktop pentru a face punte între driverele de baze de date care sunt altfel restricționate în mediile standard de browser web. Aplicația este împachetată ca o imagine Docker pentru a asigura un deployment consistent pe diferite platforme de hosting.

AliSQL is a fork of MySQL by Alibaba that extends the relational database management system with enhancements for high performance, scalability, and enterprise-grade availability. It retains the core MySQL identity as a SQL-based database for storing, organizing, and retrieving structured data, while adding optimizations for large-scale transactional and analytical workloads. The project differentiates itself through a set of Alibaba-specific improvements, including a columnar engine for accelerating analytical queries directly on MySQL tables, and a distributed, shared-nothing NDB Cluster en

Perfetto is a platform for system-level performance tracing and analysis on Linux and Android. It combines a high-throughput trace recorder, a SQL-based query engine, and a browser-based visualizer into a single toolchain. The platform covers CPU scheduling and call-stack profiling, native and Java heap memory allocation tracking, GPU and graphics events, and system-wide counters such as CPU frequency and power consumption. The architecture decouples trace recording from offline analysis, using a compact protobuf format for event encoding and columnar storage for efficient SQL queries. The we

Beancount is a plain-text double-entry accounting system. It enforces zero-sum transactions, organizes accounts into a hierarchical five-type tree, and verifies balances at specific dates using precision-derived tolerances. Transactions are recorded in plain-text files with a strict syntax that supports currency-specific rounding, automatic interpolation of missing amounts, and comprehensive metadata including tags, links, and payee annotations. Beyond core bookkeeping, Beancount offers investment portfolio tracking with lot-based cost basis management, configurable booking strategies (FIFO,

This project is a Language Server Protocol implementation for PostgreSQL that provides autocompletion, syntax diagnostics, and type checking for SQL and PL/pgSQL. It functions as a database schema validator and a static analysis engine designed to detect security vulnerabilities, performance bottlenecks, and dangerous migration patterns in database scripts. The server differentiates itself by using live database connections to provide schema-aware intelligence, allowing it to verify that tables, columns, and data types actually exist. It performs static analysis on procedural functions to det

Falcon este un client SQL și manager de baze de date cross-platform care oferă o interfață unificată pentru executarea interogărilor pe mai multe sisteme de baze de date. Funcționează ca o aplicație desktop pentru Windows și Mac, permițând utilizatorilor să gestioneze date din medii diverse printr-un singur editor de interogări. Instrumentul operează ca un studio de date sincronizat în cloud, făcând legătura între rezultatele bazelor de date locale și stocarea în cloud. Acest lucru permite transferul datelor procesate către un mediu cloud pentru stocare persistentă și analiză colaborativă. Dincolo de executarea interogărilor, aplicația include un utilitar de vizualizare care convertește rezultatele SQL în grafice interactive pentru analiza datelor. Aceste capabilități sunt susținute de un sistem de conectivitate bazat pe drivere și un mecanism de caching pe partea de client pentru gestionarea seturilor de rezultate.

Davinci este o platformă de business intelligence și vizualizare a datelor utilizată pentru construirea de dashboard-uri și rapoarte interactive. Funcționează ca un constructor de dashboard-uri bazat pe SQL și un serviciu de analiză multi-tenant care se conectează la baze de date prin JDBC și fișiere CSV pentru a transforma datele brute în componente vizuale. Platforma se distinge prin modelul său granular de securitate, care include permisiuni la nivel de rând și coloană integrate cu autentificarea LDAP și OAuth2. Oferă, de asemenea, un instrument de vizualizare încorporat care permite inserarea diagramelor și dashboard-urilor securizate și parametrizate în aplicații externe prin URL-uri și frame-uri. Sistemul acoperă o gamă largă de capabilități, inclusiv modelarea datelor cu șabloane SQL, un motor de layout drag-and-drop pentru dashboard-uri responsive și o mare varietate de tipuri de vizualizare, cum ar fi diagrame Sankey, diagrame radar și hărți geografice. Include, de asemenea, automatizare pentru programarea rapoartelor prin e-mail și utilizează caching-ul cheie-valoare pentru a optimiza performanța interogărilor.