Salesforce performance optimization methodology and investigation tools. Use when optimizing slow queries, managing governor limits, monitoring system health, or improving overall org performance. Provides investigation patterns, query optimization techniques, bulk operation patterns, and performance benchmarking.
From opspal-salesforcenpx claudepluginhub revpalsfdc/opspal-commercial --plugin opspal-salesforceThis skill is limited to using the following tools:
bulk-patterns.mdgovernor-limits.mdinvestigation-tools.mdquery-optimization.mdDesigns and optimizes AI agent action spaces, tool definitions, observation formats, error recovery, and context for higher task completion rates.
Enables AI agents to execute x402 payments with per-task budgets, spending controls, and non-custodial wallets via MCP tools. Use when agents pay for APIs, services, or other agents.
Compares coding agents like Claude Code and Aider on custom YAML-defined codebase tasks using git worktrees, measuring pass rate, cost, time, and consistency.
# Initialize metadata cache
node scripts/lib/org-metadata-cache.js init <org>
# Discover indexed fields
node scripts/lib/org-metadata-cache.js query <org> <object> | jq '.fields[] | select(.indexed == true)'
# Validate queries before execution
node scripts/lib/smart-query-validator.js <org> "<soql>"
| Limit | Per Transaction | Best Practice |
|---|---|---|
| SOQL Queries | 100 | Consolidate, use relationships |
| DML Operations | 150 | Batch into collections |
| CPU Time | 10,000ms | Avoid complex loops |
| Heap Size | 6MB | Don't store large objects |
| Callouts | 100 | Use async patterns |
| Operation | Sequential | Parallel/Batched | Improvement |
|---|---|---|---|
| Query optimization | 3,500ms | 800ms | 4x faster |
| Permission checks (20 users) | 50,000ms | 6,200ms | 8x faster |
| Security audits (40) | 60,000ms | 4,000ms | 15x faster |
See supporting files:
investigation-tools.md - Diagnosis methods and cache usagequery-optimization.md - SOQL optimization patternsgovernor-limits.md - Limit management strategiesbulk-patterns.md - Bulkification patterns