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, and 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, and Explorer was so
useful, i set about writing an OSX version, called SoqlX. 12 Years on, here we still are. (Dave's original explorer seems to have
been victim to too many developer.salesforce.com rebrandings)
With SoqlX you can explore the object & field schema details, build & run SOQL or SOSL queries, edit data, run apex code, it even do syntax highlighting on the query as you edit it along with a graphical schema explorer.
SoqlXplorer is open source, see the project home page on Github, patches welcome!
- New in v0.90, support for SOQL-R queries, queries that have child queries now show the magnifying glass icon and row count in the main query results. double click the magnifying glass to show the child query results in the 2nd query results view at the bottom of the window.
- right click on any row to have the option to open that row in the browser
- for queries that include the Id column, you can click on data cells to edit them and update salesforce.com
- open the Recent Queries List window from the menu to see your last 10 executed queries, click on any of them to copy their text to the SOQL window.
Syntax highlighting in action
Graphical schema explorer
- 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 right).
- 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.
- Easily run anoymous apex and see the results.
- Code is syntax highlighted, and will highlight the line when there's a compilation error.
- Also, support for Mojave's Dark Mode UI.
DownloadAs of v3.0, SoqlXplorer requires High Sierra or later (OSX v10.13). Download SoqlXplorer_v3.00.zip and give it a go.
v3.0, Nov 25, 2018
- Requires OSX 10.13 or later.
- Updated to Salesforce API v44.0
- Support for OSX Mojave Dark Mode
- Sytax highlighting, line numbers and error highlighting for apex code
- Fix for bug related to font size selection from apex tab