MySQL Shell for VS Code 2026.2.0+9.6.1

The MySQL Shell for VS Code extension integrates the powerful feature set of MySQL Shell - an advanced MySQL client for developers and DBAs - directly into VS Code.

It provides a modern notebook interface to interactively work with and execute SQL against MySQL databases and the HeatWave service, as well as a traditional SQL script-based workflow.

What's New

• The new MySQL HeatWave Migration Assistant is now integrated into MySQL Shell for VS Code.

Tutorials

How to Create a New Database Connection

Feature Highlights

Full MySQL HeatWave Integration

Fully supports HeatWave Chat and Lakehouse Navigator to upload documents to HeatWave Lakehouse and query them using natural language queries.

Browse and manage your MySQL HeatWave DB Systems on the Oracle Cloud Infrastructure.

Get immediate and secure access to all your MySQL instances on OCI through tunneled Bastion connections.

Migrate MySQL databases hosted on-premises or on the cloud to MySQL HeatWave on Oracle Cloud with minimal downtime. The Migration Assistant greatly simplifies the process of provisioning, configuring and migrating MySQL databases to the Cloud.

Notebook Interface

The embedded DB Editor offers you a fresh way to work interactively with your database.

Switch from SQL to JavaScript or TypeScript to query, manipulate, and visualize your data.

MySQL Shell GUI Console

Provides the full power of the MySQL Shell inside a notebook-interface-styled editor.

Multi-line command editing, interactive auto-completion, and powerful plugins.

Tight Workflow Integration

MySQL Shell for VS Code integrates seamlessly into your development workflow.

Takes SQL embedded in your source files and runs it inside the DB Editor. Updates modified SQL in your source file.

Features Include

• Database Connection Manager:
  • Management of database connections to MySQL Server and MySQL Database Service (MHS) instances.
  • Browse through schema catalog
  • Dump schemas and load schemas with support for MHS instances
  • Open DB Editor for a database connection
  • Open MySQL Shell GUI Console for a database connection
• Oracle Cloud Infrastructure (OCI) Browser
  • Support for standard OCI profile configuration
  • Browse OCI compartments, MySQL DB Systems, Bastions, Compute Instances, and Load Balancers
  • Start/Stop operations for MySQL DB Systems
  • Creation of OCI Bastions and tunneled connections to MHS instance on private OCI networks
• DB Editor to work with live database connections:
  • Notebook Interface
  • Support for SQL, TypeScript, and JavaScript to work with the database
  • Auto-completion for SQL, TypeScript and JavaScript
  • Query result set browsing in a paged result grid
  • Support for multiple result sets in tabbed result grids
  • Support for text output for TypeScript and JavaScript code
  • Support for graphs for TypeScript and JavaScript code
• MySQL Shell GUI Console:
  • Notebook Interface
  • Support for SQL, Python, and JavaScript
  • Query result set browsing in a result grid
• Execute SQL from source files in DB Editor:
  • Execute any selected SQL commands from SQL files
  • Execute multi-line SQL blocks from Python files
    • Update original Python files with changes made in DB Editor
• MySQL REST Service support:
  • Full support for the MySQL REST Service and HeatWave REST Service
  • Create and manage REST services and REST endpoint
  • Manage authentication, authorization for REST endpoints
  • Upload Progressive Web Apps (PWAs) for a full-stack web app solution running on top of MySQL
• MySQL HeatWave Migration Assistant
  • Easily migrate MySQL databases to the managed MySQL HeatWave Service on Oracle Cloud

How to report a bug

To file a bug report, select the following menu item or go to bugs.mysql.com.

Supported Platforms

Copyright © 2022, 2026, Oracle and/or its affiliates.