SOQL Assistant
Natural language SOQL for Salesforce
Stop wrestling with relationship syntax. Describe what you need, and the assistant checks the real schema, writes the SOQL, runs it, and shows results — or reviews and fixes the query you wrote yourself.
What you can do
- English to SOQL, grounded in your actual objects and fields — not generic guesses
- Live, SELECT-only execution with row counts and full result grids
- Paste your own SOQL for the AI to explain, review, or fix
- Saved queries: keep the ones your team runs every week one click away
- Handles parent and child relationship queries, aggregates, and date literals
How it works
Describe the data you need
“Opportunities created this month, sorted by amount, with the account name and owner.”
The AI grounds itself
It describes the objects involved to get real field names before writing a line of SOQL.
Run, refine, save
Execute live, tweak in plain English or raw SOQL, and save what you’ll need again.
Why it's different
SELECT-only, permission-aware
The query console physically cannot run DML — the underlying client only permits reads. Results respect the connected user’s permissions, and every query is audit-logged.
Try asking
- “Accounts with no open opportunities and no activity in 90 days.”
- “Sum of Amount by StageName for opportunities closing this quarter.”
- “Contacts missing an email, grouped by account owner.”
- “Why does this query return no rows?”
SOQL Assistant — questions
Works even better with
AI Insights
Describe the report you need. Insights writes the SOQL, picks the chart, checks its own work, and saves a live dashboard.
Learn moreAI Org Chat
Ask your org anything. The assistant inspects schema, automation, code, and live data with 48+ read-only tools — and remembers what it learns.
Learn moreData Tables
Spreadsheet-style views of live Salesforce data: dot-path parent columns, filters, grouping, child grids, and inline editing.
Learn morePut SOQL Assistant to work on your org
Start free with the Metadata Explorer — every AI feature is free while the beta runs, and a competitive price is still being worked out.