Frequently Asked Questions
Everything you need to know about Nexo SQL Studio for Oracle development in VS Code.
Nexo SQL Studio is a Visual Studio Code extension for Oracle SQL and PL/SQL development, with autocompletion, symbol navigation, query execution, object browsing, offline DDL export, documentation helpers, and managed workflows inside VS Code.
Nexo SQL Studio is designed for modern Oracle Database workflows, including Oracle 19c, 21c, 23ai, and the newer 26ai naming used by Oracle. We recommend validating critical workflows against your own database version and drivers.
Nexo SQL Studio follows industry-standard security practices and takes advantage of VS Code security measures plus the native encryption systems provided by each operating system. Keep your machine, VS Code, and Oracle client tooling updated for the strongest protection.
Database credentials and query results stay under your control. Connections are made between your machine and the Oracle systems you configure, and sensitive local storage relies on VS Code and operating-system security features.
The extension exposes an advanced MCP integration for the AI agents you choose. It can help agents search database context, execute queries you approve, compile objects, inspect errors, and create data models for Oracle workflows.
Statements are executed only when you trigger a workflow or approve an AI-agent action. Some features read Oracle metadata to power navigation, completions, and object browsing.
Yes. Offline DDL export creates a local file tree for database objects so you can navigate definitions, compare schema changes, and review PL/SQL without an active database connection.
Yes. Nexo SQL Studio runs anywhere VS Code runs. Oracle connection capabilities depend on the Oracle client libraries and drivers installed on your machine.
Contact [email protected] with your question, environment, extension version, and a concise reproduction when reporting a bug.