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(268 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.
Agent skill for Node.js backend development patterns including API design, architecture, and microservices, part of the wshobson/agents collection with 73 focused plugins and 146 skills for Claude Code.
Claude Code plugin for AI-powered framework migration workflows, coordinating specialized agents to plan and execute transitions between technology stacks as part of the wshobson/agents marketplace.
A Claude Code plugin for payment system integration covering Stripe, PayPal, and billing platforms with checkout flows, subscription management, and webhook handling in the wshobson/agents ecosystem.
A Claude Code plugin bundling core development tools and agents for everyday tasks like debugging and code generation, part of the wshobson/agents marketplace with 73 focused plugins.
Claude Code plugin for observability and monitoring including logging, metrics, distributed tracing, and alerting, part of the wshobson/agents marketplace with 73 focused plugins.
A Claude Code plugin providing specialized AI agents for deployment strategy planning and execution, covering blue-green deployments, canary releases, rolling updates, and zero-downtime patterns.
A Claude Code plugin for rapid API project scaffolding, part of the wshobson/agents marketplace with 73 focused plugins, 112 specialized agents, and 146 agent skills.
Claude Code plugin for JVM language development including Java, Kotlin, and Scala with specialized agents for idiomatic patterns, build tools, and runtime optimization in the wshobson/agents marketplace.