Skip to content

forcedotcom/sf-skills / plugins/builder/salesforce-development/skills/platform-data-manage

platform-data-manage

Verified

Salesforce data operations with 130-point scoring. Use to create, update, delete, bulk import/export, generate test data, and clean up org records via sf CLI and anonymous Apex. TRIGGER on creating test data, bulk import/export, sf data CLI commands, data-factory patterns for Apex tests, or seeding/cleaning org records. DO NOT TRIGGER for SOQL query writing only (use platform-soql-query), Apex test execution (use platform-apex-test-run), or metadata deployment (use platform-metadata-deploy).

FileKindSize
README.mdmarkdown4.5 KB
SKILL.mdskill md10.5 KB
assets/bulk/bulk-insert-10000.apexother12.3 KB
assets/bulk/bulk-insert-200.apexother12.4 KB
assets/bulk/bulk-insert-500.apexother13.1 KB
assets/bulk/bulk-upsert-external-id.apexother13.4 KB
assets/cleanup/delete-by-created-date.apexother15.9 KB
assets/cleanup/delete-by-name.apexother12.9 KB
assets/cleanup/delete-test-data.apexother16.6 KB
assets/cleanup/rollback-transaction.apexother12.4 KB
assets/csv/account-import.csvother1.8 KB
assets/csv/contact-import.csvother1.9 KB
assets/csv/custom-object-import.csvother1.1 KB
assets/csv/opportunity-import.csvother1.6 KB
assets/factories/account-factory.apexother5.6 KB
assets/factories/case-factory.apexother8.1 KB
assets/factories/contact-factory.apexother5.9 KB
assets/factories/custom-object-factory.apexother10.8 KB
assets/factories/event-factory.apexother9.6 KB
assets/factories/hierarchy-factory.apexother16.0 KB
assets/factories/lead-factory.apexother6.4 KB
assets/factories/opportunity-factory.apexother7.3 KB
assets/factories/task-factory.apexother8.1 KB
assets/factories/user-factory.apexother8.8 KB
assets/json/account-contact-tree.jsonconfig3.6 KB
assets/json/account-opportunity-tree.jsonconfig3.3 KB
assets/json/full-hierarchy-tree.jsonconfig5.8 KB
assets/soql/aggregate.soqlother12.3 KB
assets/soql/child-to-parent.soqlother9.8 KB
assets/soql/parent-to-child.soqlother8.6 KB
assets/soql/polymorphic.soqlother11.1 KB
assets/soql/subquery.soqlother16.2 KB
references/anonymous-apex-guide.mdmarkdown2.0 KB
references/bulk-operations-guide.mdmarkdown1.8 KB
references/bulk-testing-example.mdmarkdown4.9 KB
references/cleanup-rollback-example.mdmarkdown8.2 KB
references/cleanup-rollback-guide.mdmarkdown1.7 KB
references/crud-workflow-example.mdmarkdown4.0 KB
references/governor-limits-reference.mdmarkdown1.8 KB
references/orchestration.mdmarkdown7.0 KB
references/relationship-query-examples.mdmarkdown5.7 KB
references/sf-cli-data-commands.mdmarkdown2.8 KB
references/soql-relationship-guide.mdmarkdown2.0 KB
references/test-data-best-practices.mdmarkdown3.2 KB
references/test-data-factory-usage.mdmarkdown7.6 KB
references/test-data-patterns.mdmarkdown2.4 KB
scripts/soql_validator.pyscript10.9 KB
scripts/validate_data_operation.pyscript13.5 KB

assets/soql/parent-to-child.soql

View on GitHub
-- ═══════════════════════════════════════════════════════════════════════════════
-- PARENT-TO-CHILD QUERY (Subquery Pattern)
-- ═══════════════════════════════════════════════════════════════════════════════
--
-- Returns parent records with related child records nested in the results.
-- Child records are returned as a nested list within each parent record.
--
-- USE WHEN:
-- • Starting from the parent object and need child record details
-- • Need to iterate through parents and their related children
-- • Building hierarchical data structures
--
-- LIMITS:
-- • Maximum 20 subqueries per query
-- • Child records limited by inner LIMIT (or 200 if not specified)
-- • 5 levels of relationship depth
--
-- ═══════════════════════════════════════════════════════════════════════════════

-- ───────────────────────────────────────────────────────────────────────────────
-- BASIC: Account with Contacts
-- ───────────────────────────────────────────────────────────────────────────────
SELECT Id, Name, Industry, AnnualRevenue,
    (SELECT Id, FirstName, LastName, Email, Phone, Title
     FROM Contacts
     ORDER BY LastName ASC
     LIMIT 100)
FROM Account
WHERE Industry = 'Technology'
LIMIT 50

