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

0•

Gestión de Bases de Datos

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

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.

Características Principales

01Guidance on platform-specific limitations such as result limits and field type filtering

02Comprehensive reference for SOQL clauses including SELECT, WHERE, ORDER BY, and LIMIT

03Support for relationship queries including subqueries and dot-notation traversal

04Detailed guide for Salesforce date functions and relative date literals

05Documentation for aggregate functions like COUNT, SUM, and AVG with GROUP BY support

060 GitHub stars

Casos de Uso

01Writing complex multi-object queries for Salesforce Apex or integration development

02Refactoring SQL-style queries into Salesforce-compliant SOQL syntax

03Debugging syntax errors and performance issues in SOQL queries

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add grailautomation/claude-plugins soql-syntax

For use in Claude.ai and ChatGPT

Download Skill