Overview

Welcome to MySQL Studio — your new, unified interface for working with MySQL AI. MySQL Studio is designed to make database management and AI integration simple and efficient, whether you’re a data professional or just starting out. With SQL Workshop, you can write, test, and run SQL statements in an intuitive editor, streamlining your workflow. The AI Chat feature provides a conversational way to harness advanced AI capabilities built-in to MySQL AI, helping you harness advanced AI capabilities directly from MySQL Studio. Plus, with integrated Python notebooks, you can explore data, build custom applications, and unlock powerful interactive features using Python and widgets—all within a single, seamless environment.

AI Chat

AI Chat in MySQL Studio offers a powerful, conversational interface for unlocking the full potential of MySQL AI. With AI Chat, you can seamlessly load documents in a variety of formats into vector stores, choose which vector stores to include in your searches, and interact directly with the AI features using natural language queries. This allows you to efficiently retrieve relevant information, manage your vector data, and leverage MySQL AI’s advanced capabilities — all through an intuitive chat-based experience.

For more details refer to the AI Chat User Guide.

SQL Workshop

SQL Workshop in MySQL Studio is your comprehensive environment for interacting directly with your MySQL AI database using SQL. It features a robust SQL command window for writing and executing queries, as well as a library of sample SQL statements to help you get started quickly.

SQL Workshop goes beyond basic query execution by providing advanced introspection tools such as interactive table and chart views, a detailed history of your executed statements, and a schema viewer for exploring your database structure. This suite of features empowers you to analyze, visualize, and understand your data with ease.

For more details refer to the SQL Workshop User Guide.

My Files

My Files in MySQL Studio provides a secure, private space for each user to manage their work and data. Here, you can create Jupyter-style Python notebooks, upload data files for use within your notebooks, and conveniently organize your resources. My Files also includes built-in viewers, allowing you to open and review PDFs, CSVs, and other common file types directly within the interface—streamlining your workflow and keeping everything you need in one accessible location.

A key feature of My Files is its support for interactive notebooks. When you open a notebook from the file browser, it launches in the integrated editor, allowing you to interact with and run your own notebooks in the MySQL Studio environment.

For more details refer to the My Files User Guide.

Notebooks

The Notebooks feature in MySQL Studio provides an interactive environment where you can combine both 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 made up of executable Python code cells and formatted text cells using Markdown. This powerful 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 Guide.

Python SDK

Every Python notebook in MySQL Studio has a globally available Python SDK called studiokit which provides a simple, unified API for both database management and AI workflows. With studiokit, you can work interactively with your data, perform advanced analytics, leverage built-in large language models (LLMs) and AutoML, or manage Lakehouse data—all from familiar Python code cells in your notebook.

The API is designed to be both beginner-friendly and powerful, with logical organization (studiokit.ai for GenAI/ML operations, studiokit.db for database and table management), full interactive tab-completion, and integrated help.

For a detailed API overview, example code, and usage patterns, see the Python SDK.

Ask Oracle

Ask Oracle is an always-available assistant built-in to MySQL Studio to help you with questions and explanations related to SQL and database usage. Accessed via the red chat button in the corner of the application, Ask Oracle can be opened or dismissed at any time by clicking this button.

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