---
title: "Return MySQL databases"
method: GET
path: "/list_databases"
tags: ["Databases", "MySQL Databases"]
---

# Return MySQL databases

`GET /list_databases`

This function lists the server's databases.

**Warning:**

On most servers, this function returns a large amount of output. We strongly suggest that you [filter](https://go.cpanel.net/WHMAPI1FilterOutput) and [sort](https://go.cpanel.net/WHMAPI1SortOutput) the output.

**Important:**

When you disable the MySQL/MariaDB and PostgreSQL [roles](https://go.cpanel.net/serverroles) and remote MySQL is **not** already configured, the system **disables** this function.

## Response `200`

HTTP Request was successful.

- object
  - `data` object
    - `payload` object[] — An array of objects that contain of database data.
      - `cpuser` string, username — The database's owner.
      - `engine` 'mysql' | 'postgresql' — The database's engine. - `mysql` - `postgresql`
      - `name` string — The database's name.
  - `metadata` object
    - `command` string — The method name called.
    - `reason` string — The reason the API function failed when the `metadata.result` field is `0`. This field may display a success message when a function succeeds.
    - `result` 0 | 1 — * `1` — Success. * `0` — Failed. Check the `reason` field for more details.
    - `version` integer — The version of the API function.

---

[API](https://skmtc.net/cpanel/apis/whm-api.md) · [All operations](https://skmtc.net/cpanel/apis/whm-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/cpanel/whm-api/revisions/3da41671c02c/schema)