sql-performance

Parses execution plan nodes to detect full table scans, Cartesian cross joins, and suggests optimal composite indexes with cost estimation | GenPark: https://www.genpark.ai | LinkedIn: https://www.llinkedin.com/company/92955550

Parses execution plan nodes to detect full table scans, Cartesian cross joins, and suggests optimal composite indexes with cost estimation | GenPark: https://www.genpark.ai | LinkedIn: https://www.llinkedin.com/company/92955550

Battle-tested SQL Server performance diagnostic toolkit for developers and DBAs. Quickly detect blocking, missing indexes and slow queries.

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.

Fails Spring Boot tests when Hibernate runs an N+1 query. Test-scoped starter, no annotations.

Fast and minimalist interface for analyzing MySQL/MariaDB slow logs

🌍 Translate DBI for Nintendo Switch into English, enabling broader accessibility while maintaining the original functionality of this homebrew application.

Lattice is a JSON document store with real-time schema processing, indexing during ingestion, and a SQL-like interface for querying data

SQL Server diagnostic and DBA scripts for performance tuning, query troubleshooting, indexing, database health, integrity, and maintenance.

Top SQL Performance Monitoring (Opensource) 🌟 Star if you like it! 🌟

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.

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.

SQL Query Auditor & Optimizer -- analyze SQL for performance, security, and best practices

Comparing query performance with and without Resource Governor, and analyzing the results.

A full-stack financial collections dashboard featuring SARGable SQL performance optimization, .NET 9 Minimal APIs, and React 19 Optimistic UI patterns.

Claude Code plugin marketplace: 24 skills for engineering, SQL, performance, refactoring, security, Playwright and work comms.

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.

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.

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.