New in Nexo SQL Studio Since the First Beta

A tour of the Oracle SQL, PL/SQL, worksheet, deployment, AI, MCP, offline DDL, schema browsing, and database management features added since the first beta release.

We hope you enjoy this new feature as much as we do.

Worksheets are becoming the command center

The SQL worksheet has received the largest day-to-day upgrade since the first beta. You can now work across multiple Oracle connections from a unified worksheet experience, keep important result tabs pinned, filter large result sets, search across all columns, and inspect a single row without losing the wider table context.

Result handling is also richer. Supported simple queries can be edited directly from the result grid, bulk row actions make repetitive work faster, and result options now keep export, refresh, and auto-refresh controls close to the data. For BLOB-heavy workflows, Nexo SQL Studio can render files and images as a gallery using filename and MIME type metadata returned by the query.

Autocomplete and assisted SQL are more context aware

Autocomplete now goes deeper than basic object names. The editor can surface online and offline Oracle SQL suggestions across schemas, common snippets, and function parameters with default values. That makes it easier to stay in flow when writing SQL and PL/SQL against large schemas or when working without a live metadata round trip.

Deployments now have a real review workflow

The deployment workflow now gives you a clearer review surface before applying changes. You can compare selected Oracle objects, separate changed and unchanged DDL, inspect SQL and PL/SQL differences in the editor, and then run the reviewed deployment with progress and execution details.

This matters for teams that want database delivery to feel closer to a code review. The workflow is designed around seeing what will change, understanding object readiness, and keeping deployment output traceable inside the same VS Code workspace where the objects are authored.

Offline DDL is built for Git and AI-assisted editing

Offline object work has moved beyond a quick export. Oracle objects can be generated as local DDL files, reviewed in Git, edited with AI assistance, regenerated, updated, downloaded, and reused as a versionable project structure. That gives teams a clearer path for pull requests, offline review, and repeatable database work.

The same offline files are also useful context for AI tools. Instead of asking an assistant to reason only from an active database connection, you can keep a file-based representation of your schema close to the code and review the actual changes before they are compiled or deployed.

Schema browsing and database operations are broader

The connection and object explorers now cover more of the Oracle workspace. Connections can be organized into folders with colors, while the object explorer can browse tables, packages, views, triggers, jobs, procedures, and other schema object types. Table detail panels make columns, indexes, constraints, triggers, grants, statistics, and metadata easier to inspect from one place.

Operational screens are also expanding. The database manager brings sessions, scheduler jobs, parameters, ACLs, wallets, and related database panels together. Session management includes finding, filtering, inspecting, and terminating Oracle sessions when you need to understand what is active in a database.

AI and MCP support are controlled by design

Nexo MCP gives AI tools controlled access to context-aware database workflows: offline files, compilation, query execution, optimization, and related Oracle actions. The important part is the control model. Permissions can be configured at folder and connection level, so AI-assisted operations stay explicit instead of silently gaining access to every database profile. Clearly control read, write, delete permissions for each connection.

That permission model is especially important as AI features move from suggestions into real database actions. Nexo SQL Studio is adding AI where it can reduce repetitive work, but the review, permission, and execution boundaries remain visible.

Local Oracle environments and snippets round out the workflow

For development and testing, Nexo SQL Studio can help create local Docker Oracle environments with APEX support and custom connection profiles.

Reusable SQL snippets now support aliases, folders, keyboard use, reports, and connection context. That makes repeated operational queries, team conventions, and database-specific helper scripts easier to keep close to the connections where they are actually used.

What this means for the beta

The first beta introduced the core idea: Oracle database development inside VS Code with connection browsing, object export, autocomplete, and object editing. The current beta expands that into a more complete Oracle workspace: worksheets for daily work, deployments for review, offline DDL for version control, database panels for operations, and AI/MCP features with explicit permissions.

There is still more to do, but the direction is clear. Nexo SQL Studio is becoming a practical place to write, inspect, review, deploy, and automate Oracle SQL and PL/SQL work without moving between disconnected tools.