Nexo SQL Studio

Everything you need to
work with Oracle in VS Code

From Free core editing to Pro delivery workflows, Nexo SQL Studio brings Oracle tooling directly into your editor, no extra windows required. Use connections, worksheets, online cross-schema autocomplete, snippets, and standard results without login; activate Pro for offline projects, validation, deployments, AI/MCP, and advanced operations.

Install for free

Watch more videos Explore the gallery

Free or Pro

Start with the core workflow, grow into one complete Pro license

Free never requires login. Pro is one all-inclusive license: every professional capability unlocks together, with no per-feature tiers.

Free

Daily Oracle editing

Connections, object browsing, source opening, online cross-schema autocomplete, worksheets, transactions, DBMS output, standard result grids, snippets, and object editing with full IntelliSense support.

No account or license required.

Pro license

Professional database workflows

Offline autocomplete and object generation, live validation, DB Manager, comparison, deployments, remote files, Docker, AI/MCP, Data Modeler, Query Builder, SQL Load Tester, gallery results, locking, tests, debugging, imports, APEX/ORDS, and advanced results.

Try Pro for free, no credit card required. One all-inclusive license includes every Pro feature.

Learn more

Pro license · Early preview

Design and evolve Oracle data models visually

Build diagrams with hundreds of tables, choose the auto layout that fits your model, and synchronize changes in both directions. Nexo AI MCP lets Claude, Codex, and other AI tools edit the model while you watch changes appear in real time.

Explore the data modeler

Nexo data modeler showing a large Oracle schema diagram in VS Code.

IntelliSense

Smart PL/SQL autocompletion that knows your schema

Get cross-schema suggestions for Oracle packages, procedures, functions, types, and columns while editing online database code in Free. Pro adds the same language intelligence to offline files and projects.

See documentation

Code editor with autocomplete suggestions

Navigation

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

Query Execution

Run SQL and PL/SQL without leaving your editor

Execute queries with Ctrl+Enter and view results in a standard paginated table from within VS Code. Pro adds gallery results, advanced result workflows, and professional multi-connection operations.

Get started

Full Feature Set

A complete Oracle development toolkit

Free covers the daily editor, connection tree, worksheets, snippets, object browsing, and standard results. Pro adds offline project generation, delivery, testing, administration, and AI/MCP workflows.

Object Explorer

Browse your 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 and open the definition for editing.

Offline DDL & project generation (Pro)

Generate and refresh local Oracle object projects from metadata, then 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.

utPLSQL (Pro)

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.

Local Oracle environments (Pro)

Create and manage Oracle development databases locally with Docker, including APEX and ORDS setup from inside VS Code.

Capabilities

Every tool Oracle developers need, right in VS Code

AI and professional workflows

AI assistants and agent workflows — any MCP-compatible tool (Pro)

Use Nexo AI Agent and skills, or connect any MCP-compatible AI client you choose. Nexo exposes an open MCP integration surface while the companion enforces approved Oracle access.

MCP and MCP Companion (Pro)

Drive approved Oracle metadata, query, compilation, deployment, API, model, and debugging workflows from compatible AI clients through Nexo MCP.

Fine-grained MCP permissions per connection (Pro)

Allow or deny MCP read and write access per connection, with separate safeguards for delete-data and drop-object operations.

Confirmation policies for sensitive MCP operations (Pro)

Configure confirmation for reads, writes, deletes, drops, offline compiles, and object collisions before the companion proceeds.

AI-assisted PL/SQL debugging (Pro)

Start and control PL/SQL debug sessions through the companion with breakpoints, stepping, watches, stack frames, and output.

AI SQL optimizer (Pro)

Use an available language model or local optimizer to propose query rewrites, then validate explain plans, execution results, row counts, hashes, and iterations.

Data Modeler (Pro)

Create, validate, edit, and export structured Oracle data models as workspace files with AI-compatible workflows.

Query Builder (Pro)

Compose SELECT statements visually from tables, joins, filters, grouping, sorting, and selected columns, then send the generated SQL to a worksheet.

SQL Load Tester (Pro)

Run repeatable SQL workloads against Oracle connections with configurable concurrency, duration, pacing, and result summaries for practical load checks.

Integrated utPLSQL tests (Pro)

Discover and run utPLSQL suites from the VS Code Test Explorer with inline pass/fail results and jump-to-failure navigation.

PL/SQL debugging (Pro)

Attach VS Code debugging to Oracle JDWP, set breakpoints, step through code, inspect variables, watches, call stacks, and output.

Core Oracle workflow

SQL and PL/SQL editing

Edit SQL, PL/SQL, SQL*Plus scripts, packages, procedures, functions, triggers, and other Oracle source files directly in VS Code.

