Stats
Actions
Tags
Help us improve
Share bugs, ideas, or general feedback.
From faos-data-engineer
<!-- AUTO-GENERATED by export-plugins.py — DO NOT EDIT -->
npx claudepluginhub frank-luongt/faos-skills-marketplace --plugin faos-data-engineerHow this command is triggered — by the user, by Claude, or both
Slash command
/faos-data-engineer:optimize-queryThe summary Claude sees in its command listing — used to decide when to auto-load this command
<!-- AUTO-GENERATED by export-plugins.py — DO NOT EDIT --> --- description: "Analyze and optimize SQL query performance" --- # Optimize Query Analyze and optimize SQL query performance
/optimize-queryAnalyzes SQL query performance with EXPLAIN ANALYZE, suggests indexes and rewrites, and outputs optimized query with before/after execution plan comparisons.
/optimize-queryAnalyzes SQL queries for performance issues like inefficient JOINs and subqueries, provides rewritten optimized versions, index recommendations, expected improvements, and testing strategies.
/optimize-queriesAnalyze slow queries, identify missing indexes, and rewrite queries for performance.
/analyze-queryAnalyzes SQL queries for performance issues using EXPLAIN ANALYZE, identifies patterns and locks, suggests optimizations, and estimates improvements in a structured report.
/queryOptimizes and analyzes queries across SQL databases, MongoDB, Redis, and ORMs: interprets EXPLAIN plans, recommends indexes, rewrites for performance, detects N+1 issues, profiles slow queries. Supports flags like --explain, --indexes, --n-plus-one.
/optimizeOptimizes database performance: analyzes queries with EXPLAIN, detects N+1 and slow queries, suggests indexes and rewrites, applies fixes, and reports improvements.
Share bugs, ideas, or general feedback.
Analyze and optimize SQL query performance