Native SOQL editor for Mac, with AI.

Why SOQL deserves its own editor

SOQL (Salesforce Object Query Language) is its own dialect, not standard SQL. It has Salesforce-specific syntax for relationship queries (Account.Owner.Name traversals), aggregate functions with quirky behavior, GROUP BY ROLLUP/CUBE for hierarchical aggregations, and SOQL-specific limits (max 50K rows per query, max relationship depth of 5). Generic SQL editors don't handle this well. Salesforce-specific tools (Workbench, Inspector) are usually browser-based without modern editor features.

QueryFlow's SOQL editor

Built on CodeMirror with full SOQL dialect support: syntax highlighting that understands SOQL specifically (not just generic SQL), autocomplete that knows your object and field names from the connected org, error checking that catches SOQL-specific issues (depth limits, aggregate without GROUP BY, relationship field paths). Multi-tab workspace means you can have your daily query in one tab, exploratory queries in others, scheduled job definitions in another.

Claude AI for SOQL writing

Claude AI is integrated into the editor with full Salesforce schema awareness — every object, every field, every relationship. Ask Claude to write a query against your custom Opportunity__c object joining standard Account and Contact, filtering by stage and close date, and it produces valid SOQL with the correct relationship navigation syntax. Ask why a query is hitting the 50K row limit and Claude analyzes the WHERE clause selectivity.

SOQL-specific features

Aggregate function shortcuts: type SUM(Amount) and Claude/autocomplete knows you'll likely want GROUP BY. Relationship query helpers: type Account. in the SELECT clause and autocomplete shows valid Account relationship fields. Subquery support: SOQL's nested SELECTs for parent-child relationships have explicit help. Aliasing for grouped queries: required by Salesforce for AggregateResult output, easy to forget.

Persistent OAuth, no re-login

Workbench requires re-authentication every session. QueryFlow uses OAuth 2.0 with a Connected App — authenticate once, the connection persists with automatic token refresh. Credentials stored in macOS Keychain with Secure Enclave protection.

Export and pipeline integration

SOQL query results don't have to stay in the editor. Export to CSV with one click. Configure the query as a scheduled job with destinations: write to Google Sheets, send via email, upload to S3, push to Snowflake/Redshift/Postgres as a new table. Same query, multiple destinations, run daily on cron.

Bulk SOQL queries over 50K rows

Standard SOQL caps at 50,000 rows per query. For larger result sets, Salesforce provides the Bulk API v2 for asynchronous query execution. QueryFlow automatically uses Bulk API v2 for queries that would exceed the standard limit. The query runs asynchronously, results stream back as they're available, and you can monitor progress in the Observatory dashboard.