Products - SOQL Studio
The industry-leading professional SOQL query tool.
SOQL Studio enhances developer and administrator productivity through its unmatched depth and breadth of features. The IDE-style interface lets you define connections to multiple orgs and explore all those orgs' schemas in detail. The advanced SOQL editor allows you to work with multiple queries simultaneously and view query results in either a hierarchical style or as a flattened, relational result set. Annotate queries with single or multi-line comments and save them for reuse later.
SOQL Studio supports multiple options for saving query results. Copy/Paste selected bits of your results or export the full results in Excel, CSV, XML or custom text format, even if your query includes data from child objects.
Current Version: v2021.2 Build 292 released on Monday, August 16, 2021
SOQL Studio provides a rich, satisfying user experience thanks to it's long list of features and capabilities:
- Query Production, Sandbox, and DeveloperEdition organizations
- Connect to and query different orgs at the same time within a single instance of SOQL Studio
- Connect using OAuth or Username/Password with or without Two Factor Authentication
- Tabbed SOQL Editors provide complete syntax highlighting and enable work on multiple queries simultaneously. Supports the full SOQL syntax and features including polymorphic and compound fields
- Annotate queries with single or multi-line comments. Save queries for reuse later.
- Configurable SOQL editor displays results either in a sub-tab or resizeable pane beneath the SOQL query pane, instantly switch between the two view modes
- Display query results either hierarchically or flattened into a more traditional relational result set. Format data using windows or salesforce formatting
- Filter and sort query results right within the results grid
- Export query results with the Export Wizard or Quick Export or select and copy data directly from the results grid
- Full range of application configuration options and settings including support for running behind a proxy server
- Explore an organization's database schema. Filter the org to find specific items. Drill-down into relationship fields. View detailed organization, sobject, and field properties
- Get SOQL performance feedback at the click of a button with SOQL Explain support
- Query Tooling API objects. Use our Advanced Visualization capability to navigate complexvalue data
- Integrated, detailed help file and unlimited support via the SOQL Studio support forum
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 either on a sub-tab within the same editor tab or in a split-pane directly beneath the SOQL query pane, Either way, the SOQL query and results are kept together on the same editor tab, 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.
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.
Our Advanced Visualization technology for complexvalue fields in Tooling objects makes navigating results easy.
SOQL Studio supports multiple options for saving your data including the Export Wizard, Quick Export and Copy/Paste.
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 an Org's Schema and its Properties
SOQL Studio makes exploring the schema of an org very easy. All the Orgs defined to SOQL Studio and their associated sobjects and fields are displayed in the Organizations tool window in name order (the default) or name order grouped by type. The Organizations tool window supports filtering to make finding sobjects and fields a snap and unlimited, multi-level drill down into relationship fields.
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. Look-up all the record types or relationships of an Sobject and even get detailed information about them by simply expanding the item of interested. Most properties also 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 a context menu that includes actions such as View in Salesforce, Generate Browse Query, Create New record in Salesforce, and Refresh. The actions available depend upon the item clicked and what that item supports. 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).
SOQL Studio supports OAuth 2.0 as an authentication mechanism for connecting to Salesforce and it's our recommended method. Username/Password is also supported. With the Username/Password mechanism, SOQL Studio immediately encrypts the password to keep it safe. Should you chooose to save your logon password as part of an org defintion, the encrypted version gets saved 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.