# OmniFabric SQL Reference


This section provides a quick reference for SQL available on **OmniFabric database instances**: structure and syntax, data types, statement categories, functions and operators, system variables and system tables, privilege categories, and capability boundaries.

Use it to find supported syntax and object names. For instance creation, monitoring, alerts, and permissions, see the [OmniFabric guide](https://omnifabric.cloudsigma.com/docs/guides/matrixone/index.html.md).

OmniFabric SQL follows familiar MySQL 8.0 protocol and syntax conventions while adding vectors, Stage, publication and subscription, snapshots, point-in-time recovery, and other capabilities. These pages summarize the available syntax by topic.

## Pages in This Section

| Page | Content |
| --- | --- |
| [Structure and Syntax](https://omnifabric.cloudsigma.com/docs/reference/sql/language-structure.html.md) | Comments, identifiers, reserved keywords |
| [Data Types](https://omnifabric.cloudsigma.com/docs/reference/sql/data-types.html.md) | Numeric, string, time, JSON, VECTOR, and other types |
| [SQL Statements](https://omnifabric.cloudsigma.com/docs/reference/sql/statements.html.md) | DDL / DML / DQL / DCL / TCL / administrative statement lists |
| [Functions](https://omnifabric.cloudsigma.com/docs/reference/sql/functions.html.md) | Comprehensive function tables by category |
| [Operators](https://omnifabric.cloudsigma.com/docs/reference/sql/operators.html.md) | Arithmetic, comparison, logical, bitwise, CAST, CASE/IF, and other operators |
| [System Variables](https://omnifabric.cloudsigma.com/docs/reference/sql/system-variables.html.md) | Global / session variables and commonly used variables |
| [System Tables](https://omnifabric.cloudsigma.com/docs/reference/sql/system-tables.html.md) | System databases such as `mo_catalog` and commonly used tables |
| [Privilege Categories](https://omnifabric.cloudsigma.com/docs/reference/sql/privileges.html.md) | List of SQL privileges within a tenant |
| [Limitations](https://omnifabric.cloudsigma.com/docs/reference/sql/limitations.html.md) | Summary of differences from MySQL, including LOAD DATA and partitioning |

## 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 | [OmniFabric](https://omnifabric.cloudsigma.com/docs/guides/matrixone/index.html.md) |
| Configure users and roles in an instance | [OmniFabric permissions](../../guides/matrixone/permissions.md) |
| AI Studio roles and permissions | [User permissions](https://omnifabric.cloudsigma.com/docs/guides/ai-studio/permissions/index.html.md) |
| Run SQL against the Catalog | [SQL Editor](https://omnifabric.cloudsigma.com/docs/guides/ai-studio/processing/sql-editor.html.md) (if available) |

## Documentation Contents