How to list SQL Database databases

Learn how to list SQL Database databases.

View as Markdown

This guide demonstrates how to use Azion SQL Database to list the databases related to your account using the Azion API.

Listing databases

Run the following GET request in your terminal, replacing [TOKEN VALUE] with your personal token:

curl --location 'https://api.azion.com/v4/edge_sql/databases' \
--header 'Accept: application/json' \
--header 'Authorization: Token <token_value>'

You should receive the following response:

{
"count": 3,
"links": {
"first": null,
"last": null,
"next": null,
"prev": null
},
"results": [
{
"id": 34,
"name": "db1",
"client_id": "",
"status": "created",
"created_at": "2024-05-10T13:23:06.192407Z",
"updated_at": "2024-05-10T13:25:19.583236Z",
"deleted_at": null,
"is_active": true
},
{
"id": 39,
"name": "db2",
"client_id": "",
"status": "created",
"created_at": "2024-05-10T20:53:00.265039Z",
"updated_at": "2024-05-10T20:54:11.367440Z",
"deleted_at": null,
"is_active": true
},
{
"id": 40,
"name": "mydatabase",
"client_id": "",
"status": "created",
"created_at": "2024-05-13T13:42:14.311709Z",
"updated_at": "2024-05-13T13:44:11.962109Z",
"deleted_at": null,
"is_active": true
}
]
}