Optimizes SQL queries, designs database schemas, and troubleshoots performance issues. Use when a user asks why their query is slow, needs help writing complex joins or aggregations, mentions database performance issues, or wants to design or migrate a schema. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis, covering index creation, recursive queries, EXPLAIN/ANALYZE interpretation, before/after query benchmarking, or migrating queries between databas
Install
KitScout test notes
Not tested by KitScout yet. When our harness runs it, pros, cons and the tasks we tried appear here, with the date and evidence.
Similar tools
fix-slow-queries113,555 ★ Diagnose and fix slow Paperclip PostgreSQL queries using Cloud and Neon evidence, local reproduction, performa
html-ppt-zhangzara-long-table107,474 ★ OpenDesign's unit-economics and BYOK cost model: the assumptions, the sensitivity, and why it scales. Built as
data-scientist70,891 ★ Processes and analyzes data with resident-kernel engines (DuckDB, Polars) and one-shot tools. Use for CSV/parq
data-quality-frameworks49,642 ★ Implement data quality validation with Great Expectations, dbt tests, and data contracts. Use when building da
database-architect49,642 ★ Expert database architect specializing in data layer design from scratch, technology selection, schema modelin