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.

An Agentic PostgreSQL DBA— monitors, analyzes, and optimizes any PostgreSQL 14-18 database with LLM-powered actions

🔄 PostgreSQL MCP Server – AI-Powered PostgreSQL Management & Monitoring. A powerful, AI-integrated PostgreSQL Model Context Protocol (MCP) server for automated database operations, monitoring, security, diagnostics, and optimization. Seamlessly manage PostgreSQL with 237+ tools designed for AI assistants like Claude and ChatGPT.

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

SQLite write benchmarks proving the ORM is the bottleneck — 11 configs × 10M rows + ORM vs raw executemany at 50M scale. 23.8x speedup, 26% config spread, zero errors.

Compact SQL Server Showplan XML into token-efficient Markdown or JSON for AI coding agents.

Fast and minimalist interface for analyzing MySQL/MariaDB slow logs

PostgreSQL query performance analyzer CLI (Java/Spring Boot): detects slow queries, parses EXPLAIN plans, and recommends indexes.

Source for andreploeger.com — freelance website focused on PostgreSQL performance, query analysis, and predictable system behavior.

Supabase Debug Playground — a hands-on lab for diagnosing and fixing common Supabase issues (Auth, RLS, Realtime, RPC, and indexing) with reproducible debugging patterns and examples.

A professional SQL project demonstrating how to optimize query performance using single and composite database indexes, and analyzing query execution plans using the EXPLAIN statement.

20 Hands-on Linux performance tuning labs across physical, virtual, and cloud environments covering observability, bottleneck analysis, kernel tuning, and optimization.

Slow query interceptor and index advisor for Mongoose 8+. Automatically runs explain() on slow queries, detects COLLSCAN/SORT stages, and suggests optimal indexes following the ESR rule - zero runtime dependencies

Terminal-precision static analysis tool that catches database performance bugs (N+1 queries, missing indexes) in AI-generated Prisma & PostgreSQL code before production.

Transparent Redis caching for raw MySQL connections. No ORM required

A curated collection of MySQL scripts covering DDL, DML, and DRL operations. Ideal for beginners to practice and understand core SQL concepts.

Scalable backend API demonstrating cursor-based pagination, category filtering, and consistent browsing across 200,000+ products.

Laboratório interativo em Python para comparar performance e padrões arquiteturais de bancos SQL, NoSQL, Grafos, Chave-Valor e Séries Temporais.

Read-only CLI that ranks, explains, and reports slow PostgreSQL queries from pg_stat_statements.