sql-query-optimizer

Sql Query Optimizer - Auto-activating skill for Data Analytics. Triggers on: sql query optimizer, sql query optimizer Part of the Data Analytics skill category.

1.05x

Quality

Does it follow best practices?

Impact

91%

1.05x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./planned-skills/generated/12-data-analytics/sql-query-optimizer/SKILL.md

Evaluation results

84%

Customer Order Analytics Slowdown

Step-by-step SQL optimization guidance

Criteria

Without context

With context

Numbered steps present

83%

Step reasoning provided

100%

75%

Optimized query is complete

100%

No SELECT *

Index recommendations

100%

Avoids correlated subqueries

100%

Query formatting

100%

Before/after comparison

50%

100%

Performance impact explained

100%

Production considerations noted

91%

75%

92%

12%

Sales Attribution Report Performance Crisis

Industry best practices and validation

Criteria

Without context

With context

Uses CTEs or derived tables

100%

Explicit JOIN conditions

100%

Index recommendations included

100%

Avoids functions on indexed columns

100%

Partition or filter pushdown noted

100%

Validation explanation

100%

EXPLAIN or execution plan reference

100%

Correct aggregation scope

100%

No SELECT *

100%

Proper NULL handling

20%

97%

Legacy Inventory Reporting Overhaul

Production-ready optimized SQL output

Criteria

Without context

With context

Optimized query is runnable

91%

100%

SQL keywords capitalized

100%

Index statements are complete

100%

Comments in SQL

100%

Replaces SELECT *

100%

Step-by-step breakdown

100%

Identifies at least 3 issues

100%

Uses JOINs not subqueries for lookups

100%

Validation checklist included

100%

Backward compatibility noted

50%

70%

Repository: jeremylongshore/claude-code-plugins-plus-skills
Commit: 933cf26

Evaluated: about 1 month ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Customer Order Analytics Slowdown Sales Attribution Report Performance Crisis Legacy Inventory Reporting Overhaul

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.