Build software better, together

vanterx / mssql-performance-skills

SQL Server performance tuning skills for LLMs — 829 checks across 26 skills covering T-SQL, execution plans, wait stats, deadlocks, Query Store, indexes, encryption, Always On AG, WSFC, ERRORLOG, SPN, memory, disk I/O, config drift, setup logs, SSRS & migration readiness. Remote MCP server on Cloudflare Workers.

Updated Oct 29, 2026
TypeScript

Rmuk655 / Query-Optimization-and-Performance-Analysis

Star

PostgreSQL query optimization and performance analysis using indexing, execution plans, and cost-based evaluation techniques.

python benchmarking sql dbms postgresql indexing performance-analysis query-optimization database-systems execution-plans

Updated Oct 22, 2026
C

MarlonRibunal / sqlserver-demos

Star

Runnable SQL Server demos, one folder per problem: parameter sniffing, blocking, deadlocks, wait stats, the transaction log and more. Each demo checks its own predictions, and CI runs them on 2019, 2022 and 2025.

sql-server performance-tuning database-administration mssql dba query-optimization tsql t-sql execution-plans sql-server-2025

Updated Oct 28, 2026
TSQL

vishunt / sql-server-performance-lab

Star

SQL Server performance tuning lab demonstrating execution plan analysis, indexing strategies, and logical read optimization using a 500k-row dataset.

sql-server performance-tuning t-sql database-indexing execution-plans

Updated Mar 5, 2026
TSQL

Alexisvop / Oracle-Performance-Analyzer

Star

A reproducible Oracle Database performance engineering laboratory for SQL execution plans, indexing strategies, optimizer statistics, and evidence-driven benchmarking.

python portfolio benchmarking sql query-optimization oracle-database database-performance execution-plans

Updated Oct 24, 2026
Python

Rumman90 / database-performance-lab

Star

Compare how PostgreSQL, MySQL, SQL Server, and Oracle run the same database queries with and without indexes.

mysql docker sql sql-server postgresql indexing query-optimization database-perfomance oracle-database execution-plans

Updated Jun 21, 2026
TSQL

2vergent / querylab

Star

Analyze PostgreSQL queries, visualize execution plans, and improve performance.

postgresql query-optimization database-perfomance query-planner performance-tuning-slow-queries execution-plans

Updated Feb 21, 2026
JavaScript

Mansi-Katarmal / VayuAir-DataModeling

Star

Dimensional Data Warehouse for an airline OLTP system, using Star Schema, SCD Type 2, Snowflaked Geography, and date partitioning.

sql sql-server data-engineering partitioning data-modeling data-warehousing star-schema snowflake-schema scd-type-2 data-contracts execution-plans

Updated Aug 10, 2026
TSQL

thepocock / query_plan_optimization

Star

Query optimization case study demonstrating execution-plan analysis, query decomposition, materialization, and staged data processing to improve optimizer accuracy and performance.

sql data-engineering query-optimization cardinality-estimation database-performance materialization query-decomposition execution-plans

Updated Aug 16, 2026

rleenrwd / InnoStaff

Star

*IN DEVELOPMENT* Advanced SQL Server workforce intelligence project uncovering turnover patterns, quantifying replacement costs, and evaluating retention strategies through complex SQL, execution-plan analysis, measured query optimization, and an interactive Python dashboard.