Connections

Nexo SQL Studio’s Connections Explorer is the command centre for every Oracle database you work with. All connections are stored securely and can be organised into groups.

Adding a Connection

Open the Connections Explorer from the Activity Bar (database icon), then click ➕ Add Connection.

Fill in the connection form:

Field	Example
Name	Production DB
Host	db.example.com
Port	1521
Service / SID	ORCLPDB1
Username	hr
Password	••••••••

Connection Groups

You can organise connections into named groups (e.g. Dev, Staging, Production). Right-click any group to rename, reorder, or delete it.

Importing from SQL Developer

If you already use Oracle SQL Developer, Nexo SQL Studio can read your existing connections.

1. Open the command palette (Ctrl+Shift+P).
2. Run Nexo SQL Studio: Import Connections.
3. Select your SQL Developer connections.xml file.

All connections are imported instantly — no re-typing required.

Folder-Level Connection Overrides

Working across multiple workspace folders with different schemas? You can override which connection is active for a given workspace folder:

1. Right-click a connection and choose Set as Folder Default.
2. Choose the workspace folder it should apply to.

The override is persisted in your VS Code workspace settings.

Connection Security

• Passwords are stored in the VS Code SecretStorage (OS keychain on macOS/Windows).
• Connection metadata (host, port, service) is stored in your VS Code settings or workspace settings — never in plain text alongside passwords.

Export & Import

To share connection metadata without passwords, use Export Connections from the context menu. The exported file is a JSON document that can be imported on another workstation.