Getting Started

Nexo SQL Studio is a Visual Studio Code extension that brings first-class Oracle / PL/SQL support directly into your editor. You get autocompletion, go-to-definition, formatting, query execution, object browsing, deployments, and more — all without leaving VS Code.

Requirements

• Visual Studio Code or a compatible editor that supports VS Code extensions
• Network access and credentials for an Oracle Database

Oracle Instant Client is not required. Nexo SQL Studio uses the bundled node-oracledb Thin mode by default, including for live connections. Oracle client libraries are only relevant if you intentionally configure an Oracle workflow that depends on Thick mode or operating-system Oracle authentication.

Installation

1. Open VS Code and go to the Extensions panel (Ctrl+Shift+X).
2. Search for Nexo SQL Studio.
3. Click Install.

Or install from the marketplace directly:

• VS Code Marketplace for Visual Studio Code
• Open VSX Registry for Cursor, VSCodium, Gitpod, and other Open VSX-compatible editors

You can also install from the command palette or terminal:

ext install nexosqlstudio.nexo-sql-studio

Create Your First Connection

After installation, open the Connections Explorer from the Activity Bar.

1. Click Add Connection in the Connections Explorer toolbar.
2. Enter a unique connection name.
3. Keep Specify by fields selected and enter the database host, port, and service name. Port 1521 is the common default, but use the value provided by your database administrator.
4. Enter your Oracle username and password. Leave Save password enabled if you want Nexo to store it in VS Code SecretStorage.
5. Click Test to verify the unsaved values.
6. Click Save, then connect from the saved connection.

Use Raw connect string when you already have an Easy Connect string, TNS alias, or Oracle Net descriptor. See Connections for SID, TCPS, wallets, external authentication, privileges, and safety settings.

If your connections already exist elsewhere, see Importing and Exporting Connections. SQL Developer passwords cannot be imported.

Browse Your Schema

Connect and expand the connection in the explorer. Nexo groups the available schema objects by type. Expand a type such as Tables, Views, or Packages, then select or right-click an object to inspect its details and available actions.

Opening Your First Worksheet

Right-click a connection and choose Open SQL Worksheet, or run the worksheet command from the Command Palette.

Nexo SQL Studio: Open Worksheet

Type a statement, select the connection when prompted, and run the current statement or selection. Results appear in the worksheet results view.

Recommended Next Steps

• Learn how to browse your schema with the Object Tree
• Organise and protect database access with Connections
• Bring existing profiles into Nexo with Importing and Exporting Connections
• Run and manage Deployments
• Speed up writing with Snippets
• Understand Autocompletion and IntelliSense