platform-soql-query

The platform-soql-query skill is a Salesforce SOQL query expert for SOQL/SOSL authoring and optimization, including natural-language-to-query generation, relationship queries, aggregates, query-plan analysis, and performance or safety improvements, evaluated with a 100-point scoring guide. It triggers when a user writes, optimizes, or debugs SOQL/SOSL queries, touches .soql files, or asks about relationship queries, aggregates, or query performance. It explicitly does not own bulk data operations (which go to platform-data-manage), Apex DML logic (platform-apex-generate), or report and dashboard queries.

The skill gathers required context first — target objects, fields, filter criteria, sort/limit needs, intended use, and whether selectivity is already a concern — then follows a recommended workflow: generate the simplest correct query, choose the right query shape from a decision table (child-to-parent traversal, subquery, aggregate query, semi-join/anti-join, or SOSL), optimize for selectivity and safety, and validate the execution path if needed. High-signal rules include querying only required fields, never querying inside Apex loops, filtering in SOQL rather than post-filtering in Apex, using aggregates for counts, and evaluating wildcard usage since leading wildcards often defeat indexes. Output is reported in a fixed order (query purpose, final SOQL/SOSL, why the shape was chosen, optimization or security notes, and an execution suggestion), and results map to a score guide where 90+ is production-optimized and below 70 needs revision.

The skill ships an extensive reference and asset index for Salesforce developers: references such as soql-syntax-reference.md, query-optimization.md, anti-patterns.md, selector-patterns.md, field-coverage-rules.md, and cli-commands.md, plus .soql asset examples for basic, relationship, aggregate, and optimization patterns and .cls templates for bulkified queries and selector classes. A post-tool-validate.py script runs static SOQL validation and live query-plan analysis after .soql file edits. It defines clear cross-skill hand-offs — delegating execution and export to platform-data-manage, Apex embedding to platform-apex-generate, log-based debugging to platform-apex-logs-debug, and query-backed UI to experience-lwc-generate.