---
title: List databases
description: Use the influxdb3 CLI, HTTP API, or InfluxDB 3 Explorer to list databases in InfluxDB 3 Core.
url: https://docs.influxdata.com/influxdb3/core/admin/databases/list/
estimated_tokens: 3556
product: InfluxDB 3 Core
version: core
---

# List databases

Use the [`influxdb3 show databases` command](/influxdb3/core/reference/cli/influxdb3/show/databases/), the [`/api/v3/configure/database`](/influxdb3/core/api/v3/) HTTP API endpoint, or [InfluxDB 3 Explorer](/influxdb3/explorer/) to list databases in InfluxDB 3 Core.

-   [List databases using the influxdb3 CLI](#list-databases-using-the-influxdb3-cli)
-   [List databases using the HTTP API](#list-databases-using-the-http-api)
-   [List databases using InfluxDB 3 Explorer](#list-databases-using-influxdb-3-explorer)

## List databases using the influxdb3 CLI

Provide the following:

-   *(Optional)* [Output format](#output-formats) with the `--format` option
-   *(Optional)* [Show deleted databases](#list-deleted-databases) with the `--show-deleted` option
-   InfluxDB 3 Core [admin token](/influxdb3/core/admin/tokens/admin) with the `-t`, `--token` option

```sh
influxdb3 show databases
```

### Output formats

The `influxdb3 show databases` command supports output formats:

-   `pretty` *(default)*
-   `json`
-   `jsonl`
-   `csv`
-   `parquet` *(must [output to a file](#output-to-a-parquet-file))*

Use the `--format` flag to specify the output format:

```sh
influxdb3 show databases --format json
```

#### Example output

[](#view-example-pretty-formatted-output)

View example pretty-formatted output

```
+---------------+
| iox::database |
+---------------+
| home          |
| home_actions  |
| noaa          |
+---------------+
```

[](#view-example-json-formatted-output)

View example JSON-formatted output

```json
[{"iox::database":"home"},{"iox::database":"home_actions"},{"iox::database":"noaa"}]
```

[](#view-example-json-line-formatted-output)

View example JSON-line-formatted output

```jsonl
{"iox::database":"home"}
{"iox::database":"home_actions"}
{"iox::database":"noaa"}
```

[](#view-example-csv-formatted-output)

View example CSV-formatted output

```csv
iox::database
home
home_actions
noaa
```

#### Output to a Parquet file

[Parquet](https://parquet.apache.org/) is a binary format. Use the `--output` option to specify the file where you want to save the Parquet data.

```sh
influxdb3 show databases \
  --format parquet \
  --output databases.parquet
```

Alternatively, use the `influxdb3 query` command to query system tables:

```sh
influxdb3 query \
  --database _internal \
  --format parquet \
  --output databases.parquet \
  "SELECT * FROM system.databases"
```

### List deleted databases

To list deleted databases, include the `--show-deleted` option with your `influxdb3 show databases` command:

```sh
influxdb3 show databases --show-deleted
```

## List databases using the HTTP API

To list databases using the HTTP API, send a `GET` request to the `/api/v3/configure/database` endpoint.

GET localhost:8181/api/v3/configure/database?format=pretty

Include the `format` query parameter and specify one of the following formats:

-   `pretty`
-   `json`
-   `jsonl`
-   `csv`
-   `parquet`

<!-- Tabbed content: Select one of the following options -->

**Pretty output:**

Include the following in your request:

-   **Headers**:
    
    -   `Authorization: Bearer` with your [token](/influxdb3/core/admin/tokens/)
-   **Query Parameters**:
    
    -   `format=pretty`

```bash
curl --request GET "localhost:8181/api/v3/configure/database?format=pretty" \
  --header "Authorization: Bearer AUTH_TOKEN"
```

The response body contains a table of database names:

```text
+---------------------+
| iox::database       |
+---------------------+
| _internal           |
| home                |
| home_actions        |
| noaa                |
+---------------------+
```

**JSON output:**

Include the following in your request:

-   **Headers**:
    
    -   `Authorization: Bearer` with your [token](/influxdb3/core/admin/tokens/)
-   **Query Parameters**:
    
    -   `format=json`

```bash
curl --request GET "localhost:8181/api/v3/configure/database?format=json" \
  --header "Authorization: Bearer AUTH_TOKEN"
```

The response body contains a JSON array of database objects whose keys are `iox::database`:

```json
[
  {
    "iox::database": "home"
  },
  {
    "iox::database": "home_actions"
  },
  {
    "iox::database": "noaa"
  }
]
```

**Parquet output:**

Include the following in your request:

-   **Headers**:
    
    -   `Authorization: Bearer` with your [token](/influxdb3/core/admin/tokens/)
-   **Query Parameters**:
    
    -   `format=parquet`
-   An output destination for the Parquet file
    

```bash
curl "localhost:8181/api/v3/configure/database?format=parquet" \
  -o databases.parquet \
  --header "Authorization: Bearer AUTH_TOKEN"
```

For Parquet responses, you must provide an output destination because the format is binary.

The response contains the databases list.

<!-- End tabbed content -->

A successful request returns HTTP status `200`.

## List databases using InfluxDB 3 Explorer

You can also view all databases using the [InfluxDB 3 Explorer](/influxdb3/explorer/) web interface:

1. If you haven’t already, see how to [get started with Explorer and connect to your InfluxDB 3 Core server](/influxdb3/explorer/get-started/).
2. In Explorer, click **Databases** in the left navigation.
3. The Databases page displays a list of all databases with the following information:
    -   Database name
    -   Retention period (if configured)
    -   Number of tables in the database
    -   Creation date

For more information, see [Manage databases with InfluxDB 3 Explorer](/influxdb3/explorer/manage-databases/).

#### Related

-   [influxdb3 show databases](/influxdb3/core/reference/cli/influxdb3/show/databases/)
-   [List databases API](/influxdb3/core/api/database/#operation/GetConfigureDatabase)
-   [Manage databases with InfluxDB 3 Explorer](/influxdb3/explorer/manage-databases/)