Help us improve
Share bugs, ideas, or general feedback.
From postgres
Analyze slow queries and suggest optimizations including missing indexes and query rewrites. Use when investigating query performance, high CPU usage, or slow response times.
npx claudepluginhub abiswas97/bonboncinnabon --plugin postgresHow this skill is triggered — by the user, by Claude, or both
Slash command
/postgres:slow-query-analysisThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Workflow:
Analyzes slow queries in PostgreSQL, MySQL, MongoDB using EXPLAIN plans, buffer stats, index usage to detect sequential scans, missing indexes, and recommend optimizations.
Optimizes slow database queries by analyzing execution plans, suggesting indexes, and rewriting SQL. Useful for slow query, optimize SQL, query performance, or explain query issues.
Optimizes slow SQL queries in PostgreSQL and MySQL using EXPLAIN ANALYZE to identify bottlenecks like full scans, inefficient joins, N+1 issues; suggests indexes and rewrites.
Share bugs, ideas, or general feedback.
Workflow:
If pg_stat_statements is not installed, guide setup: