Navigation & Go to Definition
Jump between declarations, definitions, package specs, and bodies with one keystroke.
Nexo SQL Studio keeps Oracle work inside VS Code while still respecting Oracle-specific workflows.
Overview
Use F12, Ctrl+Click, peek definition, symbol search, breadcrumbs, package spec/body commands, and configured search paths to move through PL/SQL.
Navigation tools
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.