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

Test Automation Framework (TAF)

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

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.

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.

AI-Powered SQL Intelligence & Optimization Console that predicts query execution efficiency and ranks formulations using a Neural Network.

Fast and minimalist interface for analyzing MySQL/MariaDB slow logs

PostgreSQL health and performance advisor for Laravel. Detect bloat, vacuum debt, and slow queries with an interactive dashboard, automated CI gate, and optional Filament panel.

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

SQL performance optimizer and execution plan visualizer built with Nuxt 3. Audit, refactor, and speed up database queries offline or with Gemini & OpenAI.

Stop bad PostgreSQL indexes before they reach production.

Adaptive hot-key cache layer for Redis and Valkey — observe first, self-hosted, bounded.

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.

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

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

AI-powered database migration risk analyzer. Auto-detects schema breaking changes, estimates query lock times, validates downtime risks, and generates safe migration rewrite plans.

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