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/json/full-hierarchy-tree.json

View on GitHub
{
  "records": [
    {
      "attributes": {
        "type": "Account",
        "referenceId": "AccountRef1"
      },
      "Name": "Full Hierarchy Account 001",
      "Industry": "Technology",
      "Type": "Customer",
      "AnnualRevenue": 15000000,
      "NumberOfEmployees": 500,
      "BillingStreet": "100 Enterprise Way",
      "BillingCity": "San Francisco",
      "BillingState": "CA",
      "BillingPostalCode": "94102",
      "BillingCountry": "USA",
      "Phone": "(555) 500-0001",
      "Website": "https://fullhierarchy001.example.com",
      "Description": "Complete hierarchy with contacts, opportunities, and cases",
      "Contacts": {
        "records": [
          {
            "attributes": {
              "type": "Contact",
              "referenceId": "ContactRef1"
            },
            "FirstName": "Sarah",
            "LastName": "Executive",
            "Email": "sarah.executive@fullhierarchy.example.com",
            "Phone": "(555) 501-0001",
            "MobilePhone": "(555) 502-0001",
            "Title": "Chief Executive Officer",
            "Department": "Executive",
            "MailingCity": "San Francisco",
            "MailingState": "CA"
          },
          {
            "attributes": {
              "type": "Contact",
              "referenceId": "ContactRef2"
            },
            "FirstName": "Tom",
            "LastName": "Technical",
            "Email": "tom.technical@fullhierarchy.example.com",
            "Phone": "(555) 501-0002",
            "MobilePhone": "(555) 502-0002",
            "Title": "Chief Technology Officer",
            "Department": "Technology",
            "MailingCity": "San Francisco",
            "MailingState": "CA"
          },
          {
            "attributes": {
              "type": "Contact",
              "referenceId": "ContactRef3"
            },
            "FirstName": "Patricia",
            "LastName": "Procurement",
            "Email": "patricia.procurement@fullhierarchy.example.com",
            "Phone": "(555) 501-0003",
            "MobilePhone": "(555) 502-0003",
            "Title": "VP Procurement",
            "Department": "Operations",
            "MailingCity": "San Francisco",
            "MailingState": "CA"
          }
        ]
      },
      "Opportunities": {
        "records": [
          {
            "attributes": {
              "type": "Opportunity",
              "referenceId": "OppRef1"
            },
            "Name": "Enterprise Platform License",
            "StageName": "Negotiation/Review",
            "CloseDate": "2025-04-30",
            "Amount": 750000,
            "Probability": 85,
            "Type": "New Customer",
            "LeadSource": "Partner Referral",
            "NextStep": "Final contract review",
            "Description": "Multi-year enterprise platform license"
          },
          {
            "attributes": {
              "type": "Opportunity",
              "referenceId": "OppRef2"
            },
            "Name": "Implementation Services",
            "StageName": "Proposal/Price Quote",
            "CloseDate": "2025-05-15",
            "Amount": 200000,
            "Probability": 70,
            "Type": "New Customer",
            "LeadSource": "Partner Referral",
            "NextStep": "SOW review meeting",
            "Description": "Professional services for implementation"
          }
        ]
      },
      "Cases": {
        "records": [
          {
            "attributes": {
              "type": "Case",
              "referenceId": "CaseRef1"
            },
            "Subject": "Pre-sales technical inquiry",
            "Status": "New",
            "Priority": "Medium",
            "Origin": "Email",
            "Type": "Question",
            "Description": "Questions about API integration capabilities"
          }
        ]
      }
    },
    {
      "attributes": {
        "type": "Account",
        "referenceId": "AccountRef2"
      },
      "Name": "Full Hierarchy Account 002",
      "Industry": "Finance",
      "Type": "Prospect",
      "AnnualRevenue": 50000000,
      "NumberOfEmployees": 2000,
      "BillingStreet": "200 Financial District",
      "BillingCity": "New York",
      "BillingState": "NY",
      "BillingPostalCode": "10001",
      "BillingCountry": "USA",
      "Phone": "(555) 600-0001",
      "Website": "https://fullhierarchy002.example.com",
      "Description": "Large financial services prospect",
      "Contacts": {
        "records": [
          {
            "attributes": {
              "type": "Contact",
              "referenceId": "ContactRef4"
            },
            "FirstName": "Michael",
            "LastName": "Manager",
            "Email": "michael.manager@fullhierarchy.example.com",
            "Phone": "(555) 601-0001",
            "Title": "IT Director",
            "Department": "Information Technology"
          },
          {
            "attributes": {
              "type": "Contact",
              "referenceId": "ContactRef5"
            },
            "FirstName": "Linda",
            "LastName": "Leadership",
            "Email": "linda.leadership@fullhierarchy.example.com",
            "Phone": "(555) 601-0002",
            "Title": "SVP Operations",
            "Department": "Operations"
          }
        ]
      },
      "Opportunities": {
        "records": [
          {
            "attributes": {
              "type": "Opportunity",
              "referenceId": "OppRef3"
            },
            "Name": "Risk Management Platform",
            "StageName": "Needs Analysis",
            "CloseDate": "2025-08-01",
            "Amount": 1200000,
            "Probability": 35,
            "Type": "New Customer",
            "LeadSource": "Trade Show",
            "NextStep": "Technical deep dive",
            "Description": "Enterprise risk management solution"
          }
        ]
      }
    }
  ]
}
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