How to list SQL Database databases

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
    }
  ]
}