| BEGIN | Start a new transaction. | |
| COMMIT | Commits 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 TABLE | Create a new 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 TABLE | Drop the specified table. | |
| DUMP DATABASE | Dump database into file. | |
| EXPLAIN | Returns detailed information on how the query is executed. | |
| HELP | SQL statements help. | |
| INSERT | Insert data into a table. | |
| OPEN DATABASE | Open a database on disk. | Embedded Mode only |
| ROLLBACK | Roll back the open transaction if exists. | |
| SELECT | Retrieves 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 TABLES | Show the list of tables in database. | |
| SOURCE | Load and execute SQL file. | |
| UPDATE | Modifies rows in a table. | |
| USE | Use the database as the current default database. | |