How to create and query data on SQL Database

Learn how to create and list tables and add data in SQL Database databases using the Azion REST API.

View as Markdown

Once you’ve created your SQL Database database, you can begin creating tables and inserting data into them.

go to SQL Database reference

Creating a table

Run the following POST request in your terminal, replacing [TOKEN VALUE] with your personal token and {id_database} with the ID of the database you want to create a table into:

curl --location 'https://api.azion.com/v4/edge_sql/databases/{id_database}/query' \
--header 'Authorization: Token [TOKEN VALUE]' \
--header 'Content-Type: application/json' \
--data {
"statements": [
"CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT NOT NULL);"
]
}

You should receive the following response:

{
"state": "executed",
"data": [
{
"results": {
"columns": [],
"rows": []
}
}
]
}

Adding data into a table

Run the following POST request in your terminal, replacing [TOKEN VALUE] with your personal token and {id_database} with the ID of the table you want to insert data into:

curl --location 'https://api.azion.com/v4/edge_sql/databases/{id_database}/query' \
--header 'Authorization: Token [TOKEN VALUE]' \
--header 'Content-Type: application/json' \
--data {
"statements": [
"INSERT INTO users VALUES (1, '\''item 1'\'');",
"INSERT INTO users VALUES (2, '\''item 2'\'');",
"INSERT INTO users VALUES (3, '\''item 3'\'');"
]
}

You should receive the following response:

{
"state": "executed",
"data": [
{
"results": {
"columns": [],
"rows": []
}
},
{
"results": {
"columns": [],
"rows": []
}
},
{
"results": {
"columns": [],
"rows": []
}
}
]
}

Listing data in a table

Run the following POST request in your terminal, replacing [TOKEN VALUE] with your personal token and {id_database} with the ID of the table you want to retrieve:

curl --location 'https://api.azion.com/v4/edge_sql/databases/{id_database}/query' \
--header 'Authorization: Token [TOKEN VALUE]' \
--header 'Content-Type: application/json' \
--data {
"statements": [
"SELECT * FROM users;"
]
}

You should receive the following response:

{
"state": "executed",
"data": [
{
"results": {
"columns": [
"id",
"name"
],
"rows": [
[
1,
"item 1"
],
[
2,
"item 2"
],
[
3,
"item 3"
]
]
}
}
]
}