skills.rest
Jaganpro
JaganproCOMMUNITY
Explore all skills by this author →
𝕏@jaghubGitHub

sf-data

Automate Salesforce data operations with SOQL, DML, and bulk processing via sf CLI.

423|97|Updated Nov 30, 2025
Search Tags:#automation#cli#data#test data#salesforce#soql#dml#bulk api
One-click install
npx skills add https://github.com/Jaganpro/sf-skills --skill sf-data
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sf-data
Source: https://github.com/Jaganpro/sf-skills/tree/main/sf-data/skills/sf-data
Command: npx skills add https://github.com/Jaganpro/sf-skills --skill sf-data

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires sf-cli, python, and includes scripts (resource) components.

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.

Frequently Asked Questions about sf-data

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate test data for Salesforce bulk testing?▼

Create test data using factory patterns for standard and custom objects via sf CLI. Generate 251+ records for bulk testing triggers and flows, then execute SOQL queries to validate relationships and aggregates across linked objects.

Can I automate SOQL queries and DML operations from the command line?▼

Yes. Execute complex SOQL queries with relationship traversal and aggregates, and perform DML operations (insert, update, delete, upsert) directly through Salesforce CLI while enforcing governor limits.

What's the best way to import large volumes of data into Salesforce?▼

Leverage Bulk API 2.0 for high-volume imports, updates, and deletes from CSV files. This handles millions of records efficiently and integrates with sf CLI for automated processing.

Do I need Python to automate Salesforce data operations?▼

Python is a dependency for this Skill and enables script generation and remote-execution modes. Combined with sf CLI, it supports SOQL, DML, test data generation, and bulk operations with security best practices.

How do I perform data cleanup and rollback during isolated tests?▼

Execute cleanup with rollback capabilities during isolated tests using DML operations via sf CLI. The Skill enforces governor limits and integrates with sf-metadata, sf-apex, and sf-flow for comprehensive validation.

Related Skills

Explore More Data & Analytics Skills→
AstorYHAstorYH
15

salesforce-object-fetch

Retrieve Salesforce object records using SOQL queries with dynamic filtering.

Community
Intermediate
pmcdowallpmcdowall

salesforce

Manage Salesforce Sales Cloud data queries, configuration review, and development workflows.

Community
Advanced
padjeipadjei

platform-metadata-deploy

Automate Salesforce metadata deployment and orchestration using sf CLI v2.

Community
Advanced
jiten-singh-shahijiten-singh-shahi
13

sf-soql-optimization

Identify and optimize inefficient SOQL queries in Salesforce Apex code.

Community
Advanced