SQL Writer
SkillSkill
Write complex SQL with CTEs, window functions, and optimization — readable queries that actually perform
About
Most SQL agents write works — until it hits a table with 10M rows. This skill installs the patterns that separate readable queries from fast ones: CTEs over nested subqueries, window functions for ranking and running totals, partial indexes for common filters, LATERAL joins for correlated subqueries, and EXPLAIN ANALYZE interpretation to find what's actually slow. Every pattern comes with an anti-pattern comparison.
Core Capabilities
- Write CTEs that replace nested subqueries with named, readable intermediate results
- Use window functions for ranking, running totals, moving averages, and first/last-per-group patterns
- Write conditional aggregations (FILTER, CASE WHEN) to pivot data without PIVOT syntax
- Design indexes (partial, covering, expression) and rewrite queries to use them
- Interpret EXPLAIN ANALYZE output to find seq scans, nested loops, and stale statistics
Customer ratings
0 reviews
No ratings yet
- 5 star0
- 4 star0
- 3 star0
- 2 star0
- 1 star0
No reviews yet. Be the first buyer to share feedback.
Version History
This skill is actively maintained.
May 11, 2026
One-time purchase
$19
By continuing, you agree to the Buyer Terms of Service.
Details
- Type
- Skill
- Category
- Engineering
- Price
- $19
- Version
- 1
- License
- One-time purchase
Works With
Works with OpenClaw, Claude Projects, Custom GPTs and other instruction-friendly AI tools.
Works great with
Personas that pair well with this skill.
Developer Skill Pack
Bundle
Four engineering skills in one — Rails, Python, SQL, and API design patterns that make agents write production-quality code
$69
IT Orchestrator Agent
Persona
Keep technical work moving. Reduce operational friction.
$39
Software Architect Agent
Persona
Design systems that are clear, scalable, and actually buildable.
$49