SoqlX

Jump To: Download | Running Queries | Explore Schema | Run Anonymous Apex | Detailed Help | Versions |

SoqlX is a OSX app for developers on the Salesforce.com platform, allowing you to run queries, edit data, and do other data related tasks, including:

  • Build & Run SOQL (including SOQL-R) and SOSL queries against your Salesforce data.
  • Save query results to CSV. Save queries for re-execution later.
  • See detailed metadata about all your Salesforce SObjects & fields, and how they're related.
  • Generate a detailed report about a particular Salesforce SObject.
  • Run anonymous Apex code, and see the debug output.
  • Supports OSX Mojave's Dark Mode.
  • SoqlX is open source, see the project home page on Github.

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


Anonymous Apex


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. 13 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.0 SoqlXplorer requires High Sierra or later (OSX v10.13). Download SoqlXplorer_v3.1.zip and give it a go.

SoqlXplorer is open source, see the project home page on Github, patches welcome!

Versions

v3.1, Jan 22, 2019
v3.0, Nov 25, 2018
View Full Version History