SQL Database quickstart

Create your first SQL database in Azion Console or with the Azion API, add a table, insert a row, and read the row back.

Last updated

View as Markdown Agent setup

This guide instructs you through storing and reading your first row in SQL Database. By the end you will have:

  • Your first database, with the status created.
  • A users table inside it.
  • One row stored in that table.
  • The same row returned by a SELECT statement.

The result rests on two objects. The database is the container, and its name cannot be changed after creation. Each table lives inside one database, and this guide creates the table with a CREATE TABLE statement. A database is provisioned asynchronously. Its status reads creating first, and a statement runs against it only after the status reads created.

Select the interface you will use. The prerequisites and every stage below follow that choice.

Prerequisites

  • SQL Database enabled on the account. The product is in Preview, and access is requested through the technical support team. To request it, refer to Technical Support.
  • The Edit SQL Database permission on the account. It grants permission to create and edit databases and their data. For more information, refer to Teams Permissions.

Create a database

A database holds the tables you create. Its name is 6 to 50 characters, and uses letters, numbers, and the hyphen. Provisioning is asynchronous, so the database is not queryable the moment it is created.

To create the database in Azion Console:

Open the database list

Access Azion Console > SQL Database.

Open the create form

Start a new database from the list, with the SQL Database control.

Name the database

Under General, in Name, enter a name of your own. A name another database in the account holds is refused.

Select Save

The database appears in the list, which shows its Name, Status, Last Editor, and Last Modified. Its status reads creating until it reads created, which takes about 15 seconds.

To create the database with the Azion API and wait for it to be ready:

Send the create request

Replace [TOKEN VALUE] with your personal token, and my-database with a name of your own:

Shell
01curl --request POST \
02 --url https://api.azion.com/v4/workspace/sql/databases \
03 --header 'Accept: application/json' \
04 --header 'Authorization: Token [TOKEN VALUE]' \
05 --header 'Content-Type: application/json' \
06 --data {
07 "name": "my-database"
08}
Read the response

A 202 carries the database:

JSON
01{
02 "state": "pending",
03 "data": {
04 "id": 1235,
05 "name": "my-database",
06 "status": "creating",
07 "active": true,
08 "last_modified": "2026-01-01T12:13:01.399970Z",
09 "last_editor": "user@example.com",
10 "product_version": "1.0"
11 }
12}

Record the id, 1235 in this sample. Every request below addresses the database by it. A 400 with the code 14001 means the account already holds a database with that name. Choose a different name and send the request again.

Poll until the status reads created

Replace 1235 with the id the create response returned:

Shell
01curl --request GET \
02 --url https://api.azion.com/v4/workspace/sql/databases/1235 \
03 --header 'Accept: application/json' \
04 --header 'Authorization: Token [TOKEN VALUE]'

A 200 carries the database, and this response has no state key:

JSON
01{
02 "data": {
03 "id": 1235,
04 "name": "my-database",
05 "status": "created",
06 "active": true,
07 "last_modified": "2026-01-01T12:13:13.920246Z",
08 "last_editor": "user@example.com",
09 "product_version": "1.0"
10 }
11}

Provisioning takes about 15 seconds. Send the request again while the status reads creating.

The database is ready when status reads created. Do not skip the wait: a statement sent while the status reads creating cannot succeed.

Create a table

A table holds the rows you store, and its columns are fixed by the CREATE TABLE statement.

The Editor tab runs SQL against one database. To create the table this guide uses:

Open the database

In the SQL Database list, select the database you created.

Go to the Editor tab
Enter the CREATE TABLE statement

Create the users table with three columns:

CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, email TEXT);
Select Run query

The table appears under the Tables tab.

The query endpoint runs SQL against one database. The body carries a statements array, and Azion runs the statements in order.

Send the query request

Replace 1235 with the id of your database:

Shell
01curl --request POST \
02 --url https://api.azion.com/v4/workspace/sql/databases/1235/query \
03 --header 'Accept: application/json' \
04 --header 'Authorization: Token [TOKEN VALUE]' \
05 --header 'Content-Type: application/json' \
06 --data {
07 "statements": ["CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, email TEXT);"]
08}
Read the response

A 200 carries one entry per statement:

JSON
01{
02 "state": "executed",
03 "data": [
04 {
05 "results": {
06 "columns": [],
07 "rows": [],
08 "rows_read": 1,
09 "rows_written": 2,
10 "query_duration_ms": 2.592
11 }
12 }
13 ]
14}

The statement returns no rows, so columns and rows are empty. It still reports rows read and written, because CREATE TABLE writes the schema itself. Azion bills on rows_read and rows_written, and returns both per statement.

The database holds a users table with no rows.

Insert a row

An INSERT statement stores a row in the table.

To store the first row from the Editor tab:

Enter the INSERT statement

In the Editor tab, enter the following statement:

INSERT INTO users (name, email) VALUES ('Ada', 'ada@example.com');
Select Run query

The table holds one row.

To store the first row through the query endpoint:

Send the query request

The INSERT statement carries single quotes, so the body is sent on standard input:

Shell
01curl --request POST \
02 --url https://api.azion.com/v4/workspace/sql/databases/1235/query \
03 --header 'Accept: application/json' \
04 --header 'Authorization: Token [TOKEN VALUE]' \
05 --header 'Content-Type: application/json' \
06 --data @- <<'EOF'
07{
08 "statements": ["INSERT INTO users (name, email) VALUES ('Ada', 'ada@example.com');"]
09}
10EOF
Read the response

A 200 reports the write:

JSON
01{
02 "state": "executed",
03 "data": [
04 {
05 "results": {
06 "columns": [],
07 "rows": [],
08 "rows_read": 0,
09 "rows_written": 1,
10 "query_duration_ms": 2.649
11 }
12 }
13 ]
14}

The table holds one row.

Read the row back

A SELECT statement returns what the table holds.

To read the row you inserted from the Editor tab:

Enter the SELECT statement

In the Editor tab, enter the following statement:

SELECT id, name, email FROM users;
Select Run query

The result carries one row under the columns id, name, and email: 1, Ada, and ada@example.com.

To read the row you inserted through the query endpoint:

Send the query request
Shell
01curl --request POST \
02 --url https://api.azion.com/v4/workspace/sql/databases/1235/query \
03 --header 'Accept: application/json' \
04 --header 'Authorization: Token [TOKEN VALUE]' \
05 --header 'Content-Type: application/json' \
06 --data {
07 "statements": ["SELECT id, name, email FROM users;"]
08}
Read the response

A 200 carries the column names and one array per row:

JSON
01{
02 "state": "executed",
03 "data": [
04 {
05 "results": {
06 "columns": ["id", "name", "email"],
07 "rows": [[1, "Ada", "ada@example.com"]],
08 "rows_read": 1,
09 "rows_written": 0,
10 "query_duration_ms": 0.041
11 }
12 }
13 ]
14}

The result carries one row under the columns id, name, and email: 1, Ada, and ada@example.com.

Your first database holds a users table with one row, and reads it back. The same statements run in Azion Console, through the Azion API, and inside a function.

Next steps

How SQL Database worksThe main instance, the read replicas, and how a statement reaches your data.Databases and queriesEvery field a database carries, the five operations, and the error codes.Query a database from a functionRead the same table from a function at run time.SQL Database limitsThe bounds on a name and a table, and the usage included in each plan.