query-optimization

Run the PostgreSQL Explain Visualizer 2 (pev2) from the command line.

twitcher

Using PostgresSQL to store and fetch data, tune queries, and design efficient database structures!

💻🛠 Database Tuning, Optimization & performance analysis.

Paste a query log, see the N+1 patterns, get the batched fix. Zero-dependency browser tool.

Progressive SQL learning repo — portable, SQLite-runnable query drills building toward a capstone project (SQL Warehouse Analytics Engine): joins, CTEs, window functions, views.

MySQL 智能查询优化与索引推荐助手，支持多表 DDL 解析、索引推荐、SQL 重写、Explain 模拟、模型验证与统一管理控制台。

PostgreSQL-powered SQL quality analyzer that detects anti‑patterns, suggests safe rewrites, and scores queries.

Automatically analyzes RAG pipeline retrieval results and generates optimized query refinement suggestions to improve answer relevance.

Personal Website using an Intelligent and Hybrid Chat and Voice Bot catered specifically for my resume and professional work.

Database Performance Observatory — Analyze SQL query execution across MySQL & PostgreSQL side-by-side. Visualize EXPLAIN plans, get index recommendations, track query performance over time. Built with Node.js, MongoDB, Redis, and CodeMirror.

One MCP server for every SQL Server you administer — grouped connections, execution plans, index audits, stored-procedure analysis

Using NExT JS

npm query parser and tools

Practical React notes for DBMS fundamentals, SQL, normalization, transactions, indexing, and query optimization.

This tool is for connecting, analyzing the postgresql database

Production-grade guides and runbooks for query plan baseline tracking, performance regression detection, and CI/CD gate automation — for database SREs and platform teams.

Eight realistic PostgreSQL performance problems, the fix for each, and harness-generated EXPLAIN ANALYZE evidence that the fix worked.

Production-grade benchmark comparing PostgreSQL scheduler patterns: 845ms → 3ms using partial indexes, advisory locks, and SKIP LOCKED. 500k URL simulation with real production patterns.

A GraphQL API demonstrating the N+1 query problem and its resolution using DataLoader — with side-by-side resolver comparisons and per-request batching.