Describe the data you need. Get a ready-to-run SOQL query.

Parent-to-child subqueries, date literals, aggregates, and SOSL searches are easy to get slightly wrong. Describe what you want in plain English and AISOQL drafts the query for you to review and run.

Queries come back as files you can keep with your project, alongside any Apex that uses them.

Try it free Read the FAQ

No credit card required. AISOQL never asks for your Salesforce password, and every result downloads as a project you review and deploy yourself.

What you get

SOQL with relationship subqueries, filters, ordering and limits
SOSL searches across objects
Date literals and aggregate functions used correctly
A plain-English explanation so you can verify the logic
Matching Apex when you need to run the query from code

How it works

Describe the data

Which objects, which filters, how many records.

Review the query

Check the fields and conditions against your org's schema.

Run it

Paste it into the Developer Console or Salesforce CLI, or use it in Apex.

Example

SELECT Id, Name,
       (SELECT Id, LastName FROM Contacts WHERE Email != null)
FROM Account
WHERE Industry = 'Technology'
  AND CreatedDate = LAST_N_DAYS:90
ORDER BY Name
LIMIT 200

Illustrative only. Confirm field and object names against your own org.

Built to enhance, not replace

AISOQL drafts the boilerplate so you can spend your time on architecture, review and the judgment calls only a developer can make. It works with Salesforce's standard project format and sandbox tooling, and nothing reaches an org unless you choose to deploy it. AISOQL is an independent product and is not affiliated with Salesforce, Inc.

Frequently asked questions

Does AISOQL know my org's fields?

No. It never connects to your org to read your schema, so confirm field and object names before running the query.

Can it generate SOSL too?

Yes. SOQL and SOSL queries are both supported.

Is there a free way to try it?

Yes. New accounts get free starting tokens and no credit card is required.

More AISOQL tools

Start free

New accounts get free starting tokens. No credit card required.