6 रिपॉजिटरी
Awesome GitHub RepositoriesSQL Performance Analysis
Tools for analyzing executed SQL statements and processing times to identify bottlenecks.
Distinct from SQL Query Execution Engines: Candidates focus on query builders or execution engines, not the analysis of execution time for optimization.
Explore 6 awesome GitHub repositories matching data & databases · SQL Performance Analysis. Refine with filters or upvote what's useful.
Awesome SQL Performance Analysis GitHub Repositories
AI के साथ बेहतरीन रिपॉजिटरी खोजें।हम AI का उपयोग करके सबसे सटीक रिपॉजिटरी खोजेंगे।
- baomidou/mybatis-plus
baomidou/mybatis-plus
17,391GitHub पर देखें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
Analyzes executed SQL statements and processing times to identify and resolve slow database queries.
Javamybatismybatis-plusmybatis-spring - hhyo/archery
hhyo/Archery
6,929GitHub पर देखें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
Analyzes executed SQL statements and processing times to identify and resolve performance bottlenecks.
Pythonarcherybinlog2sqlclickhouse - meituan-dianping/sqladvisor
Meituan-Dianping/SQLAdvisor
5,619GitHub पर देखें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
Identifies the root causes of slow database responses to apply structural changes and reduce latency.
C - readysettech/readyset
readysettech/readyset
5,192GitHub पर देखें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
Provides a CLI to analyze and diagnose SQL workload performance before production deployment.
Rustbackendcachecaching - uptrace/bun
uptrace/bun
4,867GitHub पर देखेंBun, Go के लिए एक टाइप-सेफ ऑब्जेक्ट रिलेशनल मैपर है जो SQL-फर्स्ट क्वेरी निर्माण और परिणाम मैपिंग को प्राथमिकता देता है। यह एक प्रोग्रामेबल SQL क्वेरी बिल्डर, एक डेटाबेस कनेक्शन मैनेजर, और डेटाबेस टेबल्स को Go स्ट्रक्ट्स (structs) से मैप करने के लिए एक टूल के रूप में कार्य करता है। यह प्रोजेक्ट मल्टी-डायलेक्ट SQL सपोर्ट सिस्टम के माध्यम से खुद को अलग करता है, जिससे एक सिंगल कोडबेस को एक सुसंगत इंटरफेस के माध्यम से विभिन्न डेटाबेस इंजनों के साथ इंटरैक्ट करने की अनुमति मिलती है। इसमें क्वेरी इंटरसेप्शन, डिस्ट्रीब्यूटेड ट्रेसिंग और लॉगिंग के लिए एक इन-बिल्ट डेटाबेस ऑब्जर्वेबिलिटी टूल, साथ ही संरचनात्मक परिवर्तनों के वर्ज़निंग के लिए एक स्कीमा माइग्रेशन टूल शामिल है। यह लाइब्रेरी बल्क प्रोसेसिंग, अपसर्ट्स, सॉफ्ट डिलीट्स, और पॉलीमॉर्फिक एसोसिएशन जैसे रिलेशनल डेटा के मैनेजमेंट सहित डेटा ऑपरेशंस की एक विस्तृत श्रृंखला को कवर करती है। यह एटॉमिक ट्रांजेक्शन मैनेजमेंट और कनेक्शन पूलिंग के साथ-साथ कॉमन टेबल एक्सप्रेशंस और विंडो फंक्शन्स का उपयोग करके उन्नत SQL एनालिटिक्स के लिए क्षमताएं प्रदान करती है। स्कीमा मैनेजमेंट को वर्ज़न्ड माइग्रेशन स्क्रिप्ट्स को लागू करने के लिए एक कमांड-लाइन इंटरफेस के माध्यम से सपोर्ट किया जाता है।
Provides instrumentation and hooks to monitor query execution and identify performance bottlenecks in production.
Godatabasegogolang - graphql-python/graphene-django
graphql-python/graphene-django
4,390GitHub पर देखेंGraphene-Django is a GraphQL integration framework and schema mapper used to build typed APIs for Django applications. It functions as a database API layer that transforms Django model fields and relationships into a graph schema, allowing clients to request specific data in a single call. The project implements the Relay specification, providing tools for global object identification and standardized connection-based pagination to manage large datasets. It distinguishes itself by mapping database models, forms, and serializers directly into GraphQL object types and mutations. The framework
Analyzes database interaction by outputting executed SQL transactions within the API response for performance tuning.
Python
