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_v0.90.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

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.