SOQL Query Builder & AI Assistant
High-speed point-and-click SOQL builder and natural language AI query generator. Build complex multi-relationship queries without manual syntax errors, preview results in real time, and export directly.
⚡ 1. Overview & Architecture
High-speed point-and-click SOQL builder and natural language AI query generator. Build complex multi-relationship queries without manual syntax errors, preview results in real time, and export directly.
🧭 2. Step-by-Step Workflow
Follow these steps to get maximum velocity with SOQL Builder:
Select Object or Prompt AI
Pick an SObject from the list, or type a natural language prompt in the AI input bar and click 🤖 Generate SOQL.
Select Fields & Conditions
Check the fields you need, or configure WHERE / ORDER BY / LIMIT conditions using the visual controls.
Execute & Export
Click Execute Query to preview records, then click Export CSV to save results.
🛠️ 3. Key Capabilities & Superpowers
AI Natural Language Generator
Type queries in plain English (e.g., "Find all open opportunities over 50k closing this month") and generate valid SOQL instantly.
Relationship Autocomplete
Type dot-notation (e.g. Account.Owner.Name) for instant parent relationship traversal with intelligent auto-suggestions.
Visual WHERE Clause Builder
Point-and-click filter constructor supporting AND/OR logic, typed operators (=, !=, IN, LIKE, EXCLUDES), and null validation.
Custom Metadata Types (__mdt)
1-click toggle to query and inspect Custom Metadata records with all custom attributes and metadata fields.
Live Execution & Paging
Execute queries directly against your active org with tabular results, column sorting, and record counts.
1-Click Data Export
Export queried records to CSV or JSON formats with proper UTF-8 BOM encoding for seamless Excel compatibility.
💡 4. Pro Tips & Keyboard Shortcuts
- Click any record ID in the results grid to navigate directly to that record in your Salesforce instance.
- Press Ctrl+Enter while inside the query editor to quickly execute the current query.
Explore More SF Lens Pro Guides
Discover how other integrated studio tools can accelerate your Salesforce development and administrative workflows.