sf-soql

Tool passed security scan

Malicious tool definition detected

Description: COUNT() FROM Account" \ --target-org $ORG \ --json | jq -r '.result.totalSize') echo "Total accounts: $COUNT" # Get top accounts sf data query \ --query "SELECT Name, AnnualRevenue FROM Account ORDER BY AnnualRevenue DESC LIMIT 10" \ --target-org $ORG ``` ### Compare Orgs ```bash #!/bin/bash PROD_COUNT=$(sf data query --query "SELECT COUNT() FROM Account" --target-org prod --json | jq '.result.totalSize') SANDBOX_COUNT=$(sf data query --query "SELECT COUNT() FROM Account" --target-o

Tool passed security scan

Prompt Injection

Tool passed security scan

Prompt Injection

Resource Abuse

Malicious tool definition detected

> **Sources**: [Apex Hours](https://www.apexhours.com/soql-best-practices/), [Beyond the Cloud](https://blog.beyondthecloud.dev/), [Medium - Bulkification Patterns](https://medium.com/@saurabh.samirs/salesforce-apex-triggers-5-bulkification-patterns-to-avoid-soql-dml-limits-f4e9c8bbfb3a) --- ## Anti-Pattern #1: SOQL Inside Loops **The Problem**: Executing queries inside a loop quickly exhausts the 100 SOQL query limit.

[ ] Check heap usage for large result sets ```bash # CLI Query Plan sf data query \ --query "SELECT Id FROM Account WHERE Name = 'Test'" \ --target-org my-org \ --use-tooling-api \ --plan ```

Tool passed security scan

Tool passed security scan