Querying, data manipulation, performance optimization, and AWS-specific SQL
Fast C extension for grouping consecutive monotonic sequences into ranges. O(n), works with any Comparable+succ type. Useful for compacting large IN() clauses in SQL.
Documentation-as-Code knowledge base for Platform Engineering: Linux systems, backend development (Java/Python/SQL), infrastructure (Docker/CI-CD), and LTS-safe operations runbooks.
🐬 MySQL 8.0 生产级架构设计、性能调优与并发锁治理 Agent Skill (表结构规约/覆盖索引/EXPLAIN调优/间隙锁死锁防范/大表热更)
Engineered advanced SQL solutions for analytical, hierarchical, and data engineering problems using SQL Server.
Reduce multi-relation Doctrine queries to a single SQL statement using JSON aggregation. Solves Doctrine's N+1 problem.
SQL performance optimizer and execution plan visualizer built with Nuxt 3. Audit, refactor, and speed up database queries offline or with Gemini & OpenAI.
A security and performance inspector for Django & DRF. Features static analysis, config checks, N+1 query detection, and SARIF support for GitHub Code Scanning.
An ML-powered middleware that intercepts slow SQL queries, uses regression models to predict execution times, and leverages a fine-tuned LLM to automatically rewrite inefficient code. Features Redis caching, connection pooling, and database replication for peak backend performance.
Personal portfolio showcasing end-to-end projects in Backend Development, Big Data Pipelines, and BI. Focused on Python, PySpark, Node.js, and SQL optimization.
An enterprise-grade, multi-vendor e-commerce platform built with Django & DRF. Features dual JWT/Session auth, an asynchronous cart API, Khalti payment integration, and highly optimized SQL queries (zero N+1 issues).
Real-world SQL query optimization case studies with before/after performance metrics and best practices
Developer-first CLI for SQL database analysis, query performance, schema comparison, data diagnostics, and AI-powered recommendations.
Full-stack data analytics platform built with Python, Streamlit, and MySQL, integrating 2M+ Chicago open-data records with relational database design, ETL pipelines, geospatial analytics, and interactive SQL-driven dashboards.
19 production-ready PostgreSQL queries solving real e-commerce analytics challenges. Advanced SQL techniques: CTEs, window functions, complex joins & stored procedures.
This repository contains solutions to the first 50 SQL problems on LeetCode. Each problem is solved using SQL queries, with detailed explanations and efficient approaches. These solutions aim to help users improve their SQL skills and understanding of database concepts while providing clear and well-documented code for reference.
This repository contains database schema designs that follow industry best practices. The schemas are designed with scalability, modularity, and maintainability in mind, and they are freely available for developers to use, study, and improve upon.
This SQL Lab serves as a technical archive focused on solving complex business logic through advanced SQL queries and to master SQL concepts by tackling LeetCode challenges and translating them into real-world data scenarios. The lab features hands-on, optimized solutions that strengthen analytical thinking and practical problem-solving
Postgres + Docker SQL analytics lab with data quality checks, performance EXPLAIN notes, and CI.
To associate your repository with the sql-optimization topic, visit your repo's landing page and select "manage topics."