Awesome GitHub RepositoriesSQL Query Optimizations

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

Matrix is a suite of mobile application performance management and analysis tools. It provides a plugin-based monitoring system for capturing crashes, lags, and memory leaks, alongside a static binary auditor for reducing installation package size and a bytecode instrumentation tool for performance tracking. The project distinguishes itself through native memory debugging and a SQLite query linter that identifies inefficient database patterns. It employs native interception techniques to detect memory leaks and heap corruption without requiring source code recompilation, and uses a custom run

sqlglot is a SQL parser and transpiler that represents queries as abstract syntax trees to enable structural analysis, modification, and semantic transformation. It functions as a dialect translator and query optimizer, converting SQL code between different database engines and simplifying syntax trees through rule-based normalization. The project provides a framework for defining custom SQL dialects by overriding tokenizers, parsers, and generators. It includes a lineage analyzer to track data flow from source tables through complex queries to identify the origin of specific columns. Additi

Yearning is a MySQL SQL audit platform and database change management system. It provides a governance framework for reviewing, approving, and auditing SQL statements executed against MySQL databases. The platform features an AI-powered SQL optimizer that suggests performance improvements and converts natural language requests into executable SQL code. It manages database changes through an approval-based workflow engine that includes automated rollback generation and rule-based syntax validation. The system covers role-based access control, security compliance with multi-factor authenticati

Soar is a suite of specialized tools designed for analyzing MySQL performance, advising on indexing, and optimizing SQL syntax. It functions as a performance analyzer, index advisor, and query optimizer to identify bottlenecks and suggest structural improvements for faster execution. The project distinguishes itself through a system for rewriting SQL statements into optimized equivalent versions using custom heuristic rules and patterns. It also features a dedicated index advisor that evaluates query patterns and database metadata to recommend the creation of new indexes. Its broader capabil

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

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

Apache Hive is a SQL-on-Hadoop data warehouse that enables querying and managing petabytes of data stored in distributed storage such as HDFS and cloud storage services. It provides a familiar SQL interface for batch analytics and reporting, supported by a core set of components including the HiveServer2 Thrift service for remote query execution, the Hive Metastore Service for central metadata management, the Hive ACID Transaction Engine for concurrent read-write operations, and the Hive LLAP Interactive Engine for low-latency analytical processing. The WebHCat REST API offers an HTTP interfac

Ignite هي منصة موزعة للبيانات والحوسبة في الذاكرة. تعمل كقاعدة بيانات SQL موزعة ومحرك تخزين مصمم لتخزين ومعالجة مجموعات البيانات الكبيرة في RAM لتقليل التأخير وزيادة سرعة الحساب. يتميز النظام بمحرك تخزين متعدد المستويات يدير وضع البيانات عبر الذاكرة والقرص لموازنة الوصول عالي السرعة مع السعة الكبيرة. يتميز بشبكة حوسبة موزعة تنفذ منطقاً مخصصاً مباشرة على العقد التي توجد فيها البيانات لتقليل حركة مرور الشبكة. توفر المنصة مجموعة واسعة من القدرات بما في ذلك إدارة معاملات ACID، واستعلام SQL القياسي، وعمليات القيمة المفتاحية. تدعم استيعاب البيانات بكميات كبيرة عبر التدفقات التفاعلية وتوفر دمجاً عبر لغات برمجة متعددة، وبرامج تشغيل قواعد بيانات قياسية، وواجهة برمجة تطبيقات REST. يمكن نشر النظام كمجموعة موزعة باستخدام حاويات أو تنسيقه عبر Kubernetes. تمت كتابة المشروع بلغة Java ويمكن تثبيته عبر أرشيفات ثنائية.

MiniOB is an open-source educational relational database kernel designed for learning the internals of database systems. It implements a dual-engine storage architecture combining B+ Tree and LSM-Tree, supports SQL parsing and query execution, and provides transactional processing with multi-version concurrency control. The system communicates with clients using the MySQL wire protocol and includes a vector database extension for storing and querying high-dimensional vectors. The project distinguishes itself through its comprehensive coverage of core database concepts in a single, learnable c

Jailer is a suite of specialized tools for AI-assisted SQL management, referential integrity preservation, and relational data browsing. It provides a system for generating referentially intact database subsets, allowing users to extract consistent slices of relational data while preserving foreign key constraints and dependencies. The project features an AI-driven SQL assistant that uses natural language to generate, optimize, and refactor queries based on database schemas. It also includes a data migration tool that analyzes SQL patterns to reverse engineer models and map associations betwe