Sidebar

Mobile navigation sidebar

Nexo SQL Studio Nexo SQL Studio
MCP integration · Pro

Give AI tools controlled access to Oracle development workflows

Nexo MCP exposes approved metadata, query, compilation, deployment, model, API, and debugging capabilities to compatible clients. MCP Companion applies your connection permissions and confirmation rules before work reaches the database.

Nexo MCP and MCP Companion are included with Pro. · Advanced workflows vary by engine

Install for free View all features

Useful access with explicit boundaries

Permissions per connection

Allow or deny MCP reads and writes independently, with separate safeguards for deleting data and dropping objects.

Confirm sensitive operations

Require confirmation for reads, writes, deletes, drops, offline compilation, and object collisions according to your workflow.

Connect an assistant without losing oversight

Nexo provides the bridge between an MCP client and the database controls you define.

01
Choose the connection

Enable MCP only for the Oracle environments you want the assistant to use.

02
Set the policy

Configure read, write, delete, drop, and confirmation behavior for that connection.

03
Use compatible tools

Let the client request context or actions while Nexo applies the selected controls.

MCP context and permission controls

Open the screenshots to inspect the available workflow and per-connection policy settings.

FAQ

MCP questions

Explore Nexo

Focused tools for everyday database development

See how each Nexo SQL Studio feature fits into your database workflow in VS Code.

Nexo AI for Oracle APEX in Chrome

Connect APEX to VS Code: autocomplete, formatting, external editing and AI changes with live reload.

Explore feature
Visual SQL Query Builder

Compose Oracle SELECT statements visually and continue with editable SQL in a worksheet.

Explore feature
PL/SQL IntelliSense

Get context-aware Oracle completions online and across local PL/SQL projects.

Explore feature
AI-Assisted Development

Use database context for SQL, PL/SQL, debugging, optimization, and modeling workflows.

Explore feature
SQL and PL/SQL Formatter

Keep Oracle SQL and PL/SQL readable and consistent inside the VS Code editor.

Explore feature
Visual Data Modeler

Design and maintain data models as workspace files with visual and AI-compatible workflows.

Explore feature
Offline PL/SQL Workspace

Generate local Oracle definitions and keep coding with PL/SQL IntelliSense, navigation, and autocomplete without a live database.

Explore feature
PL/SQL Debugger

Step through Oracle code in VS Code with breakpoints, variable inspection, watches, and a live call stack.

Explore feature
utPLSQL Unit Testing

Discover Oracle test suites and run individual tests or whole packages from VS Code Test Explorer, with results, coverage, and debugging.

Explore feature

MCP for Oracle Workflows

Nexo MCP and MCP Companion are included with Pro. · Advanced workflows vary by engine

Install for free

Open preview

Open preview

Supported databases

Oracle Database

Service names, SIDs, TNS and wallets, plus PL/SQL, debugging and APEX/ORDS tooling.

Connection guide
PostgreSQL

Connect to PostgreSQL or Supabase, browse schemas and run SQL worksheets.

Connection guide
MySQL

A dedicated MySQL adapter for connections, SQL worksheets and query results.

Connection guide
MariaDB

A dedicated MariaDB adapter, separate from MySQL, with SQL worksheets and results.

Connection guide
SQLite

Open a local database file, with no server or port, and query it from VS Code.

Connection guide
Microsoft SQL Server

Connect with SQL logins and encryption settings, then run T-SQL worksheets.

Connection guide
Feature availability