A physical design advisor for DuckDB

💻🛠 Database Tuning, Optimization & performance analysis.

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.

This is a case study on implementing StackOverflow main features as an REST API

OsmosisDB is a high‑performance, transparent Layer 4 sidecar database proxy and automated DBA agent system. It observes your application’s SQL traffic, semantically groups workloads using vector embeddings, detects access pattern drift, and safely applies schema optimisations (indexes) – all without human intervention.

Laboratório de Implementacao de Banco de Dados: Implementação de índices e manipulação de objetos JSON para otimização de performance no SQL Server.

Universal Database Optimization using Reinforcement Learning

Real-world SQL query optimization case studies with before/after performance metrics and best practices

Collaborated with Guoliang Li, Jiesi Liu, and Jianming Wu

Open source project for performing various AWS RDS (Relational Database Service) tasks.

A customized and efficient database tuning system [VLDB'22]

[Libro Query Boost] 500만 건 도서 데이터의 조회 성능을 10s → 0.6s로 단축시킨 쿼리 튜닝 및 No-Offset 페이징 최적화 프로젝트.

A tool automatically improving the performance of large-scale systems by finding better configuration settings

PostgreSQL & Linux Kernel Health Checker

Various DB Scripts used for Administration and Automation