-- ───────────────────────────────────────────────────────────────────────────────
-- MULTIPLE CHILDREN: Account with Contacts AND Opportunities
-- ───────────────────────────────────────────────────────────────────────────────
SELECT Id, Name, Industry,
    (SELECT Id, FirstName, LastName, Email
     FROM Contacts
     WHERE Email != null
     LIMIT 50),
    (SELECT Id, Name, StageName, Amount, CloseDate
     FROM Opportunities
     WHERE IsClosed = false
     ORDER BY CloseDate ASC
     LIMIT 50)
FROM Account
WHERE Id IN :accountIds

-- ───────────────────────────────────────────────────────────────────────────────
-- FILTERED CHILDREN: Only active/specific child records
-- ───────────────────────────────────────────────────────────────────────────────
SELECT Id, Name,
    (SELECT Id, Subject, Status, Priority
     FROM Cases
     WHERE Status != 'Closed'
     AND Priority = 'High'
     ORDER BY CreatedDate DESC
     LIMIT 25)
FROM Account
WHERE Type = 'Customer'

-- ───────────────────────────────────────────────────────────────────────────────
-- OPPORTUNITY with Products (OpportunityLineItems)
-- ───────────────────────────────────────────────────────────────────────────────
SELECT Id, Name, StageName, Amount, CloseDate,
    Account.Name,
    (SELECT Id, Name, Quantity, UnitPrice, TotalPrice,
            Product2.Name, Product2.ProductCode
     FROM OpportunityLineItems
     ORDER BY TotalPrice DESC)
FROM Opportunity
WHERE StageName = 'Closed Won'
AND CloseDate = THIS_QUARTER

-- ───────────────────────────────────────────────────────────────────────────────
-- CASE with Comments and Attachments
-- ───────────────────────────────────────────────────────────────────────────────
SELECT Id, CaseNumber, Subject, Status, Priority,
    Account.Name,
    Contact.Name,
    (SELECT Id, CommentBody, CreatedBy.Name, CreatedDate
     FROM CaseComments
     ORDER BY CreatedDate DESC
     LIMIT 10),
    (SELECT Id, Name, ContentType, BodyLength
     FROM Attachments
     LIMIT 20)
FROM Case
WHERE Status != 'Closed'
ORDER BY Priority DESC, CreatedDate DESC

-- ───────────────────────────────────────────────────────────────────────────────
-- USER with all related activity
-- ───────────────────────────────────────────────────────────────────────────────
SELECT Id, Name, Username, IsActive,
    (SELECT Id, Subject, Status, ActivityDate
     FROM TasksOwned
     WHERE Status != 'Completed'
     ORDER BY ActivityDate ASC
     LIMIT 25),
    (SELECT Id, Subject, StartDateTime, EndDateTime
     FROM EventsOwned
     WHERE StartDateTime >= TODAY
     ORDER BY StartDateTime ASC
     LIMIT 25)
FROM User
WHERE IsActive = true
AND Profile.Name = 'Standard User'

-- ───────────────────────────────────────────────────────────────────────────────
-- CUSTOM OBJECT: Parent with Custom Child Objects
-- Replace {{ParentObject}}, {{ChildRelationshipName}}, {{ChildObject}} with actual names
-- ───────────────────────────────────────────────────────────────────────────────
-- SELECT Id, Name, Status__c,
--     (SELECT Id, Name, Amount__c, Date__c
--      FROM {{ChildRelationshipName}}__r
--      WHERE Status__c = 'Active'
--      ORDER BY Date__c DESC
--      LIMIT 50)
-- FROM {{ParentObject}}__c
-- WHERE OwnerId = :userId

-- ═══════════════════════════════════════════════════════════════════════════════
-- APEX PROCESSING PATTERN
-- ═══════════════════════════════════════════════════════════════════════════════
/*
// Query with subquery
List<Account> accounts = [
    SELECT Id, Name,
        (SELECT Id, FirstName, LastName FROM Contacts)
    FROM Account
    WHERE Id IN :accountIds
];

// Process parent and children
for (Account acc : accounts) {
    System.debug('Account: ' + acc.Name);

    // Access child records via relationship name
    if (acc.Contacts != null && !acc.Contacts.isEmpty()) {
        for (Contact con : acc.Contacts) {
            System.debug('  Contact: ' + con.FirstName + ' ' + con.LastName);
        }
    }
}
*/

-- ═══════════════════════════════════════════════════════════════════════════════
-- SF CLI USAGE
-- ═══════════════════════════════════════════════════════════════════════════════
-- sf data query \
--   --query "SELECT Id, Name, (SELECT Id, Name FROM Contacts) FROM Account LIMIT 10" \
--   --target-org myorg \
--   --json
finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the workStars: 322kUpdated Claude CodeCodexVerifiedInstall
systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixesStars: 322kUpdated Claude CodeCodexVerifiedInstall
test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation codeStars: 322kUpdated Claude CodeCodexVerifiedInstall
skill-creatoranthropics/skillsCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy.Stars: 198kUpdated Claude CodeCodexVerifiedInstall