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

performance sql-server database diagnostics dba tsql database-monitoring database-performance sql-performance dba-tools performance-diagnostics

• Updated Apr 18, 2026
• TSQL

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.

mysql pagination php performance big-data pdo datatables ajax rate-limiting query-optimization csrf-protection bootstrap5 database-indexing server-side-processing sql-performance

• Updated Sep 4, 2026
• PHP

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

testing spring-boot jpa spring-boot-starter hibernate spring-data-jpa sql-performance n-plus-one

• Updated Sep 6, 2026
• Java

Fast and minimalist interface for analyzing MySQL/MariaDB slow logs

mysql mariadb query-analysis database-tools slow-query-log database-performance sql-performance

• Updated May 6, 2026
• JavaScript

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

cross-platform version-control performance-tuning data-manipulation user-friendly data-migration patch-management data-recovery database-tools script-automation open-source-tool sql-injections sql-performance dbi-patcher backup-utilities

• Updated Oct 13, 2026
• Python

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

nosql rest-api document-database query-optimization document-store json-storage schema-inference dynamic-schema adaptive-indexing automatic-indexing restful-database flexible-schema sql-performance auto-schema heterogeneous-documents

• Updated Oct 3, 2026
• C#

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

awesome-list query-optimization curated-list postgresql-monitoring database-monitoring sql-performance dba-tools

• Updated Sep 9, 2026

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

sql sql-server database performance-tuning database-administration mssql dba query-optimization sqlserver tsql t-sql database-scripts sql-performance database-diagnostics

• Updated Sep 7, 2026
• C#

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 data-manipulation database-design sql-performance

• Updated Feb 9, 2025

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%.

mysql indexing performance-tuning query-optimization database-design python-scripting backend-development database-engineering sql-performance

• Updated Jul 23, 2026
• Jupyter Notebook

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.

java spring-boot jpa hibernate developer-tools claude n-plus-1 model-context-protocol mcp-server sql-performance model-context-protoco

• Updated Jul 6, 2026
• TypeScript

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

python sql static-analysis code-quality active-project sql-audit sql-linter sql-security sql-performance

• Updated Mar 29, 2026
• Python

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

typescript optimistic-ui vertical-slice-architecture dapper-orm react-19 dotnet-9 sql-performance

• Updated Jan 30, 2026
• TypeScript

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

sql-server performance-tuning memory-management cpu-management sql-performance latency-monitoring resource-governor database-stability workload-group

• Updated Dec 31, 2025
• TSQL

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

mcp python-standard-library database-optimization explain-plan cost-estimator index-advisor agent-skills sql-performance full-table-scan cartesian-join-detector query-plan-analyzer

• Updated Oct 30, 2026
• Python

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.

python cli postgresql gis postgis query-optimization spatial-database database-tools explain-plan sql-performance gist-index

• Updated Jul 19, 2026
• Python

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.

mysql java sql maven jdbc desktop-application java-swing query-optimizer sql-performance

• Updated Oct 23, 2026
• Java

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.

mysql go ledger innodb double-entry database-design learning-project sql-performance

• Updated Sep 25, 2026