sf-data

What problem does it solve?

Performing efficient Salesforce data operations (SOQL, DML, bulk operations, test data generation) while adhering to governor limits and best practices can be challenging and time-consuming. This Skill automates these tasks, ensuring data integrity and efficient testing.

Core Features & Use Cases

• CRUD & SOQL Expertise: Execute complex SOQL/SOSL queries with relationship traversal and aggregates, and perform DML operations (insert, update, delete, upsert) via Salesforce CLI.
• Test Data Generation: Create realistic test data using factory patterns for standard and custom objects, crucial for thorough trigger and flow testing (e.g., 251+ records for bulk testing).
• Bulk Operations: Leverage Bulk API 2.0 for high-volume data imports, updates, and deletes from CSV files, handling millions of records efficiently.
• Use Case: Generate 251 test 'Account' records and 500 'Contact' records linked to them, then execute a SOQL query to retrieve all Accounts with their related Contacts and Opportunities, all from the command line.

Quick Start

Use the sf-data skill to create 251 test 'Account' records for bulk testing.