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.

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

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

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

Using NExT JS

npm query parser and tools

DBMS core notes - single page, at-a-glance revision for SQL, normalization, transactions, indexing, and database internals

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

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

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

Learnify is an interactive educational platform designed to promote knowledge sharing through video tutorials and articles. It encourages students to contribute by curating content, creating a collaborative space for peer learning. Built with modern tools, it features advanced authentication, content management, and user engage

Web app for querying, analyzing, and visualizing large sports data using AWS, SQL/NoSQL design, and query optimization.

This tool is for connecting, analyzing the postgresql database

MongoDB-based fleet telemetry platform for IoT data modeling, schema design, indexing, consistency propagation, and analytics across vehicle telemetry, maintenance history, and route activity.

MongoDB-based analytics engine for processing and querying large-scale tweet data, enabling efficient data exploration and insight generation.

Collection of MongoDB queries for a blog API including CRUD operations, aggregations, and data analysis.