Nexo SQL Studio
Nexo SQL Studio is a Visual Studio Code extension for Oracle SQL and PL/SQL development. It brings Oracle-aware editing, navigation, execution, testing, and database tooling into one VS Code workflow.
The current release is in public beta.
What Nexo SQL Studio includes
- AI-assisted SQL and PL/SQL development with MCP support
- Smart PL/SQL autocompletion and IntelliSense for package members, procedures, functions, types, columns, and contextual PL/SQL symbols
- Go to Definition and symbol navigation across package specs, bodies, files, and configured search paths
- Inline SQL and PL/SQL execution with rich results, filtering, sorting, pagination, export, gallery-style previews, and detailed cell inspection
- Connection Explorer and object tree browsing for schemas, tables, views, packages, procedures, functions, sequences, and synonyms
- Object editing and compile workflows directly inside VS Code
- Offline DDL export for file-based workflows, version control, and pull requests
- utPLSQL discovery and execution in the VS Code Test Explorer with inline pass/fail feedback
- SQL and PL/SQL formatting, syntax highlighting, snippets, generated documentation headers, signature help, and hover help
- Multi-connection support, connection groups, schema switching, and SQL Developer connection import
- Managed deployments, automated data migrations, live code validation, and database management workflows
- Integrated step debugger support
- Oracle APEX and ORDS support
- Cross-platform distribution through the VS Code Marketplace on macOS, Windows, and Linux
Public Beta
This beta is intentionally focused. The core workflow is already available, but some areas are still evolving and additional capabilities are planned. If you want access updates and the current beta flow, use the beta signup link above.
Why teams use it
- Stay in VS Code from discovery to editing, execution, validation, and export
- Work against live Oracle databases or generate local files for offline review and Git-based delivery
- Reduce context switching across object browsing, query execution, test runs, formatting, and navigation
Learn More
| |
