Sidebar

Mobile navigation sidebar

SQL client

SQL Client for Oracle Database in VS Code

Oracle SQL and PL/SQL client for VS Code. Connect with service names, SIDs, TNS or wallets, run SQL worksheets and explore Nexo's advanced Oracle tools.

Before connecting

Choose structured fields or a raw connect string. Use the supplied service name or SID. Oracle Thin mode is the default: Oracle Instant Client is not required for ordinary connections. TNS, TCPS, wallets and external authentication have additional requirements.

Run your first query

SELECT 'Connected' AS status FROM dual;

Troubleshooting

Check the selected engine, host or file path, database name, account permissions and TLS requirements. Keep the connection editor open while correcting failed tests. Include the engine, server version, extension version and a sanitized error when requesting support; never include passwords or wallet secrets.

Advanced Oracle development

Keep the depth your Oracle projects need: service names and SIDs, Easy Connect, TNS, TCPS and wallets, alongside PL/SQL intelligence, debugging, utPLSQL and APEX/ORDS workflows. Advanced features have their own plan and compatibility requirements.

Hosted databases: use the engine's connection settings. Supabase uses PostgreSQL; Oracle Cloud and Autonomous Database use Oracle. Poolers, wallets, authentication and provider-specific services need their own configuration and compatibility checks.

Supported databases

Feature availability

Database support does not imply identical features. Connections and SQL worksheets are the starting point; editing, DDL, modeling, transfers, administration and AI operations depend on the engine and workflow. Check the installed version and the relevant guide before relying on an advanced operation.

Oracle Database
Free
+
Pro
Feature
Connections, SQL worksheets and query results
Free
Commit and rollback
Free
Paged SQL results
Free
Oracle Net, TCPS and wallets
Free
PL/SQL debugger and utPLSQL
Pro
APEX and ORDS
Pro
Modeling, DDL, imports/exports and AI/MCP
Check engine guide

Supported databases

Supported databases

Feature availability

Database support does not imply identical features. Connections and SQL worksheets are the starting point; editing, DDL, modeling, transfers, administration and AI operations depend on the engine and workflow. Check the installed version and the relevant guide before relying on an advanced operation.