Projects and Content

In MySQL Studio, you can manage your projects and content from a single interface. Projects help you group related SQL files, chat conversations, notebooks, and data files. The Project View in the left drawer offers organized sections and quick actions for each item, making it easy to access and edit your files.

Project View

The Project View (left drawer) contains the following sections:

SQL: SQL scripts you can open and run in the SQL editor.
Chat: ChatGPT-like conversations.
Notebooks: Jupyter-compatible notebooks (.ipynb) you can open and execute.
Data: Data files (for example CSV, JSON, images) that support your notebooks.
Database Objects: A list of objects in the connected MySQL database (schemas, tables, views, routines). This section appears last.

From the Project View you can:

Create new SQL, Chat, or Notebook
Rename, Delete, or Download files via each item’s action menu

Working with Content

Create: Use the create action in the relevant section (SQL, Chat, Notebook) to add a new file to the project.
Manage: Use the action menu on any file to rename, delete, or download it.
Open: Click a file to open it in the main editor area. All edits are auto-saved.

Editors and Runtimes

SQL Editor: Opens for SQL content. A Run Query button appears at the top to execute statements against your connected database.
Chat: Opens a conversational interface for iterative prompts and responses.
Notebook: Opens a full Jupyter-compatible environment for interactive notebooks. To learn more about notebooks, see the Notebook Guide.

Data

Any content which is not a Chat, SQL, or Notebook appears in the data section. You can upload files via the Upload button (or use your operating system’s drag and drop feature). Data content exists for Python notebooks to read and write data. Notebook environments start in the project’s directory by default, so Python can read and write files there directly without extra path configuration. Content can be downloaded as a file via the action menu and/or managed like any other content (rename, delete).

Note > Data content is the same as files located in the secure file priv space. Files located in the secure file priv location can only be accessed via commands issued via SQL to the your connected database, whereas data content can only be accessed from within MySQL Studio and MySQL Studio Python notebooks.

Data Ingestion

For large file ingestion, it is recommended to use on of the following procedures.

MySQL AI environments

Place files in the MySQL server's secure_file_priv directory (for example, /var/lib/mysql-files).

Example

LOAD DATA INFILE '/var/lib/mysql-files/yourfile.csv'
INTO TABLE your_table
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES;

For more information see the MySQL LOAD DATA INFILE documentation.

OCI environments

In OCI, use MySQL HeatWave Lakehouse features to efficiently ingest and analyze large datasets. See MySQL HeatWave Lakehouse: Auto-Loading Data.

MySQL Studio - 9.6.0

Preface and Legal Notices

Introduction

Work with SQL

Chat with Data