SOQL Query Builder in VS Code

What is SOQL Query Builder in VS Code and How to use it?

In this blog post we’ll learn a newly launched feature to execute the soql query builder in VS Code. This is really a great and interactive tool play around with soql and manipulate them without going into developer console.

Thanks to Salesforce and VS Code to introduce the community with a VS Code extension and making our life easier. This is not just a simple query tool but have some tiny awesome features too.

We have SOQL Query Builder now which is a VS Code extension and can be installed easily with few clicks. The extension facilitates us with rich and interactive UI for designing and querying the Salesforce connected org data.

Tip: Keep in mind that you have authenticated your org from VS Code

The soql query builder lets you query within VS Code rather than going to dev console. It also provides the soql query that can be used in apex code. The most advanced feature is the query result can be exported as json and CSV. This is something that workbench and query editor doesn’t have.

How to install the SOQL Query Builder in VS Code

Visit the VS Code marketplace and click on install. This will ask you to open the VS Code. Once opened just click on the install button to let it install itself. It can take few seconds but that’s really quick. It is highly recommended to restart your VS Code after the extension is installed.

Let’s now configure the Extension

Authenticate your org and set up project in VS code. Once all good you’ll see a scripts folder in the main project directory

VS Code Dir

This is where we can use the new feature of designing and executing query. In case you don’t see those folders these can be created manually.

Now create a new file contact.soql. Make sure to put the extension name as “.soql”. Now double click to open the file with VS Code

You’ll see this screen

SOQL Query Builder in VS Code

Now to open the UI Query explorer.

Right click on the contact.soql and select “Open With”.

SOQL VS Code Option

Choose the “Soql Builder” Option and query builder will be presented as

SOQL VS Code

You can select your Object, fields and other query operators from UI. Once all done click on “Run Query” to execute the query and get the result.

Tip: In order to open the file with “Soql Builder”. Make it default opening for the file.

SOQL Query Builder Result

You have now the result which can be exported as json and csv from button on top right corner.

That’s all. Post your comments if you have any thoughts and questions on this query builder.

8 thoughts on “What is SOQL Query Builder in VS Code and How to use it?”

  1. Hi outstanding blog! Does running a blog similar to this require a great deal of work?
    I’ve absolutely no expertise in computer programming but I had been hoping to start
    my own blog soon. Anyhow, should you have any recommendations or tips for new blog owners please share.
    I know this is off topic however I just wanted to ask. Appreciate it!derma prime plus reviews

  2. Admiring the hard work you put into your blog and detailed information you provide.

    It’s awesome to come across a blog every once in a while that isn’t the same old rehashed information. Fantastic read!

    I’ve bookmarked your site and I’m including your RSS feeds to my
    Google account.

  3. We are a group of volunteers and starting a new scheme in our community.
    Your website offered us with valuable info to work on. You’ve
    done an impressive job and our whole community will
    be thankful to you.

  4. Howdy this is kind of of off topic but I was wanting
    to know if blogs use WYSIWYG editors or if
    you have to manually code with HTML. I’m starting a blog soon but have no coding expertise so I wanted to
    get advice from someone with experience. Any help would be enormously appreciated!

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top