Does PL/SQL IntelliSense work without a database connection?

Yes. With Pro, Nexo builds language context from Oracle source files in your workspace and configured search paths. Offline autocomplete, go-to-definition, hover information, and symbol navigation work from those local files.

Do I need a connection to create an offline workspace?

You need an Oracle connection only to generate or refresh a snapshot from the database. Once the source files are local, you can edit and navigate them without connecting.

Can I version the workspace with Git?

Yes. The generated SQL and PL/SQL definitions are ordinary project files, so you can review changes and commit them with your usual Git workflow.

Can I use an existing PL/SQL repository?

Yes. Open the repository in VS Code and, when needed, configure nexo-sql-studio.searchPaths to include the folders that contain Oracle source files.

Do all features work with every database?

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.

Offline development · Pro

Build and navigate Oracle PL/SQL workspaces offline

Generate local Oracle object definitions from a connection, then keep editing SQL and PL/SQL when you are away from the database. Nexo indexes supported Oracle source files in your workspace and configured search paths for context-aware autocomplete, go-to-definition, hover information, and symbol navigation in VS Code.

Offline workspace generation and file-based IntelliSense are Pro features. The initial snapshot uses an Oracle connection; editing, autocomplete, and code navigation then work from local files without a live database. · Oracle-specific

Install for free View all features

Keep Oracle source code in your workspace

Offline IntelliSense from local source files

Index packages, procedures, functions, types, and other supported objects from workspace files for offline completion and navigation.

Version Oracle code with Git

Review and commit generated Oracle SQL and PL/SQL files alongside application code, compare changes, and share a consistent source snapshot with your team.

From an Oracle schema to offline development

Seed the workspace with a database snapshot when useful, then keep Oracle code in regular files you can inspect, edit, and version.

Generate a local snapshot

In Connections Explorer, select your Oracle connection and run “Initialize offline definitions (Pro)”. Choose the object types to include; Nexo writes the generated files under db/ in your open workspace, organized by connection.

Open the files in your project

Keep the exported folders in a VS Code workspace. Nexo indexes supported Oracle sources and can use configured search paths for an existing PL/SQL repository.

Code, navigate, and commit offline

Use completions, hover, symbols, and go-to-definition from local files without a database connection. Review the diff and commit your SQL and PL/SQL changes to Git.

FAQ

Offline PL/SQL workspace questions

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

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

Offline PL/SQL Workspace

Install for free

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