Products - SOQL Studio
The most comprehensive SOQL query tool you'll ever need!
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'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, even complexvalue types -- it’s all there.
The IDE-style interface lets you 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 your 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.
Current Version: v2021.1 Build 291 released on Monday, May 3, 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. 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 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).
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.
- Windows 7†, 8.x, 10 - 32/64 bit
- .Net Framework 4.7.2 or higher
- A Salesforce edition that supports the SOAP API, currently Enterprise Edition, Performance Edition, Unlimited Edition, or Developer Edition
- A Salesforce logon with permission to access the API