Skill

SQL Optimization Patterns

npx claudepluginhub frank-luongt/faos-skills-marketplace --plugin faos-data-engineer

Popularity

Parent stars

Parent forks

Invocation

How this skill is triggered — by the user, by Claude, or both

Slash command

/faos-data-engineer:sql-optimization-patterns

User invocable

Model invocable

Inline context

Default effort

Context Preview

The summary Claude sees in its skill listing — used to decide when to auto-load this skill

SKILL.md

38 lines · ~319 tokens

Similar Skills

sql-optimization-patterns

40.4k

Transforms slow database queries into fast operations through systematic optimization, proper indexing, and query plan analysis. Activates when debugging slow queries, designing schemas, or resolving N+1 problems.

1 file

antigravity-awesome-skills

sql-optimization-patterns

Masters SQL query optimization, indexing strategies, and EXPLAIN analysis to eliminate slow queries. Use when debugging slow queries, designing schemas, or improving database performance.

superpowers

sql-pro

9.3k

Optimizes 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.

5 files

fullstack-dev-skills

Stats

LanguageTeX

Parent stars18

Parent forks8

MaintenanceGood

Last CommitApr 7, 2026

Actions

View Source View Plugin View on GitHub View README

Help us improve

Share bugs, ideas, or general feedback.

Stats

Actions

Help us improve

Share bugs, ideas, or general feedback.

SQL Optimization Patterns

Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.

Use this skill when

Debugging slow-running queries

Designing performant database schemas

Optimizing application response times

Reducing database load and costs

Improving scalability for growing datasets

Analyzing EXPLAIN query plans

Implementing efficient indexes

Resolving N+1 query problems

Do not use this skill when

The task is unrelated to sql optimization patterns

You need a different domain or tool outside this scope

Instructions

Clarify goals, constraints, and required inputs.

Apply relevant best practices and validate outcomes.

Provide actionable steps and verification.

Resources

name: sql-optimization-patterns description: Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance. tags: [data-engineering, sql]