Battle-tested SQL Server performance diagnostic toolkit for developers and DBAs. Quickly detect blocking, missing indexes and slow queries.
🌍 Translate DBI for Nintendo Switch into English, enabling broader accessibility while maintaining the original functionality of this homebrew application.
Fast and minimalist interface for analyzing MySQL/MariaDB slow logs
Fails Spring Boot tests when Hibernate runs an N+1 query. Test-scoped starter, no annotations.
High-performance PHP + MySQL DataTables server-side example tested with 100,000 rows. Includes indexing strategies, deferred joins, cached COUNT(*), deep pagination optimization, search optimization, PDO and measurable performance benchmarks.
This repository contains my answers to theoretical SQL questions, covering key database concepts, query optimization, indexing, normalization, and more. The goal is to reinforce SQL fundamentals and best practices for efficient data management.
SQL Server diagnostic and DBA scripts for performance tuning, query troubleshooting, indexing, database health, integrity, and maintenance.
Lattice is a JSON document store with real-time schema processing, indexing during ingestion, and a SQL-like interface for querying data
A high-performance attendance database system simulating 100,000+ records. Features a normalized schema, Python data seeding, and a showcase of Query Optimization using Composite Indexes to reduce lookup time by 99%.
MCP server that detects Hibernate/JPA N+1 queries, slow queries and SQL anti-patterns in Spring Boot apps — and points to the exact line of Java code causing them. Works with Claude Code & Claude Desktop. Fixes included.
Comparing query performance with and without Resource Governor, and analyzing the results.
SQL Query Auditor & Optimizer -- analyze SQL for performance, security, and best practices
Desktop SQL performance analyzer built with Java Swing, JDBC, and MySQL featuring a modular 15-rule engine, MySQL EXPLAIN analysis, index recommendations, query rewrites, query history, and CSV export.
Diagnose PostGIS performance problems from a PostgreSQL EXPLAIN plan. Parses JSON and text EXPLAIN (ANALYZE, BUFFERS) output, runs ten spatial rules — missing GiST index, ST_Distance instead of ST_DWithin, loose bounding-box rechecks, un-indexed KNN, SRID transforms defeating the index — and prints an annotated tree, JSON or Markdown.
A full-stack financial collections dashboard featuring SARGable SQL performance optimization, .NET 9 Minimal APIs, and React 19 Optimistic UI patterns.
Settle — a database-depth learning project disguised as a fintech ledger. Schema-from-invariants on MySQL/InnoDB; AI is configured to grill the design, never write it.
To associate your repository with the sql-performance topic, visit your repo's landing page and select "manage topics."