Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Conventions
• Changes in Release 26.2 for SQL Developer for VS Code
• Getting Started
  • Installing Oracle SQL Developer for VS Code
    • File Permissions for User Accounts in Windows Domain
  • Connecting to Your Database
    • Creating a Connection
    • Creating an OCI Connection
    • Configuring Licensed Database Packs for a Connection
    • Entra ID Authentication
    • Kerberos Authentication
• Using SQL Developer for VS Code
  • Understanding AI Enrichment
    • Enabling AI Enrichment for a Schema
    • Required User Privileges for AI Enrichment
    • Introduction to the AI Enrichment Dashboard
    • High-Level Schema Description
    • Managing Table Groups
      • Creating a Table Group
      • Adding a Description to a Table Group
      • Adding Annotations for a Table Group
      • Adding an Existing Table to a Table Group
      • Assigning a Table to Multiple Groups
    • Enriching Tables
      • Adding a Description to a Table
      • Adding Annotations for a Table
    • Enriching Columns
      • Adding a Description to a Table Column
      • Adding Annotations for a Table Column
    • Exporting AI Enrichment Data to JSON
  • Working with Database Objects
    • Filtering Object Folders
    • Tables
    • Views
      • Creating or Editing a View
    • Duality Views
    • Indexes
      • Creating or Editing an Index
    • Packages
    • Procedures
    • Functions
    • MLE Environments
    • JavaScript Modules
    • Triggers
    • Types
    • Sequences
    • Synonyms (Public and Private)
    • Other Users
  • Managing DBA Objects
    • Scheduler Jobs
      • Jobs Management Dashboard
      • Creating or Editing a Job
    • DBA Roles
      • Viewing Role Details
      • Creating or Editing a Role
    • DBA Users
      • Creating or Editing a User
      • Clone, Lock, Unlock, or Expire a User Password
    • Performance Reports
      • Active Session History (ASH) Report
      • Automatic Workload Repository (AWR) Report
  • Working with Tables
    • Using Table Editor
      • Columns
      • Primary Key
      • Unique Keys
      • Indexes
      • Foreign Keys
      • Table Constraints
      • Comments
      • Storage
      • DDL
      • Output
    • Configuring and Managing Data Import
      • Importing Data into Tables
  • Working with JSON-Relational Duality Views
    • Create a Duality View
    • Edit a Duality View
    • Insert a Data Record in a Duality View
    • Edit a Data Record in a Duality View
    • Display the JSON Data Guide Diagram for a Duality View
  • Managing JavaScript Modules
    • Create a JavaScript Module
      • Example for Create a JavaScript Module
    • Open a JavaScript Module
    • Show JavaScript Module Details
    • Compile JavaScript Module
    • Delete a JavaScript Module
  • Managing MLE Environments
    • Create an MLE Environment
      • Example for Create an MLE Environment
    • Import a Module to an MLE Environment
    • Compile an MLE Environment
    • Delete an MLE Environment
  • Entering and Modifying Data
  • Using the SQL Notebook
    • Using the Code Cell
      • Viewing Single Record
      • Exporting Data
      • Rendering Output as Charts
    • Using the Markdown Cell
    • Additional Cell Configuration Options
  • Using the SQL Worksheet
    • SQLcl Commands Supported in the SQL Worksheet
    • Connection Management
    • Script Runner
    • Explain Plan
    • Task Monitor
    • SQL History
    • Using Snippets to Insert Code Fragments
    • Reports
  • Working with Diagrams
    • Database Object Details
    • Understanding Diagram Elements
    • Searching Objects on the Diagram
  • Running Functions and Procedures
  • Debugging PL/SQL Objects
    • Required Debugging Database Privileges
    • Understanding Database Debug Sessions
    • Debugging a PL/SQL Object
  • Post-Execution Debugging of MLE JavaScript Modules
  • Using Real Time SQL Monitor
  • Using Folders to Organize Connections
  • Using Filters
  • Using Preferences
  • Using Drag and Drop for Code Generation
    • Generate Connection Code
    • Generate Java Code for Database Objects
  • Working With APEXlang Applications
    • Understanding the Connection Navigator and APEXlang Editor
    • Exporting an APEX Application
    • Generating an APEX Application
    • Importing an APEX Application
    • Comparing with an APEX Application
    • APEXlang Language Services
    • Import Workflow Enhancements
• Using the Oracle SQLcl MCP Server
  • About the SQLcl MCP Server
  • About the SQLcl MCP Server Tools
  • How the SQLcl MCP Server Works
  • Preparing Your Environment
    • Installing the Required Software
    • Configuring Database Connections
  • Starting and Managing the SQLcl MCP Server
    • Accessing SQLcl MCP Server
    • Accessing SQLcl MCP Server Tools
    • Using the Agent Mode
  • Example Use Cases and Prompts
  • Monitoring the SQLcl MCP Server
    • Checking Server Status
    • Tracking Activity with Logs
    • Assessing Server Health Through Performance
• Tutorial: Creating Objects for a Small Database
  • Create a Table (BOOKS)
  • Create a Table (PATRONS)
  • Create a Table (TRANSACTIONS)
  • Create Two Sequences
  • Insert Data into the Tables
  • Create a View
  • Create a PL/SQL Procedure
  • Use the SQL Worksheet for Queries
• Third-Party License Information
  • @emotion/react 11.14.0
  • @mui/material 7.3.6
  • @muix-date-pickers 8.21.0
  • ag-grid-community 34.3.1
  • ag-grid-react 34.3.1
  • cross-fetch 4.1.0
  • dayjs 1.11.13
  • echarts 6.0.0
  • fast-xml-parser 5.9.3
  • Jetty 12.1.7
  • monaco-editor 0.52.2
  • react 19.2.3
  • react-dom 19.2.3
  • react-tabs 6.1.0
  • react-window 2.2.3
  • vscode-codicons 0.0.45
  • vscode-languageclient 10.0.0
  • vscode-languageserver-protocol 3.17.6
  • winston 3.17.0
  • ws 8.21.0
  • yauzl 3.4.0
  • yaml 2.9.0