Activate when a SOQL query's ORDER BY behaves unexpectedly because of NULL values — null records appearing first when they should appear last, paginated results dropping records, or the same query returning records in a different order on subsequent runs. The skill produces a corrected ORDER BY clause, a pagination-stable cursor, and test data that reproduces the original surprise.
Soql Null Ordering Patterns is a community-contributed Claude Code skill in the general-misc sub-category. It ships as a SKILL.md file that Claude Code auto-discovers under ~/.claude/skills/soql-null-ordering-patterns/ and loads when your prompt matches the skill's trigger.
When to invoke it: Use when SOQL ORDER BY behavior with NULL values surprises a query — null records sorting before non-null, paginated results inconsistent across pages, NULLS FIRST/LAST clauses needed. Triggers: 'soql nulls first', 'soql null sort order', 'pagination missing records with null fields', 'order by skipping null records', 'consistent ordering with optional fields'.
The Soql Null Ordering Patterns skill is built for Claude Code users and developers across all disciplines looking for general-purpose AI assistance. It is part of the open ClaudSkills registry, a community-curated catalog of 56,000+ capabilities you can install for Claude Code — the Claude CLI agent.
mkdir -p ~/.claude/skills/soql-null-ordering-patterns curl -L https://claudskills.com/skills/soql-null-ordering-patterns/SKILL.md \ -o ~/.claude/skills/soql-null-ordering-patterns/SKILL.md
Or just download SKILL.md directly and drop it into ~/.claude/skills/soql-null-ordering-patterns/. Claude Code auto-discovers it on next session.
Skills live at ~/.claude/skills/soql-null-ordering-patterns/SKILL.md on macOS/Linux, or %USERPROFILE%\.claude\skills\soql-null-ordering-patterns\SKILL.md on Windows. See the full install guide for step-by-step instructions.
The ClaudSkills desktop app installs any skill directly into ~/.claude/skills/ with one click — no terminal required. Pro starts at $9/mo or $149 lifetime.
For the full experience including quality scoring and one-click install features for each skill — upgrade to Pro.
Browse all General skills in the ClaudSkills registry, or explore these other picks from the same category:
Part of Acreator Store — Adam Lankamer's AI tools: GifPerfect · AspectPerfect · SlomoPerfect · Ucaption · UTagger · AutoXPoster · TestYourSkills