Does this skill support Salesforce relationship queries?

Yes, it provides syntax for both parent-to-child subqueries and child-to-parent dot notation traversal up to 5 levels.

Can it help with Salesforce-specific date filtering?

Absolutely. It includes a full reference for date literals like TODAY, THIS_WEEK, and LAST_N_DAYS.

How does it handle SOQL limitations vs standard SQL?

The skill highlights key differences, such as the lack of JOIN and DISTINCT keywords, and provides alternatives like relationship queries and GROUP BY.

Is this useful for Salesforce CLI users?

Yes, it includes specific syntax tips for CLI compatibility, such as using the correct operators for null checks.

Salesforce SOQL Syntax Assistant

Name: Salesforce SOQL Syntax Assistant
Author: grailautomation

bygrailautomation

Database Management

Provides comprehensive syntax guidance and implementation patterns for writing, debugging, and optimizing Salesforce Object Query Language (SOQL) queries.

About

The Salesforce SOQL Syntax skill equips Claude with a deep understanding of Salesforce-specific data retrieval. It provides a complete reference for query structures, relationship traversal, aggregate functions, and date literals. By utilizing this skill, developers can quickly construct complex parent-child queries, avoid common platform limitations like long-text filtering constraints, and ensure their queries adhere to Salesforce best practices for performance and governor limit compliance.

Key Features

Guidance on platform-specific limitations such as result limits and field type filtering
Comprehensive reference for SOQL clauses including SELECT, WHERE, ORDER BY, and LIMIT
Support for relationship queries including subqueries and dot-notation traversal
Detailed guide for Salesforce date functions and relative date literals
Documentation for aggregate functions like COUNT, SUM, and AVG with GROUP BY support
0 GitHub stars

Use Cases

Writing complex multi-object queries for Salesforce Apex or integration development
Refactoring SQL-style queries into Salesforce-compliant SOQL syntax
Debugging syntax errors and performance issues in SOQL queries

About

Key Features

Guidance on platform-specific limitations such as result limits and field type filtering
Comprehensive reference for SOQL clauses including SELECT, WHERE, ORDER BY, and LIMIT
Support for relationship queries including subqueries and dot-notation traversal
Detailed guide for Salesforce date functions and relative date literals
Documentation for aggregate functions like COUNT, SUM, and AVG with GROUP BY support
0 GitHub stars

Use Cases

Writing complex multi-object queries for Salesforce Apex or integration development
Refactoring SQL-style queries into Salesforce-compliant SOQL syntax
Debugging syntax errors and performance issues in SOQL queries