Where is the model stored?

Nexo uses structured workspace files, so the model can live alongside the rest of the project.

Can the model participate in AI workflows?

Yes. The structured format is designed for AI-compatible workflows through Nexo's controlled development surface.

Do all features work with every database?

Database support does not imply identical features. Connections and SQL worksheets are the starting point; editing, DDL, modeling, transfers, administration and AI operations depend on the engine and workflow. Check the installed version and the relevant guide before relying on an advanced operation.

Data Modeler · Pro

Model database structures inside your VS Code workspace

Create, validate, edit, synchronize, and export structured data models without moving to a separate desktop tool. Keep model files with the project and use them in compatible AI-assisted workflows.

Data Modeler is available with Nexo SQL Studio Pro. · Advanced workflows vary by engine

Install for free View all features

A data model that belongs with the project

Visual editing at scale

Work with large diagrams, flexible automatic layouts, and real-time model changes across hundreds of tables.

Two-way model workflows

Synchronize structured model data and use workspace files for export, review, and AI-compatible changes.

From structure to a maintainable model

Treat the data model as an editable project artifact rather than a disconnected diagram.

Create or open a model

Start from structured model data in the current workspace.

Organize and validate

Arrange the diagram, edit entities and relationships, and check the model.

Synchronize or export

Carry the model into review, documentation, or assisted development workflows.

FAQ

Data Modeler 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

MCP for Oracle Workflows

Connect compatible AI tools to approved database context and operations with granular controls.

Explore feature

SQL and PL/SQL Formatter

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

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

Visual Data Modeler

Data Modeler is available with Nexo SQL Studio Pro. · Advanced workflows vary by engine

Install for free

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