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(234 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
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.
The ui-design plugin is part of the wshobson/agents marketplace for Claude Code, providing specialized AI agents for UI/UX design assistance within development workflows.
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.
An MLOps plugin from the wshobson/agents ecosystem providing Claude Code with specialized agents and skills for ML pipeline management, model deployment, experiment tracking, and production monitoring.
Shell Scripting is a Claude Code plugin from the wshobson/agents marketplace that provides AI-powered assistance for writing and maintaining shell scripts.
A Claude Code plugin with specialized AI agents for accessibility compliance auditing, WCAG standards verification, and remediation guidance in web and mobile applications.
The reverse-engineering plugin is part of the wshobson/agents marketplace for Claude Code, providing specialized AI agents for code analysis, binary examination, and system reverse engineering tasks.
A Claude Code plugin for CI/CD automation with 4 specialized skills covering pipeline design, GitHub Actions, GitLab CI, and secrets management, part of the wshobson/agents marketplace.
Comprehensive Review is a Claude Code plugin from the wshobson/agents marketplace that provides multi-perspective code analysis covering architecture, security, and best practices.
The functional-programming plugin is part of the wshobson/agents marketplace for Claude Code. It falls under the Languages category, which includes seven language-focused plugins covering Python, JavaScript/TypeScript, systems programming, JVM, sc...