Sidebar

Mobile navigation sidebar

Nexo SQL Studio Nexo SQL Studio

Sidebar

Mobile navigation sidebar

Nexo SQL Studio
Search docs…
Introduction
Features
Advanced
Supported databases
SQL client tutorials for six database engines
Development
Back to Home
Documentation

Nexo SQL Studio Documentation

Everything you need to get the most out of Nexo SQL Studio — from connecting to Oracle, PostgreSQL, MySQL, MariaDB, SQLite or SQL Server to daily query, navigation, and offline DDL workflows.

Get Started
Introduction
Getting Started
Introduction
Connections
Introduction
Importing and Exporting Connections
Introduction
Environments
Introduction
Projects
Features
Object Tree
Features
Autocompletion & IntelliSense
Features
Snippets
Features
Formatting
Features
Snippet and report menu actions
Features
Query Worksheet
Features
Deployments
Features
Offline DDL Export
Features
Navigation & Go to Definition
Features
PL/SQL Debugger
Features
Data Modeler
Features
Query Builder
Advanced
Connect AI Assistants with Nexo MCP
Advanced
Settings Reference
Supported databases
Oracle Database: Connection guide
Supported databases
PostgreSQL: Connection guide
Supported databases
MySQL: Connection guide
Supported databases
MariaDB: Connection guide
Supported databases
SQLite: Connection guide
Supported databases
Microsoft SQL Server: Connection guide
SQL client tutorials for six database engines
Oracle Database: Run your first query
SQL client tutorials for six database engines
PostgreSQL: Run your first query
SQL client tutorials for six database engines
MySQL: Run your first query
SQL client tutorials for six database engines
MariaDB: Run your first query
SQL client tutorials for six database engines
SQLite: Run your first query
SQL client tutorials for six database engines
Microsoft SQL Server: Run your first query
Development
Object Locking
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
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

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