sql-optimization-patterns from hermeticormus/claude-code-game-development is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
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 schemas, or optimizing application performance.
Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.
What the file says
# 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)
Understanding EXPLAIN output is fundamental to optimization.
**PostgreSQL EXPLAIN:**
```sql
-- Basic explain
EXPLAIN SELECT * FROM users WHERE email = 'user@example.com';
-- With actual execution stats
EXPLAIN ANALYZE
SELECT * FROM users WHERE email = 'user@example.com';
-- Verbose output with more details
EXPLAIN (ANALYZE, BUFFERS, VERBOSE)
SELECT u.*, o.order_total
FROM users u
JOIN orders o ON u.id = o.user_id
WHERE u.created_at > NOW() - INTERVAL '30 days';
```
**Key Metrics to Watch:**
- **Seq Scan**: Full table scan (usually slow for large tables)
- **Index Scan**: Using index (good)
…
The line at the top of this page pins the label git:20251120.50bf83d, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.
GET https://markdownregistry.com/api/v1/artifacts/art_zu5ugptdlq7bixcj
GET https://markdownregistry.com/api/v1/resolve?ref=hermeticormus/claude-code-game-development/sql-optimization-patterns
GET https://markdownregistry.com/api/v1/blob/bfd74fb05aa7e6cc40358f6360043f1db9c2c914b5dd9a22bd82b43d49b86a8a
Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.
hermeticormus/claude-code-game-development · .grok/skills/verify-claude-code-game-development/SKILL.md · Install the claude-code-game-development plugin pack the way a user does, into a clean Claude Code config and a clean…
hermeticormus/claude-code-game-development · plugins/audio-systems/skills/audio-patterns/SKILL.md · Game audio code patterns: a Godot bus layout, an audio player pool, randomized one-shot playback, vertical-remix…
hermeticormus/claude-code-game-development · plugins/backend-development/skills/api-design-principles/SKILL.md · Master REST and GraphQL API design principles to build intuitive, scalable, and maintainable APIs that delight…
hermeticormus/claude-code-game-development · plugins/backend-development/skills/temporal-python-testing/SKILL.md · Test Temporal workflows with pytest, time-skipping, and mocking strategies. Covers unit testing, integration testing…
hermeticormus/claude-code-game-development · plugins/blockchain-web3/skills/defi-protocol-templates/SKILL.md · Implement DeFi protocols with production-ready templates for staking, AMMs, governance, and lending systems. Use when…
sandbaseai/sandbase-skills · marketing/sql-optimization-patterns/SKILL.md · Apply sql optimization patterns in reproducible local data workflows with version-aware APIs, explicit assumptions, and…
