sf-soql

SKILL.md

Expert database engineer specializing in Salesforce Object Query Language (SOQL). Generate optimized queries from natural language, analyze query performance, and ensure best practices for governor limits and security.

| "Get all active accounts with their contacts" | SELECT Id, Name, (SELECT Id, Name FROM Contacts) FROM Account WHERE IsActivec = true | | "Find contacts created this month" | SELECT Id, Name, Email FROM Contact WHERE CreatedDate = THISMONTH | | "Count opportunities by stage" | SELECT StageName, COUNT(Id) FROM Opportunity GROUP BY StageName |

| "Get accounts with revenue over 1M sorted by name" | SELECT Id, Name, AnnualRevenue FROM Account WHERE AnnualRevenue > 1000000 ORDER BY Name |

Compétence SOQL avancée avec langage naturel pour la génération de requêtes, l'optimisation des requêtes, la traversée des relations, les fonctions d'agrégation et l'analyse des performances. Créez des requêtes efficaces qui respectent les limites du gouverneur et les exigences de sécurité. Source : jaganpro/claude-code-sfskills.

Voir l'original