SOQL Assistant

Natural language SOQL for Salesforce

Q: Can a query modify or delete records?

The query cannot — only SELECT statements are permitted, and that is enforced server-side. But once you have a result set you can act on it deliberately: bulk update sets field values across every row the query returned, and bulk delete removes them. Both require owner or admin and the deployment’s write switch, both are refused against a production org unless an operator has separately enabled production DML, and delete asks you to type DELETE before it will run. If you would rather work from a spreadsheet than a query, the Data Loader covers insert, update, upsert and delete with its own review step.

Q: Can I get the results out?

Yes. Export the whole result set to CSV — written UTF-8 with a byte-order mark so Excel opens it correctly rather than mangling accented characters — or copy the grid to the clipboard as CSV or TSV to paste straight into a spreadsheet.

Q: Can I keep the queries I use often?

Save any query with a name and file it in a folder. The ones you run every week live next to the console instead of in a text file on your desktop, and folders keep a hundred of them navigable.

Q: Does it know my custom objects?

Yes. It describes your real schema (including managed packages you’ve pulled) before writing queries.

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. Then do something with what came back: export it, bulk-update it, or bulk-delete it.

Start free trial See pricing

SELECT Id, Name, Owner.Name, LastActivityDate FROM Account WHERE Id NOT IN (SELECT AccountId FROM Opportunity WHERE IsClosed = false) AND (LastActivityDate < LAST_N_DAYS:90 OR LastActivityDate = NULL) ORDER BY LastActivityDate NULLS LAST

FieldsAsk AI to build a query

Run queryor press ⌘/Ctrl + EnterMax rows

2000

Save query Insert records

The query box runs SELECT only — results are live (never cached) and capped at 5,000 rows. Insert / Update / Delete change records and are restricted to sandbox orgs.

SELECT Id, Name, Industry FROM Account ORDER BY CreatedDate DESC LIMIT 50SELECT Id, FirstName, LastName, Email, Account.Name FROM Contact LIMIT 50SELECT Id, Subject, Status, Priority FROM Case WHERE IsClosed = false LIMIT 50SELECT COUNT(Id) total, StageName FROM Opportunity GROUP BY StageName

214rows shownCopy for Excel Export CSV

#	Id	Name	Owner.Name	LastActivityDate
1	0015f00000AbCdEAAV	NORTHWIND HOLDINGS PTY LTD	Priya Nair	2026-05-14
2	0015f00000BcDeFAAV	BRIGHTWATER LOGISTICS PTY LTD	Jordan Chen	2026-04-28
3	0015f00000CdEfGAAV	MERIDIAN TRANSPORT PTY LTD	Priya Nair	2026-03-19
4	0015f00000DeFgHAAV	LANTERN ENTERPRISES PTY LTD	Wendy Turner	2026-02-02
5	0015f00000EfGhIAAV	CEDAR HAULAGE PTY LTD	Miles Doyle	2025-12-11
6	0015f00000FgHiJAAV	HARBOURVIEW TRADING PTY LTD	Nina Bishop	2025-11-04
7	0015f00000GhIjKAAV	STONEBRIDGE CIVIL PTY LTD	Jordan Chen	2025-09-22
8	0015f00000HiJkLAAV	KESTREL SUPPLY CO PTY LTD	Wendy Turner	—

The question is one query long, and asking for it as a report takes a week. Accounts with no open opportunities and no activity in 90 days — a NOT IN semi-join, run live, 214 rows back. The box runs SELECT only and caps at 5,000 rows, and it says so before you press anything.

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
Export the result set to CSV, or copy the grid as CSV or TSV straight into a spreadsheet
Bulk update every record the query returned: set field values across the whole result set in one pass
Bulk delete the result set, behind a typed confirmation and the same write gates as everything else
Saved queries filed into folders, so the handful you run every week stay 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 file what you’ll need again into a folder.

Act on the result

Export it to CSV, or turn the result set into a bulk update or a bulk delete — a separate, gated step, never something the query itself can do.

Why it's different

Reading and writing are two different acts

The query itself is SELECT-only, enforced server-side rather than by a prompt asking the AI nicely — no phrasing talks it into a DML statement. Acting on what came back is a deliberate second step through an entirely different client: bulk update and bulk delete need owner or admin, need the deployment’s write switch, are refused against production unless an operator separately enabled production DML, and a delete makes you type DELETE first. Results respect the connected user’s permissions, and every query and every write 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

The query cannot — only SELECT statements are permitted, and that is enforced server-side. But once you have a result set you can act on it deliberately: bulk update sets field values across every row the query returned, and bulk delete removes them. Both require owner or admin and the deployment’s write switch, both are refused against a production org unless an operator has separately enabled production DML, and delete asks you to type DELETE before it will run. If you would rather work from a spreadsheet than a query, the Data Loader covers insert, update, upsert and delete with its own review step.

Yes. Export the whole result set to CSV — written UTF-8 with a byte-order mark so Excel opens it correctly rather than mangling accented characters — or copy the grid to the clipboard as CSV or TSV to paste straight into a spreadsheet.

Save any query with a name and file it in a folder. The ones you run every week live next to the console instead of in a text file on your desktop, and folders keep a hundred of them navigable.

Yes. It describes your real schema (including managed packages you’ve pulled) before writing queries.

Put SOQL Assistant to work on your org

Every AI feature on your own provider key, from A$14.99 per user per month.

Start free trial See pricing

14-day free trial
No credit card required
Cancel any time

Natural language SOQL for Salesforce

What you can do

How it works

Describe the data you need

The AI grounds itself

Run, refine, save

Act on the result

Reading and writing are two different acts

SOQL Assistant — questions

Works even better with

AI Insights

Data Loader

Data Tables

Read next

Put SOQL Assistant to work on your org