SOQL Studio is a premium query tool for the force.com platform with a depth and breadth of features not found anywhere else. We developed this tool because force.com developers and administrators needed a better way to query, visualize and extract their org’s data. You're going to be blown away by the capabilities of this software. You'll be able to query a salesforce.com org and actually see every data point returned -- aggregates, compound fields, related records, multi-level child-to-parent fields -- it’s all there.
Developers will appreciate the IDE-style user interface. Work with multiple queries at the same time. Annotate queries with single or multi-line comments. Save queries for reuse later. Copy/Paste selected bits of you results or export the full results of your SOQL query in Excel, CSV, XML or custom text format, even if your query includes data from child objects. Try doing that with the force.com IDE, Developer Console, Workbench, or Data Loader.
Key Features and Capabilities
Full-Featured Query Editor
SOQL Studio's query editor provides the capabilities and features you'd expect, including some features never before available to Salesforce developers and admins. Full syntax highlighting, configurable case-correction, delimiter auto-complete, single line and multi-line comments, execute selection, cut/copy/paste, ruler, column guides, line numbers, current line highlighting and more. Best of all, you're not limited to a single editor. You can have as many open editors as you want, easily switch between them, and save your queries for reuse later. You can also have multiple SOQL queries in a single editor, select the one you want to run and click "Execute Selection" to run just that query. Click the image to see this in action.
Results are presented on a sub-tab within the same editor tab keeping everything together, essential when you have multiple open editors. Error and other messages pertaining to a query are presented separately in the Messages tool window so you can see them while working on your query. The Messages tool window can be configured to automatically filter its contents to only the active Editor tab.
View query results your way
You choose how the query results are presented -- as a standard salesforce.com query result or in traditional relational database format. The choice is yours. And you can change how the results are rendered without re-executing your SOQL query. Regardless of how you choose to visualize your data, you can still export it or just copy/paste selected bits of it into an application of your choice. SOQL Studio is all about making the life of Salesforce developers and administrators a little bit easier.
SOQL Studio also gives you the ability to view or edit a record directly in Salesforce. Right-click on any Id in the results and select the edit or view menu option to open the record in Salesforce. No need to manually logon to Salesforce's UI, SOQL Studio takes care of that for you using the same credentials that were used to run the query.
The Export Wizard guides you through the task of configuring and exporting your query results in a file formatted to fit your needs. SOQL Studio supports exporting to Text (TXT, CSV), XML and Excel (XLS, XLSX, and CSV) file formats. And exports are blazingly fast. Even very large result sets can be exported in under a minute while most happen nearly instantaneously.
Within each format, there are options to help you get the exported data just as your need it. Once you've set the target format and options, you decide which columns to include or exclude from the export. SOQL Studio's Export Wizard gives you the flexibility to export only what you need. It even shows you each column's properties to help you configure the export.
Quick Export uses the application's default Export options, which are completely configurable in Options, to bypass the Wizard dialog and quickly export the entire result set. It's a virtual one-click export. The only requirement is that you provide a name for the exported data file.
Explore your Org and its Properties
SOQL Studio makes exploring the schema of your org very easy. The Orgs and associated sobjects are displayed in the Organizations tool window. You have the option to display them ungrouped in name order or grouped by type. Within each group, sobjects are displayed in name order. Select any node in the Organizations tool window -- an Sobject, Field, or the Org itself -- to view detailed properties about it in the Properties tool window. You can look-up all the record types or relationships of an Sobject, and even get detailed information about them by simply expanding the item you are interested in. Most properties include a detailed description at the bottom of the window
That's not all the Organizations tool window is for, though. Right-click on an org or sobject to get it's context menu that includes actions such as Create New record in Salesforce, Generate Browse Query, View in Salesforce, and Refresh. The actions available depend on the item clicked and if that item supports the action. Just another way SOQL Studio saves admins and developers time.
Managing Organization Connections
SOQL Studio makes it easy to configure connections to your production, sandbox, and Developer Edition orgs using the Manage Organizations dialog. Each org definition has its own settings independent from the others giving you the flexibility needed to connect to different environments based on each one's requirements, including the ability to specify a custom API login domain (not shown).
Passwords are collected and stored in an encrypted format. Should you choose to save your logon password as part of an org defintion, SOQL Studio saves only the encrypted version to disk. Should you decide not to save you password, SOQL Studio will prompt you to provide it each time a new connection to Salesforce is established.
SOQL Studio also has native support for Salesforce's two-factor authentication. Simply indicate that the logon requires TFA and SOQL Studio will prompt you to enter the authentication code when it connects to Salesforce.
Extensive Configuration Options
SOQL Studio provides extensive configuration options that allow you customize the application's appearance and behavior to your preferences. Options are grouped into tabs by function to help you easily find and configure the various aspects of SOQL Studio. For example, the settings on the Export tab define the defaults used by the Export Wizard and govern the Quick Export process. The Advanced tab lets you configure SOQL Studio to work with your proxy server. Regardless of how you configure the app, many options can be overriden on the fly giving you the ultimate in flexibility.