sql-optimization-patterns
SQL Optimization Patterns
Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.
When to Use This Skill
- 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
Core Concepts
1. Query Execution Plans (EXPLAIN)
More from arustydev/ai
cross-browser-compatibility
Browser API differences, polyfills, and feature detection for Firefox, Chrome, Safari, and Edge extensions
16pkgmgr-homebrew-formula-dev
Create, test, and maintain Homebrew formulas. Use when adding packages to a Homebrew tap, debugging formula issues, running brew audit/test, or automating version updates with livecheck. Use when creating a new Homebrew formula for a project.
15seo-for-developers
SEO fundamentals for technical blog posts — meta tags, structured data, keyword placement, and readability optimization
15extension-anti-patterns
Common mistakes, performance pitfalls, and store rejection reasons in browser extension development
12wxt-framework-patterns
Comprehensive WXT browser extension framework patterns, security hardening rules, and cross-browser configuration
12beads
>
11