SoqlXplorer

DevAngel's AppExchange Explorer is an invaluable tool when working with the Salesforce.com API, but I've been recently chaffing that there's no OSX version, so I fixed that. It doesn't do everything the AppEx2 does yet, but it has the primary bits, explore the describes results, build & run SOQL queries, edit data, it even do syntax highlighting on the query as you edit it along with a graphical schema explorer.

• 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.

Download

As of v0.90, SoqlXplorer requires Leopard (OSX v10.5). Download SoqlXplorer_v1.60.zip and give it a go.

If you're still on Tiger, you can still download the last version that works on Tiger, download SoqlXplorer_v0.84.zip.

Release History

v1.6, Feb 21, 2012

• Updated to API v24 (aka Spring '12)

v1.5, Oct 8, 2011

• Updated to API v23 (aka Winter '12)
• Apex debug log settings are now remembered between runs

v1.4, Aug 11, 2011

• Fixed a bug where the apex window was using API v20 instead of API v22.
• Fixed a bug where the recent and details window would show as 'ghosts' in exposé if they were not shown.
• Thanks to @qbnrox for the bug reports.

v1.3, July 26, 2011

• Updated for API v22.0.
• Fix for an intermittent crash when the query results are being rendered.

v1.2, Feb 7, 2011

• Updated for API v21.0 (aka Spring'11)

v1.1, Oct 18, 2010

• New Apex tab allows for running of anonymous apex.

V1.00, Oct 4, 2010

• Updated to API v20.0.

v0.99, July 26, 2010

Updated to API v19.0.

v0.98, Feb 5, 2010

• Updated to API v18.0 (if your salesforce.com instance hasn't yet been upgraded to v18, it will gracefully fallback to v17).
• The order of fields in the results table now more closely matches the order of fields in your query.
• Fixed a bug that would prevent v18 aggregate query results from displaying properly.

v0.97, Jan 8, 2010

• Updated to API v17.0

v0.96, March 30, 2009

• Object/Field filtering, enter a partial object or field name, and watch the object list shrink, and the matching fields get highlighted.
• Schema Relationship details are now shown on the details panel, and in the schema reports.
• The Schema view now shows foreign key fields, so there's more useful info on objects that are related to the selected object.
• UI Cleanup, buttons moved to button bar, new button to toggle the recent query list.

v0.95, Feb 22, 2009

• Updated to API v15.0
• Single row and bulk delete rows from a query result.
• Open records in the browser.
• Count() queries now correctly show the result.

v0.94 Oct 12, 2008

• Updated to API v14.0.

v0.93 July 24, 2008

• Updated CSV saving to remove some spacing to make the files more Excel friendly.

v0.92 July 9, 2008

• Updated to API v13.0, now includes additional CJO properties on field.
• Can now save the current query results to a CSV file. (for large result sets you get the option of the currently loaded rows, or all rows)

v0.90 Feb 3, 2008

• Now Requires Leopard.
• Support for child aggregates in SOQL-R queries, via the 2nd lower query results pane.
• Recent Queries List window shows last 10 executed queries, click on one of them to copy the query to the SOQL box.
• SObject list view moved to left and uses the standard SourceList UI style to better match the Leopard UI style, and other UI tweaks.
• Can now right click in query results to open the selected Id in the browser.

v0.84 June 25, 2007

• Minor update to fix compatibility issues with PowerPC Macs running 10.4.x and Intel Macs running the WWDC leopard beta.

v0.83 April 19, 2007

• You can now edit data inline in the query results, simply double click the cell and update its contents, and it'll update that row in Salesforce.com

v0.82 March 28, 2007

• double clicking on a cell will let you copy its value.

v0.81 Feb 18, 2007

• Reworked login to manage multiple keychain entries per server (ala Trapdoor)
• Added support for the QueryAll call.

v0.80 Jan 21, 2007

• Can now get a schema report (combination of the graphical view + a tabular report of fields and their properties) by right clicking on an SObject in the righthand list.
• Schema report can be printed out, or saved directly to a PDF file.
• Details drawer has been replaced by a new details window, and has been updated with the new object and field properties for API 8.0.
• Moved to API v8.0.

v0.71 Nov 19, 2006

• Schema explorer pane will now auto turn into a scroll view with big schemas
• Schema explorer pane will now layout all items so none overlap.
• Improved performance of schema drawing, and fixed memory leak, and overzealous window redrawing.

v0.70 Nov 17, 2006

• Brand new iLife style UI, not so much wasted space.
• Graphical schema explorer, wander around a graphical representation of your schema.
• Print support for the schema explorer (includes saving as PDF).

v0.63 Oct 30, 2006

• Added keychain support for managing your login credentials.
• Added a splitter view to the UI.

v0.62 Oct 16, 2006

• Supports connections to Sandbox edition, as well as any number of additional servers (add new servers via the preferences)
• Will now automatically check for updates and give you the option to update. (Thanks to Sparkle)
• You can open your current Salesforce session in a browser (from the menu)

v0.6 Sept 26, 2006

• Syntax highlighting and field / object validation added, invalid field or object names will appear with a dotted red line under them as you edit the query.
• Fixed a couple of UI layout problems (the progress bar would appear in the wrong place if you resized the window).
• Added a progress spinner during login so you can tell you actually clicked the login button.

v0.5 Sept 4, 2006

• First release, do object and field exploring, edit/run queries and displays the results.