SOQL Scratchpad

Write and execute SOQL queries against Salesforce orgs directly from VS Code — with live results, auto-complete, and query management.

Features

• Execute SOQL Queries — Run queries against any authenticated Salesforce org and view results in a sortable table
• Auto-Complete — Get suggestions for Salesforce objects and fields as you type
• Save & Manage Queries — Save frequently used queries for quick access
• Query History — Automatically tracks executed queries
• Export to CSV — Export query results with one click
• Format Queries — Auto-format your SOQL for readability
• Object Browser — Browse available Salesforce objects and their fields

Requirements

• Salesforce CLI (sf) must be installed
• At least one authenticated Salesforce org (sf org login web)
• A default target org set (sf config set target-org <username>)

Usage

1. Open the command palette (Ctrl+Shift+P / Cmd+Shift+P)
2. Run SOQL Scratchpad: Open Query Editor
3. Or use the keyboard shortcut: Ctrl+Shift+Q / Cmd+Shift+Q

Getting Started

# Install Salesforce CLI
npm install -g @salesforce/cli

# Authenticate an org
sf org login web

# Set default org
sf config set target-org your-username@example.com

Then open the SOQL Scratchpad and start querying!