PL/SQL IntelliSense

Free provides context-aware online completions for packages, types, columns, keywords, and cross-schema database objects; Pro adds offline project intelligence.

Syntax highlighting and formatting

Colorize Oracle SQL and PL/SQL, format source with Oracle-aware rules, and work with the major Oracle file extensions out of the box.

Symbols, navigation, and go-to-definition

Move through packages, procedures, functions, types, declarations, and definitions with symbol search, F12, and Ctrl+Click.

Built-in and custom snippets

Use ready-made PL/SQL snippets, define your own templates, and generate documentation headers with configurable settings.

Connection tree and object browsing

Browse schemas, tables, views, packages, procedures, functions, sequences, synonyms, and more from the Connections Explorer.

Online cross-schema autocomplete

Get live Oracle metadata suggestions across schemas while editing connected database code, with no artificial schema limitation.

Object editing with full IntelliSense support

Open an object source, edit it with Oracle-aware language support, and apply an individual object directly to the database.

Oracle connections and SQL Developer import

Connect to Oracle databases, including Autonomous Database workflows, and import existing SQL Developer connections into Nexo.

Connection groups and schema switching

Organize connections into project groups and switch between database contexts without leaving the editor.

Worksheets and results

Worksheets and SQL/PLSQL execution

Run SQL queries and PL/SQL blocks from worksheets with familiar VS Code commands and keep the execution context beside your code.

Transactions and DBMS_OUTPUT

Control commits and rollbacks, inspect DBMS_OUTPUT, and keep database execution feedback in the worksheet workflow.

Pagination and standard result grids

Review query results in a responsive paginated grid, fetch additional rows when needed, and export standard results.

SQL Results gallery (Pro)

Switch professional result sets into a visual gallery for image-heavy or media-oriented data while keeping the standard grid available.

Multi-connection workflows (Pro)

Run and compare work across multiple Oracle connections from one workspace without duplicating projects or switching tools.

Edit simple query results directly

Run a simple query, click a result cell, edit the value directly in SQL Results, and save it without opening a separate data editor.

BLOB and CLOB tools (Pro)

Inspect, open, export, and work with large Oracle text and binary values from the results workflow.

Query history and result export

Keep useful SQL execution history and move worksheet results into practical formats for review or handoff.

Offline development and validation

Open and edit offline SQL/PLSQL files

Keep local Oracle source files in your workspace and edit them in Free; Pro adds Nexo language intelligence for offline projects.

Offline project autocomplete (Pro)

Get Nexo autocomplete and language assistance for offline files and projects, including files obtained from third-party tools.

Live offline validation and compiler diagnostics (Pro)

Validate offline SQL and PL/SQL while you type, surface diagnostics before a database compile, and run professional compile workflows before delivery.

Offline object and project generation (Pro)

Generate local Oracle object projects from database metadata and synchronize source files with connected schemas.

Database and DDL comparison (Pro)

Compare schemas, DDL, and object changes to understand drift and prepare controlled synchronization work.

Batch object changes and synchronization (Pro)

Review and coordinate multiple object changes through repeatable offline project and database synchronization workflows.

Delivery and database operations

DB Manager and administration (Pro)

Inspect and operate Oracle sessions, storage, parameters, pools, access controls, scheduler resources, and other database administration areas.

Deployments, migrations, and backups (Pro)

Prepare repeatable delivery workflows for database changes, migrations, deployment targets, and recoverable backups.

Remote file explorer — SFTP, FTPS, and S3 (Pro)

Browse and synchronize remote project files through SFTP, FTPS, and S3-compatible storage from inside VS Code.

Docker and local Oracle environments (Pro)

Create and manage local Oracle development environments with Docker, including APEX and ORDS setup workflows.

Object locking and advanced maintenance (Pro)

Protect development schemas, review object history, detect collisions, and manage advanced object maintenance operations.

API Collections (Pro)

Organize and execute saved API requests with workspace variables, environments, and controlled MCP access policies.

Advanced parallel data imports and exports (Pro)

Build reusable transfers with concurrent items, reader sessions, conversion workers, batching, split files, row-order preservation, and guided import/export workflows.

APEX and ORDS workflows (Pro)

Validate, export, import, and manage Oracle APEX and ORDS workflows from the same development environment.

Portable packs (Pro)

Package project and database workflow assets for controlled sharing, handoff, and repeatable delivery.

Double-click Nexo portable files (Pro)

Register .nexomodel, .nexoconn, .nexosnip, .nexodeploy, .nexoapi, .nexodataload, and .nexopack with the operating system to open the matching Nexo workflow by double-clicking.

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

x64 and Arm64

macOS

macOS 11+

Intel x64 and Apple silicon

Linux

Ubuntu, Fedora & more