Oracle SQL Developer Extension for VS Code

This quick, step-by-step guide shows how easy it is to connect to an Oracle Cloud Database from VS Code. It covers the basics; subsequent articles will explore more advanced features. For full details, see the official extension documentation here.

Installing the Extension

The first step, obviously, is to install the extension. And it is pretty easy. Go to Extensions tab of VS Code and search for “Oracle SQL Developer Extension for VSCode” and install it.

Press enter or click to view image in full size

Create Connection

The next step is to create the connection to a DB. You can choose between various connection options. I will be showing how to use the Cloud Wallet option.

Press enter or click to view image in full size

Click on Create Connection and you will be prompted to provide the details as shown above.

Configure Connection Settings and Cloud Wallet

Confguring the connection setting is simple and straightforward. Here are the steps involved.

Download the wallet from OCI console
Change the Connection type to “Cloud Wallet”
Click on “Choose File” and select the Wallet Zip file
Select the Service (this will be available after you select the Wallet zip file)

Press enter or click to view image in full size

Make sure to alos provide the following:

Connection Name
Username
Password
Optionally choose to save password

Press enter or click to view image in full size

Click the “Test” button to make sure you are able to connect to your database. You should see a success message in the bottom right corner of VSCode.

Once connected you will notice the Database in the left panel.

Create a new SQL Worksheet

To the right of the connection name, you will notice few options. One of them is Open the SQL Worksheet and this is where you will write and execute your SQL statements.

Press enter or click to view image in full size

You can also use the keyword Ctrl + Shift + W to create a new SQL Worksheet.

SQL Worksheet Features

Autocomplete is enabled and available. When you start typing the object name, you will notice the objects with similar names available for easy selection. This definitely speeds up the development time.

Press enter or click to view image in full size

Once you execute the statement, you will notice the restults at the bottom (just like SQL Developer). Ctrl + Enter keyboard shortcut works to execute SQL statement.

Press enter or click to view image in full size

One of the best features I like is the SQL History tab. This allows you to view SQL statements executed previously. Double clicking on one of the history record will copy that statement to the editor.

Conclusion

Oralce has made is extremely easy for you to connect to your Oracle Cloud DBs. And as many of us uses VS Code, it is now even more easier to use the same editor with Oracle DB. You get to use the same Code Editor for all your programming needs.

Oracle SQL Developer Extension for VS Code

Comments

oracle database

More from this blog

Latest Oracle EPM REST APIs: Part 1 Dimension Details

Visualize Oracle EPM Data in Python Jupyter Notebook

Oracle EPM October 2025 Updates

Create Reconciliations in Oracle Account Reconciliation using Data Pipeline

Installing the Extension

Create Connection

Configure Connection Settings and Cloud Wallet

Create a new SQL Worksheet

SQL Worksheet Features

Conclusion

Command Palette

Comments

oracle database

More from this blog

Installing the Extension

Create Connection

Configure Connection Settings and Cloud Wallet

Create a new SQL Worksheet

SQL Worksheet Features

Conclusion