SQL Reference

MatrixOne Intelligence is a platform for data and AI applications that combines AI Studio, MatrixOne, and Genesis. MatrixOne is the database foundation of MatrixOne Intelligence, providing data storage, SQL queries, and related computation.

This reference covers MatrixOne SQL structure and syntax, data types, statements, functions, operators, system variables, system tables, privileges, and limitations. Each topic overview links to detailed pages with syntax, parameters, examples, and limitations.

Scope

Use this reference when executing SQL against a MatrixOne database instance. SQL executed through AI Studio also follows the capabilities of the underlying engine, subject to the operations and permissions available through that platform entry point. Support in the database engine does not mean that every AI Studio entry point exposes the same operations.

MatrixOne SQL privileges and AI Studio workspace and feature permissions are configured separately. Creating a table through the AI Studio SQL editor does not automatically register it in Catalog. To manage a table in Catalog, follow the creation or import instructions in the SQL editor guide.

Documentation version 5.0 refers to the MatrixOne Intelligence manual version. SQL capabilities depend on the MatrixOne engine version and configuration of the instance. MatrixOne uses a MySQL-compatible protocol; consult MatrixOne documentation for its syntax, functions, and limitations.

Pages in This Section

Page

Content

Structure and Syntax

Comments, identifiers, reserved keywords

Data Types

Numeric, string, time, JSON, VECTOR, and other types

SQL Statements

Categories and detailed references for DDL, DML, DQL, DCL, transactions, and administrative statements

Functions

Function tables and detailed parameters, return values, and examples

Operators

Arithmetic, comparison, logical, bitwise, conversion, control flow, and precedence

System Variables

Global / session variables and commonly used variables

System Tables

System databases such as mo_catalog and commonly used tables

Privilege Categories

List of SQL privileges within a tenant

Limitations

Detailed support information for LOAD DATA, partitions, and JDBC

How to Use This Section with the Guides

What you want to do

Where to go

Create, connect to, monitor, and understand billing for an instance

MatrixOne

Configure users and roles in an instance

Permissions · MatrixOne

AI Studio workspace roles and privilege points

User Permissions

Execute SQL in AI Studio

SQL Editor

Documentation Contents

Last updated on