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.

Java 17, Spring Boot 3, Oracle DB

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

Read-only T-SQL script that captures a performance and schema snapshot of a SQL Server database and exports an LLM-friendly Markdown tuning report.

Code that I used to test my Final Year Project

Optimization of weekly SQL queries for department-level reporting. Reduced execution time and eliminated dependency on multiple servers by centralizing query logic. Implemented parameterized T-SQL scripts and temporary tables to enhance performance and simplify maintenance.