platform-soql-query

Describe the target object, fields, filter criteria, and sort or limit needs in plain English. The skill selects the right query shape — child-to-parent traversal, subquery, aggregate, or SOSL — and returns the final SOQL with design rationale and optimization notes.

Add filters on indexed fields such as Id, Name, OwnerId, CreatedDate, or RecordTypeId, avoid leading wildcards and negative operators, and apply a reasonable LIMIT. A query is selective when it returns under 10% of the first million records.

The most damaging patterns are queries inside loops, non-selective WHERE clauses, leading wildcards, querying for null, selecting all fields, and unfiltered subqueries. The fix is bulkification: collect IDs first, query once with IN, and use a Map for lookups.

Yes, use sf data query with --query and --target-org flags, with JSON or CSV output formats. For large result sets over 2,000 records use sf data export bulk, and use the Tooling API plan flag for query plan analysis.

The error occurs when code accesses a field not included in the SELECT clause, including parent relationship fields like Account.Name. Every field read in conditionals, assignments, or method calls must appear in the query, using dot notation for relationships.

Delegate bulk data import, export, or DML operations to a data management skill, and broader Apex implementation work to an Apex generation skill. This skill focuses on query authoring, optimization, and validation only.