| BEGIN | Start a new transaction. | |
| COMMIT | Commit the open transaction if exists. | |
| CLOSE DATABASE | Close an opened database. | Embedded Mode only |
| CREATE DATABASE | Create a database. | |
| CREATE INDEX | Create an index on the specified table. | |
| CREATE SERVER | Create a CrossDB Server. | |
| CREATE TABLE | Create a new table. | |
| CREATE TRIGGER | Create a trigger on the specified table. | |
| DELETE | Delete rows in a table. | |
| DESCRIBE | Describe the specified table. | |
| DROP DATABASE | Drop a database. | |
| DROP INDEX | Drop the specified index on the specified table. | |
| DROP SERVER | Drop the specified server. | |
| DROP TABLE | Drop the specified table. | |
| DUMP DATABASE | Dump database into file. | |
| EXPLAIN | Return detailed information on how the query is executed. | |
| HELP | SQL statements help. | |
| INSERT | Insert row into a table. | |
| OPEN DATABASE | Open a database on disk. | Embedded Mode only |
| REPLACE | Insert or Modify row into a table. | |
| ROLLBACK | Roll back the open transaction if exists. | |
| SELECT | Retrieve data from a table. | |
| SET AUTOCOMMIT | Set session transaction auto-commit. | |
| SHELL | Enter interactive shell. | |
| SHOW COLUMNS | Show the list of columns within a given table. | |
| SHOW CREATE TABLE | Show the CREATE TABLE statement. | |
| SHOW DATABASE | Show the list of databases. | |
| SHOW INDEXES | Show the list of indexes associated with a given table. | |
| SHOW SERVERS | Show the list of servers. | |
| SHOW TABLES | Show the list of tables in database. | |
| SOURCE | Load and execute SQL file. | |
| UPDATE | Modify rows in a table. | |
| USE | Use the database as the current default database. | |