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.

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

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

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.

Spring Boot demo comparing JPA lazy loading (N+1 problem) vs EntityGraph optimization. Shows performance difference between 11 queries vs 1 query for Books-Authors many-to-many relationship. Includes query counting, tests, and metrics.

Fast and minimalist interface for analyzing MySQL/MariaDB slow logs

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

Real-world SQL query optimization case studies with before/after performance metrics and best practices

Analyze SQL Server execution plans across platforms with automated insights, missing index suggestions, and a built-in AI-assisted MCP server.

Distributed data processing and NoSQL benchmarking project developed with Hadoop HDFS, MapReduce, MongoDB, and YCSB, featuring dataset ingestion, distributed storage, revenue aggregation by state, NoSQL querying, and database performance benchmarking for the Data Storage Solutions CA1 module at CCT College.