sql-optimization-patterns
๐ฏSkillfrom wshobson/agents
|A Claude Code skill providing SQL query optimization techniques, indexing strategies, and database performance patterns with progressive disclosure for on-demand knowledge loading.
Overview
SQL Optimization Patterns is a Claude Code skill from the wshobson/agents marketplace, a comprehensive system of 73 plugins, 112 agents, and 146 skills for development automation. This skill provides specialized knowledge about SQL query optimization techniques, indexing strategies, and database performance patterns. It uses the marketplace's progressive disclosure architecture to load optimization knowledge on demand.
Key Features
- Query Optimization Patterns: Covers SQL query rewriting, execution plan analysis, and common performance anti-patterns with their solutions
- Indexing Strategies: Guidance on index design, composite indexes, covering indexes, and when to use or avoid specific indexing approaches
- Progressive Disclosure: Three-tier knowledge loading (metadata, instructions, resources) ensures only relevant optimization knowledge enters the context when activated
- Database-Agnostic Guidance: Provides optimization patterns applicable across major database systems
- Composable: Works alongside database design, data engineering, and other database-related plugins in the marketplace for comprehensive data layer support
Who is this for?
This skill is designed for backend developers, database administrators, and data engineers who use Claude Code and need help optimizing SQL queries and database performance. It is especially valuable for those working on production database performance tuning, investigating slow queries, or designing efficient data access patterns.
Same repository
wshobson/agents(240 items)
Installation
npx vibeindex add wshobson/agents --skill sql-optimization-patternsnpx skills add wshobson/agents --skill sql-optimization-patterns~/.claude/skills/sql-optimization-patterns/SKILL.mdSKILL.md
More from this repository10
Comprehensive Claude Code plugin collection with 112 AI agents, 146 skills, and 73 focused plugins covering full-stack development, security, infrastructure, and multi-agent orchestration.
A specialized agent skill for advanced TypeScript type system patterns, part of the wshobson/agents plugin marketplace with 146 skills across 73 plugins for Claude Code.
Production-ready workflow orchestration with 72 focused plugins, 108 specialized agents, and 129 skills - optimized for granular installation and minimal token usage
A Claude Code plugin bundling core development agents and tools from the wshobson/agents marketplace, providing a foundational set of AI-assisted capabilities with minimal token usage.
The error-debugging plugin is part of the wshobson/agents marketplace for Claude Code, providing specialized AI agents for diagnosing and resolving software errors.
A Claude Code plugin from the wshobson/agents marketplace providing specialized error diagnosis and troubleshooting agents for root cause analysis, stack trace investigation, and fix recommendations across technology stacks.
git-pr-workflows is a Claude Code plugin from the wshobson/agents marketplace that provides specialized Git and pull request workflow automation.
A specialized AI agent plugin for modernizing legacy codebases using Claude Code. Part of a comprehensive system of 112 specialized agents, it automates the assessment and transformation of outdated code into modern architectures and patterns.
A Claude Code plugin from the wshobson/agents marketplace for deployment validation, providing specialized AI agents and tools to ensure reliable production deployments within a 73-plugin ecosystem.
The data-validation-suite plugin is part of the wshobson/agents marketplace for Claude Code. It falls under the Data category, which includes two data-focused plugins: data engineering and data validation.