SoqlX
Jump To: Download |
Running Queries |
Explore Schema |
Run Anonymous Apex |
Detailed Help |
Versions |
|
|
SoqlX is an MacOS app for developers on the Salesforce.com platform. Allowing you to run queries, edit data, and do other data related tasks including:
|
Queries
From the Query tab you can execute SOQL & SOSL queries. Type the query into the top box and hit `Query`. The left column shows all your Salesforce SObjects and you can expand them out to see the fields. Double click on an object or field to build a query, or just type it in. If you execute a SOQL Relationships query the magnifying glass icon will appear in the results, double click this to expose a second table showing those particular results.
If you include the Id field in your query, then you'll get the delete checkbox option, as well as the ability to double click in a cell an edit the value.
The `recent` window will show your last 10 executed queries, click on any of them to copy the query back to the main query input.
From the File menu you can choose to save your query results as a CSV file and/or save the query itself.
Graphical schema explorer
- The central purple box shows the selected SObject. Other related SObjects appear around it.
- Use the +/- buttons to expand/contract the list of fields shown for a particular SObject. double click any SObject to make it the center focus (or select it from the SObject list on the left).
- To generate a schema report, right click on an object name from the list, once the report window has opened, you can print the report, or save it to a PDF.
Anonymous Apex
- Easily run anonymous apex and see the results.
- Code is syntax highlighted, and will highlight the line when there's a compilation error.
- Set the different logging levels and see the log output when you run the code.
History
|
| Way back when (2005ish?) DevAngel aka Dave Carroll wrote a .NET tool called Explorer which used the SOAP API to Salesforce to show information about tables & columns. It would let your write/execute SOQL queries against your Salesforce data. Around the same time I moved from Windows to OSX as my primary home desktop. Explorer was so useful, i set about writing an OSX version, called SoqlX. 16 years on, here we still are. (Dave's original Explorer seems to have been victim to too many developer.salesforce.com rebrandings) |
Download
Starting with v3.4 SoqlXplorer requires Mojave or later (OSX v10.14). Download SoqlXplorer_v4.6.zip and give it a go.With the release of MacOS Monterey, v4.6 is likely to be the last release that supports MacOS 10.14.
SoqlXplorer is open source, see the project home page on Github, patches welcome!
Versions
v4.6, August 20, 2023
- Requires MacOS v10.14 or later.
- Fixed bug where the type field in SOSL results was not exported to CSV.
v4.5, August 9, 2023
- Requires MacOS v10.14 or later.
- Updated to Salesforce API v58.
v4.4, June 17, 2022
- Requires MacOS v10.14 or later.
- Improved performance of editing very large queries when syntax highlighting is on.
- Add preference setting to enable/disable the query auto-completions
- Updated to Salesforce API v55
v4.3, Nov 16, 2021
- Requires MacOS v10.14 or later.
- Fix bug where the login sheet doesn't show for some users.
v4.2, Oct 22, 2021
- Requires MacOS v10.14 or later.
- Login now uses the OAuth browser UI, for improved compatibility with SSO, 2FA etc.
- The column sizes in the query results now have much smarter default sizing.
- Updated for Salesforce.com API v53.
v4.1, Sept 5, 2021
- Requires OSX 10.14 or later.
- Bug fixes for SOQL highlighting / completions.
v4.0, Aug 18, 2021
- Requires OSX 10.14 or later.
- All new syntax highlighting and auto completions for SOQL and SOSL queries.
- Bug fixes for local sorting, handling of brackets in Apex and other minor fixes.
- Updated to Salesforce API v52.