AI Agent Skill HUB

sql-optimization-patterns

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

30 stars
byZidong-IA
View on GitHubInstallation ↓

Best use case

sql-optimization-patterns is best used when you need a repeatable AI agent workflow instead of a one-off prompt.

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

Teams using sql-optimization-patterns should expect a more consistent output, faster repeated execution, less prompt rewriting.

When to use this skill

  • You want a reusable workflow that can be run more than once with consistent structure.

When not to use this skill

  • You only need a quick one-off answer and do not need a reusable workflow.
  • You cannot install or maintain the underlying files, dependencies, or repository context.

Installation

Claude Code / Cursor / Codex

$curl -o ~/.claude/skills/sql-optimization-patterns/SKILL.md --create-dirs "https://raw.githubusercontent.com/Zidong-IA/BIBLIOTECA/main/skills/skills/databases/sql-optimization-patterns/SKILL.md"

Manual Installation

  1. Download SKILL.md from GitHub
  2. Place it in .claude/skills/sql-optimization-patterns/SKILL.md inside your project
  3. Restart your AI agent — it will auto-discover the skill

How sql-optimization-patterns Compares

Feature / Agentsql-optimization-patternsStandard Approach
Platform SupportNot specifiedLimited / Varies
Context Awareness High Baseline
Installation ComplexityUnknownN/A

Frequently Asked Questions

What does this skill do?

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

Where can I find the source code?

You can find the source code on GitHub using the link provided at the top of the page.

SKILL.md Source

# 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.
- If detailed examples are required, open `resources/implementation-playbook.md`.

## Resources

- `resources/implementation-playbook.md` for detailed patterns and examples.

Related Skills

web-performance-optimization

30
from Zidong-IA/BIBLIOTECA

Optimize website and web application performance including loading speed, Core Web Vitals, bundle size, caching strategies, and runtime performance

tailwind-patterns

30
from Zidong-IA/BIBLIOTECA

Tailwind CSS v4 principles. CSS-first configuration, container queries, modern patterns, design token architecture.

react-ui-patterns

30
from Zidong-IA/BIBLIOTECA

Modern React UI patterns for loading states, error handling, and data fetching. Use when building UI components, handling async data, or managing UI states.

react-patterns

30
from Zidong-IA/BIBLIOTECA

Modern React patterns and principles. Hooks, composition, performance, TypeScript best practices.

nextjs-app-router-patterns

30
from Zidong-IA/BIBLIOTECA

Master Next.js 14+ App Router with Server Components, streaming, parallel routes, and advanced data fetching. Use when building Next.js applications, implementing SSR/SSG, or optimizing React Serve...

hig-patterns

30
from Zidong-IA/BIBLIOTECA

Apple Human Interface Guidelines interaction and UX patterns.

angular-ui-patterns

30
from Zidong-IA/BIBLIOTECA

Modern Angular UI patterns for loading states, error handling, and data display. Use when building UI components, handling async data, or managing component states.

nodejs-backend-patterns

30
from Zidong-IA/BIBLIOTECA

Build production-ready Node.js backend services with Express/Fastify, implementing middleware patterns, error handling, authentication, database integration, and API design best practices. Use when...

error-handling-patterns

30
from Zidong-IA/BIBLIOTECA

Master error handling patterns across languages including exceptions, Result types, error propagation, and graceful degradation to build resilient applications. Use when implementing error handling...

dotnet-backend-patterns

30
from Zidong-IA/BIBLIOTECA

Master C#/.NET backend development patterns for building robust APIs, MCP servers, and enterprise applications. Covers async/await, dependency injection, Entity Framework Core, Dapper, configuratio...

async-python-patterns

30
from Zidong-IA/BIBLIOTECA

Master Python asyncio, concurrent programming, and async/await patterns for high-performance applications. Use when building async APIs, concurrent systems, or I/O-bound applications requiring non-...

api-patterns

30
from Zidong-IA/BIBLIOTECA

API design principles and decision-making. REST vs GraphQL vs tRPC selection, response formats, versioning, pagination.