Sidebar

Mobile navigation sidebar

Free plan

Oracle SQL & PL/SQL development inside VS Code AI PL/SQL development

Nexo SQL Studio is an Oracle Database focused IDE · Free to install · No account required for core features. Start free and upgrade to a Pro plan when you need advanced workflows for offline development, validation, delivery, AI/MCP, and administration.

See Nexo SQL features

AI PL/SQL

AI mcp PL/SQL development

Offline dev

Offline dev and version control

Debug / UT

Step debugger, UTPLSQL unit testing

Apex / ORDS

Apex and REST Data Services support

Overview

What is Nexo SQL Studio?

Nexo SQL Studio is a VS Code extension for Oracle SQL and PL/SQL development. It brings schema exploration, worksheets, IntelliSense, formatting, offline DDL, deployments, testing, and AI-assisted workflows into the editor you already use.

Oracle work inside VS Code

Browse schemas, open worksheets, run SQL, inspect results, and edit database objects without switching tools.

Code-aware PL/SQL tooling

Use autocompletion, go to definition, snippets, formatting, diagnostics, and offline source files in one workspace.

Ready for AI workflows

Expose approved database actions through MCP so assistants can help with metadata, queries, compilation, and delivery tasks.

Free plan and Pro

Start free. Upgrade to Pro when you need advanced workflows.

Get Nexo SQL Studio free. Free to install · No account required for core features.

Free plan

The core Oracle workflow

Connect, explore, write, run, and edit database objects with the everyday tools you need in VS Code.

  • Connections, worksheets, and snippets
  • Online cross-schema autocomplete
  • Object browsing and editing with full IntelliSense support
  • Standard SQL result grids, direct editing for simple query results, and transactions

Nexo SQL Studio Pro

AI/MCP, advanced development and delivery

Start with AI/MCP, then add offline intelligence, validation, administration, delivery, testing, data modeling, and professional database workflows when you need them.

  • AI/MCP, SQL optimization, agent workflows, and the independently validated MCP companion
  • Offline autocomplete, live validation, offline object projects, generation, and synchronization
  • DB Manager, Docker/local Oracle environments, remote file explorer and synchronization (SFTP, FTPS, and S3-compatible storage), and advanced object maintenance
  • Deployments, migrations, backups, database comparison, object locking, object history and compare, batch changes, and repeatable delivery
  • Data Modeler, gallery and advanced results, multi-connection workflows, BLOB tools, metadata caching, API Collections, data imports/exports, APEX/ORDS, utPLSQL, debugging, and portable packs
  • SQL Load Tester for repeatable Oracle workload runs
  • Query Builder for visual query design and generated SQL

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.
Feature set

Built for daily Oracle development

Everything you need to move from exploration to delivery without leaving VS Code.

Autocompletion

Smart Code Completion

Autocomplete suggestions in VS Code

Suggests package members and context-aware symbols as you type Oracle SQL and PL/SQL — IntelliSense-powered so you stay in flow without context switching.

Go to Definition

Jump between declarations, package specs, and bodies with a single keystroke. Works across files in any search path.

Code Formatting

Keeps scripts readable and consistent for teams working across large Oracle database codebases.

Query Results

Interactive Results Panel

Query results grid in VS Code

Run statements and inspect result tabs with filtering, sorting, pagination, export, gallery view for BLOBs, and detailed cell previews — all without leaving VS Code.

Offline DDL Export

Export database objects into local files quickly so you can work offline and track every change in Git.

One-click Oracle dev environments

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

Workflow

From live database to offline files

  1. 01

    Connect

    Reuse Oracle SQL Developer connection metadata and open a SQL worksheet in seconds.

  2. 02

    Browse

    Inspect folders, object types, and object names, then jump directly into definitions.

  3. 03

    Edit

    Apply a single object edit from the workspace in Free; Pro adds live validation, compilation, and advanced maintenance.

  4. 04

    Extend with Pro

    Activate the all-inclusive Pro license for offline projects, deployments, comparison, debugging, AI/MCP, and data tools.

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

x64 and Arm64

Ship PL/SQL changes with less friction

Start with the Free plan: install Nexo SQL Studio at no cost and use the core Oracle workflow without an account. Upgrade to Nexo SQL Studio Pro when you need advanced development and delivery workflows.

Nexo SQL Studio Newsletter

Stay current with Nexo SQL Studio

Get practical updates about new features, releases, and improvements to Oracle SQL and PL/SQL development in VS Code.

Subscribe to the newsletter
Download

Install Nexo SQL Studio

Install from the VS Code Marketplace or the Open VSX Registry.

Visual Studio Code logo

VS Code Marketplace

Available on the VS Code Marketplace.

Cursor editor logo

Cursor / Open VSX

Available through Open VSX for Cursor and compatible editors.