Sidebar

Mobile navigation sidebar

Nexo SQL Studio Nexo SQL Studio

Nexo SQL Studio

SQL client and database development
inside VS Code

Query, explore and develop with Oracle, PostgreSQL, MySQL, MariaDB, SQLite and Microsoft SQL Server in VS Code. Nexo SQL Studio combines a database client with dedicated Oracle SQL and PL/SQL tooling.

Install for free
Watch more videos Explore the gallery

Watch the product showcase

Open the full Nexo SQL Studio presentation to see the product workflow in a larger player.

New · Nexo AI for Oracle APEX

Change your APEX page without leaving it

Write SQL with autocomplete, edit in VS Code or ask Nexo AI Sidebar to update the APEXlang source. Live reload brings successfully applied changes straight back to your development page.

Explore the Chrome extension
  • Edit code externally
  • Autocomplete and format in APEX
  • Open the page's APEXlang source
  • Ask, apply and see the result
Explore Nexo

Focused tools for everyday database development

See how each Nexo SQL Studio feature fits into your database workflow in VS Code.

Nexo AI for Oracle APEX in Chrome

Connect APEX to VS Code: autocomplete, formatting, external editing and AI changes with live reload.

Explore feature
Visual SQL Query Builder

Compose Oracle SELECT statements visually and continue with editable SQL in a worksheet.

Explore feature
PL/SQL IntelliSense

Get context-aware Oracle completions online and across local PL/SQL projects.

Explore feature
AI-Assisted Development

Use database context for SQL, PL/SQL, debugging, optimization, and modeling workflows.

Explore feature
MCP for Oracle Workflows

Connect compatible AI tools to approved database context and operations with granular controls.

Explore feature
SQL and PL/SQL Formatter

Keep Oracle SQL and PL/SQL readable and consistent inside the VS Code editor.

Explore feature
Visual Data Modeler

Design and maintain data models as workspace files with visual and AI-compatible workflows.

Explore feature
Offline PL/SQL Workspace

Generate local Oracle definitions and keep coding with PL/SQL IntelliSense, navigation, and autocomplete without a live database.

Explore feature
PL/SQL Debugger

Step through Oracle code in VS Code with breakpoints, variable inspection, watches, and a live call stack.

Explore feature
utPLSQL Unit Testing

Discover Oracle test suites and run individual tests or whole packages from VS Code Test Explorer, with results, coverage, and debugging.

Explore feature

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

Everyday SQL 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 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
Code navigation and symbol lookup
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
SQL worksheet results in VS Code
Full Feature Set

A complete database 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 database schema visually
Oracle schema object explorer tree view
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
Unit test results panel in 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 database 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

Tools for your database workflows, 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 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 database 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.

Live code and object search

Search database source code and object names in one connection and open matches straight from the results. Pro extends search to folders and multiple connections.

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 database connections from one workspace without duplicating projects or switching tools.

Multi-connection and table data search (Pro)

Search live code and objects from a connection folder or a multi-selection, and find values inside the data of the tables you choose, with every match in one results tab.

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 Client (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

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.

Windows

Windows 10 & 11

x64 and Arm64

macOS

macOS 11+

Intel x64 and Apple silicon

Linux

Ubuntu, Fedora & more

x64 and Arm64

Ready to upgrade your database workflow?

Install Nexo SQL Studio from the VS Code Marketplace and start using a SQL client with advanced Oracle tools inside your editor today.

Supported databases

Oracle Database

Service names, SIDs, TNS and wallets, plus PL/SQL, debugging and APEX/ORDS tooling.

Connection guide
PostgreSQL

Connect to PostgreSQL or Supabase, browse schemas and run SQL worksheets.

Connection guide
MySQL

A dedicated MySQL adapter for connections, SQL worksheets and query results.

Connection guide
MariaDB

A dedicated MariaDB adapter, separate from MySQL, with SQL worksheets and results.

Connection guide
SQLite

Open a local database file, with no server or port, and query it from VS Code.

Connection guide
Microsoft SQL Server

Connect with SQL logins and encryption settings, then run T-SQL worksheets.

Connection guide
Feature availability Advanced Oracle development