Awesome GitHub RepositoriesSQL Performance Analysis

MyBatis-Plus is a persistence framework extension for Java that simplifies data access by reducing boilerplate code. It provides a toolkit for automating common database operations, utilizing dynamic query wrappers and a system for automated CRUD generation. The project distinguishes itself through a code generation system that produces mapper, model, service, and controller layers based on database metadata. It also implements a security layer that prevents SQL injection through input sanitization and blocks dangerous global update or delete operations to prevent accidental data loss. The f

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

SQLAdvisor is a database performance tuner and index recommendation tool designed to reduce query latency. It functions as a query optimizer that analyzes SQL execution patterns to identify missing indexes and provide actionable performance optimization advice. The system focuses on automated index management and database query tuning. It identifies the root causes of slow database responses and recommends the most effective indexes to improve data retrieval speeds. Its capabilities include analyzing SQL parse trees and join patterns, using cost-model and heuristic-based selections to priori

Readyset is a transparent caching proxy for PostgreSQL and MySQL that sits between an application and its database, intercepting SQL queries and serving cached results from memory. It automatically caches query results on first execution and keeps those caches consistent by consuming the database’s replication stream in real time, enabling faster repeated reads without application code changes. The proxy also supports caching advanced SQL functions such as window functions, bucket functions, and locale-aware collation sorting, and exposes an interface that allows AI agents to inspect proxied q

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

Graphene-Django 是一个 GraphQL 集成框架和模式映射器，用于为 Django 应用程序构建类型化 API。它作为一个数据库 API 层，将 Django 模型字段和关系转换为图模式，允许客户端在单次调用中请求特定数据。 该项目实现了 Relay 规范，提供用于全局对象标识和标准化基于连接的分页的工具，以管理大型数据集。它通过将数据库模型、表单和序列化器直接映射到 GraphQL 对象类型和变更（Mutations）中而脱颖而出。 该框架涵盖了广泛的能力，包括字段级访问控制、基于中间件的请求拦截以及通过 WebSocket 路由处理实时操作。它还包括用于 SQL 性能检查和变更事务包装的实用程序，以确保更新期间的数据完整性。 提供了一个专门的测试客户端来验证 API 响应并针对端点执行查询。