query-performance

Free, open-source SQL Server and Postgres performance monitoring. Collectors, real-time alerts, graphical plan viewer, MCP server for AI analysis. Supports SQL 2016-2025, Azure SQL, AWS RDS, Postgres, Aurora Postgres.

Catch broken queries and performance regressions before production. SQL regression testing, EXPLAIN plan baselines, and CI/CD integration for PostgreSQL.

Free, open-source SQL Server execution plan analyzer — cross-platform GUI + CLI with 30 analysis rules, missing index detection, SSMS extension. Built-in MCP server for AI-assisted plan review.

EF Core LINQ performance analyzer and Roslyn analyzer for catching N+1 queries, client-side evaluation, sync-over-async, raw SQL risks, and other query issues at compile time.

Read PostgreSQL EXPLAIN plans for AI agents: bottlenecks, estimation errors, fixes, charts.

Slow database query detection for Node.js | Prisma-friendly roadmap; npm -> queryd

Top Database Monitoring 🌟 Star if you like it! 🌟

PostgreSQL query-plan regression gates for CI

Production-minded T-SQL diagnostics, operations, security, backup, HA, Azure SQL, Power BI, and Grafana toolkit.

WSQ Neo4j Professional Graph Database Course (TGS-2023036640) — 17 hands-on Cypher, graph modelling and Neo4j administration labs. Tertiary Infotech Academy.

Database performance engineering lab demonstrating 148x query optimization through advanced indexing strategies and ACID-compliant transaction patterns. Features production-ready implementations spanning both SQL and NoSQL paradigms with measured performance analytics. A practical showcase of database engineering principles.

Developer-first CLI for SQL database analysis, query performance, schema comparison, data diagnostics, and AI-powered recommendations.

Catch N+1 queries in your tests, before they hit production. ORM-agnostic query-count assertion for TypeScript.

CI gate for analytical SQL: captures DuckDB execution plans and runtime distributions for a whole query corpus, then fails the pull request when a query regresses and names the operator that changed. Rank test anchored to a measured noise floor, plus a sqlglot anti-pattern linter and Snowflake transpilation.

Engineering case study: taking a query on 11.2M NYC taxi trip rows in MySQL from a full table scan to a covering index + partition-pruned scan, proven with EXPLAIN ANALYZE

Analyzing the impact of composite index order on query performance using columns with different selectivity levels in SQL Server

This application manages restaurant reservations, optimizes table allocation (including table merging for larger groups), and handles customer reviews. It evaluates query performance for operations with varying database sizes (20, 1,000, and 5,000 records) both with and without indexing, providing insights into database optimization.

Show query performance directly at the method itself, leveraging CodeLens to get direct insights