CLI advisor for ClickHouse query optimization. Formally verified rewrite rules + RAG + MCP server.
-
Updated
Jun 25, 2026 - Python
CLI advisor for ClickHouse query optimization. Formally verified rewrite rules + RAG + MCP server.
Optimize Laravel queries using SQL JSON aggregation - reduce multiple relation queries to a single SQL statement
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 end-to-end business analytics SQL portfolio built on a custom e-commerce database — designed to answer real business questions about customers, revenue, retention, and product performance using advanced SQL techniques.
Reduce multi-relation Doctrine queries to a single SQL statement using JSON aggregation. Solves Doctrine's N+1 problem.
Database Reliability Engineering platform for HA/DR, 100TB+ migrations, performance guardrails, and self-healing data systems.
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.
A curated knowledge base and second brain for MySQL architecture, query optimization, and database administration. Structured for deep learning via Obsidian.
Manage SQL range binning via configuration tables instead of repetitive CASE WHEN statements.
Documentation-as-Code knowledge base for Platform Engineering: Linux systems, backend development (Java/Python/SQL), infrastructure (Docker/CI-CD), and LTS-safe operations runbooks.
🗄️ IBM Relational Database Administrator with GenAI Certificate Portfolio – A comprehensive collection of projects, labs, and assignments showcasing expertise in relational database administration, 🏘️data warehousing, 🔁ETL pipelines, and 🤖Generative AI integration for modern database management.
19 production-ready PostgreSQL queries solving real e-commerce analytics challenges. Advanced SQL techniques: CTEs, window functions, complex joins & stored procedures.
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).
Personal portfolio showcasing end-to-end projects in Backend Development, Big Data Pipelines, and BI. Focused on Python, PySpark, Node.js, and SQL optimization.
Scalable ETL pipeline and PostgreSQL optimization for 40M+ records. Features memory-efficient Python preprocessing and B-Tree indexing for a 95% reduction in query latency.
Sistema web para mineração e consulta de slow_logs do MySQL.
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.
Querying, data manipulation, performance optimization, and AWS-specific SQL
Interactive Data Analytics Dashboard for German Crime Victim Statistics (2023-2024). High-performance visualization of 430k+ records using PHP, MySQL, and Chart.js.
Add a description, image, and links to the sql-optimization topic page so that developers can more easily learn about it.
To associate your repository with the sql-optimization topic, visit your repo's landing page and select "manage topics."