Introduction

Welcome to MySQL Studio — your unified interface for working with MySQL AI. Designed to make database management and AI integration simple and efficient for both experts and beginners, MySQL Studio organizes your work into projects with sections for SQL, Chat, Notebooks, and Data. Direct database access makes it easy to blend SQL, AI, and notebooks seamlessly.

Work with SQL

SQL authoring in MySQL Studio provides a powerful environment for interacting directly with MySQL AI via SQL queries. It features a robust editor for writing and executing SQL, along with a library of sample statements to help you get started quickly.

Beyond basic execution, the editor includes advanced introspection tools such as interactive table and chart views, a detailed history of executed statements, and a schema viewer for exploring your database structure. These features make it easy to analyze, visualize, and understand your data.

For more details, refer to the Work with SQL Guide.

Chat with Data

Chat in MySQL Studio offers a conversational interface for unlocking the full potential of MySQL AI. You can load documents in a variety of formats into vector stores, choose which vector stores to search, and interact with AI features using natural language queries. This lets you retrieve relevant information, manage vector data, and leverage MySQL AI’s advanced capabilities—all through an intuitive chat experience.

For more details, refer to the Chat with Data Guide.

Notebooks

The Notebooks feature provides an interactive environment where you can combine code and text to work efficiently with your data. These Python notebooks are compatible with Jupyter notebooks—a popular open-source standard that lets you create pages composed of executable Python code cells and formatted Markdown text. This combination allows you to write code, document your process, visualize data, and tell your data story—all in one place.

To learn more about Notebooks, visit the Notebook Essentials Guide.

Projects and Content

MySQL Studio provides a unified project view that contains SQL, Chat, Notebooks, and Data files. Use the Project view (left drawer) to browse project sections and create and manage content. Built-in viewers let you open and review common file types (for example, Markdown, CSV, and PDFs) directly within the interface.

A key feature of MySQL Studio is its support for interactive SQL, Chat, and Notebooks. For example, selecting a notebook opens a full Jupyter-compatible editor, selectin SQL opens a fully interactive SQL editor and selecting chat content opens an AI powered conversational.

For more details, refer to the Projects and Content Guide.

Ask Oracle

Ask Oracle is an always-available assistant built into MySQL Studio to help with questions and explanations related to SQL and database usage. You can access it via the red chat button in the corner of the application; click the button to open or dismiss it at any time.

Whether you need guidance on a SQL statement, an explanation of a database concept, or answers to general questions, Ask Oracle is ready to assist you in context. Look for the red chat icon integrated throughout Studio to access Ask Oracle contextually.

Copyright (c) 2025, Oracle and/or its affiliates.