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. You can explore the object & field describes results, build & run SOQL 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.

• 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 v1.8, SoqlXplorer requires Lion (OSX v10.7). Download SoqlXplorer_v1.92.zip and give it a go.

If you're still on Snow Leopard (10.6), you can still download the latest version that works on SL, download SoqlXplorer_v1.70.zip.
If you're still on Leopard (10.5), you can still download the last version that works on Leopard, download SoqlXplorer_v1.60.zip.
If you're still on Tiger (10.4), you can still download the last version that works on Tiger, download SoqlXplorer_v0.84.zip.

Release History

v1.92, Feb 5, 2013

• Requires OSX 10.7 or later.
• Update for Salesforce API v27.0 (aka Spring '13)
• Fixed crash where "Check for updates" with no window open would cause a crash.

v1.91, Dec 22, 2012

• Requires OSX 10.7 or later.
• Fixed issue with login server names missing for clean installs.
• Reverted details/recents panel windows to previous style where they are not attached to the main window to stop them getting hidden under the main window.

v1.9, Oct 16, 2012

• Requires OSX 10.7 or later.
• Fixed crash when doing SOQL-R queries on a 64bit machine.
• Fixed bug with version fallback not working.
• Fixed layout issue with schema report window when its resized.

v1.8, Oct 8, 2012

• Requires OSX 10.7 or later.
• Multiple login/window support, just goto File->Login and have as many windows/logins open at once as you'd like.
• Can now run searches as well as queries, just type your sosl search into the query box just like you would a soql query.
• Updated to newer version of Sparkle, future updates will be cryptographically verified by the updater.
• Updated to API v26.
• Make less API calls on the main thread, less beachballs.

v1.7, June 4, 2012

• requires OSX 10.6 or later.
• Updated to API v25 (aka Summer '12).
• recents and details window now can be closed via escape key.
• Username and instance shows in the window title.
• Fixed a number of memory leaks.
• Now open source, fork me on github.

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.