Nexo SQL Studio
Everything you need to
work with Oracle in VS Code
From smart IntelliSense to live query execution and offline DDL export — Nexo SQL Studio brings professional Oracle tooling directly into your editor, no extra windows required.
Smart PL/SQL autocompletion that knows your schema
Get context-aware suggestions for Oracle packages, procedures, functions, types, and columns as you type. Nexo SQL Studio understands your database objects and surfaces the right completions at the right time — including package members, overloaded signatures, and user-defined types.
See documentation
Go-to-Definition across your entire PL/SQL codebase
Press Ctrl+Click (or F12) to jump straight to any procedure, function, type, or package body — across files and directories. Symbol search respects your configured search paths and resolves overloads correctly, even across schema boundaries.
Learn more
Run SQL and PL/SQL without leaving your editor
Execute queries with Ctrl+Enter, view results in a rich inline table, and inspect execution plans — all from within VS Code. Switch between multiple Oracle connections, set your current schema, and stream large result sets without freezing the UI.
Get started
A complete Oracle development toolkit
Everything from object browsing and offline DDL export to unit-test integration and custom colorization — purpose-built for Oracle developers who live in VS Code.
Browse your entire Oracle schema visually
Navigate tables, views, packages, procedures, functions, sequences, and synonyms from a dedicated sidebar panel. Expand any object to see its columns, parameters, or members — with one click to generate DDL or open the definition.
Offline DDL Export
Extract DDL for any Oracle object — even without a live connection — using cached metadata. Save and diff schema definitions alongside your code.
Syntax Highlighting
Full PL/SQL and SQL*Plus syntax colorization with support for .sql, .pks, .pkb, .prc, .fnc, .trg, and many more Oracle-specific extensions.
Run unit tests directly from VS Code
Discover, run, and navigate utPLSQL test suites from the VS Code Test Explorer. See pass/fail status inline, jump to failing assertions, and run individual tests or entire suites without switching windows.
Signature Help
See parameter hints for procedures and functions as you write calls, including overloaded signatures and IN/OUT mode annotations.
Connection Groups
Manage multiple Oracle connections per project, organize them into groups, and switch schemas on the fly without reconfiguring credentials.
Capabilities
Every tool Oracle developers need, right in VS Code
PL/SQL IntelliSense
Context-aware completions for packages, types, columns, and keywords — powered by live or cached schema metadata.
Symbol Navigation
Go-to-Definition and Workspace Symbol Search across your configured PL/SQL search paths.
Inline Query Execution
Run SQL/PLSQL with Ctrl+Enter and view results in a paginated table with export to CSV — no external tool needed.
Oracle DB Connection
Connect to Oracle 12c+ via thick client or JDBC, including Autonomous Database. Import connections from SQL Developer.
Object Tree Explorer
Browse schemas, tables, views, packages, and more from a sidebar panel with inline DDL generation.
Offline DDL Export
Extract DDL for Oracle objects into local files for comparison and offline navigation.
Syntax Highlighting
Full colorization for PL/SQL, SQL*Plus scripts, and all major Oracle file extensions out of the box.
utPLSQL Test Runner
Discover and run utPLSQL tests from the VS Code Test Explorer with inline pass/fail results and jump-to-failure.
Signature & Hover Help
Parameter hints for procedures and functions, plus hover documentation for packages, types, and built-ins.
Multi-Connection Support
Manage multiple Oracle connections and switch schemas without leaving VS Code or touching connection files.
VS Code Marketplace
Install in one click from the Extension Marketplace — works on Windows, macOS, and Linux with no extra setup.
Custom Snippets & Docs
Use built-in PL/SQL snippets or define your own. Generate documentation headers with configurable templates.
Platforms
Works on Windows, macOS & Linux
Install directly from the VS Code Marketplace — no extra configuration required on any operating system.
Windows
Windows 10 & 11
macOS
macOS 11+
Linux
Ubuntu, Fedora & more
Ready to upgrade your Oracle workflow?
Install Nexo SQL Studio from the VS Code Marketplace and start using professional Oracle tooling inside your editor today.