From ai-analyst
Retrieves proven SQL patterns and reusable CTEs for database queries. Embedded in ask-question and run-analysis skills; do not invoke separately.
How this skill is triggered — by the user, by Claude, or both
Slash command
/ai-analyst:archaeologyThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
This skill's core functionality has been absorbed into **ask-question and run-analysis**.
This skill's core functionality has been absorbed into ask-question and run-analysis.
When ask-question and run-analysis triggers, it automatically handles what archaeology used to do.
Do not invoke this skill directly. Use ask-question and run-analysis instead.
npx claudepluginhub ai-analyst-lab/ai-analyst-plugin --plugin ai-analystOptimizes SQL queries, designs database schemas, and troubleshoots performance issues. Covers window functions, CTEs, indexing strategies, EXPLAIN ANALYZE interpretation, and query migration across PostgreSQL, MySQL, and SQL Server.
Optimizes SQL queries, designs schemas, and troubleshoots performance issues using window functions, CTEs, indexing, and EXPLAIN plan analysis. Supports PostgreSQL, MySQL, SQL Server, and Oracle.
Optimizes SQL queries using EXPLAIN analysis, indexing strategies, and patterns to eliminate slow queries and boost performance. For debugging queries, schema design, and app optimization.