Offline DDL Export

Nexo SQL Studio keeps Oracle work inside VS Code while still respecting Oracle-specific workflows.

Overview

Export tables, packages, views, and other objects into local files, refresh changed objects incrementally, and use those files for search and navigation offline.

Local DDL snapshots

Install the extension, add a connection, open a worksheet, and run SQL with Ctrl+Enter. Use the object tree, snippets, formatter, and offline DDL features as your project grows.

Daily use

• Keep the SQL, PL/SQL, DDL files, and review context in the same VS Code workspace.
• Use the connection explorer, worksheet, object tree, snippets, formatter, and offline DDL tools together.
• Prefer project settings when several developers share the same Oracle workflow.

Configuration

Most settings are available from the VS Code Settings UI under Nexo SQL Studio and can also be stored in workspace JSON when the project needs repeatable behavior.

Security and secrets

Passwords are stored in VS Code SecretStorage, backed by the native OS keychain where available. Connection metadata is kept separate from secrets.

MCP and automation

MCP access lets approved AI assistants search metadata, execute approved queries, compile objects, and assist with data-model work under the policies you configure.

Next steps

After the basic flow works, open the related feature pages in the documentation and tune the settings for your team.