List databases

Use the influxdb3 show databases command, the /api/v3/configure/database HTTP API endpoint, or InfluxDB 3 Explorer to list databases in InfluxDB 3 Enterprise.

• List databases using the influxdb3 CLI
• List databases using the HTTP API
• List databases using InfluxDB 3 Explorer

List databases using the influxdb3 CLI

Provide the following:

• (Optional) Output format with the --format option
• (Optional) Show deleted databases with the --show-deleted option
• InfluxDB 3 Enterprise admin token with the -t, --token option

influxdb3 show databases

Output formats

The influxdb3 show databases command supports output formats:

• pretty (default)
• json
• jsonl
• csv

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

influxdb3 show databases --format json

Example output

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

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

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

iox::database
home
home_actions
noaa

List deleted databases

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

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

Include the following in your request:

• Headers:
  • Authorization: Bearer with your token

curl --request GET "localhost:8181/api/v3/configure/database" \
  --header "Authorization: Bearer 
AUTH_TOKEN
"

Replace the following:

• AUTH_TOKEN: your admin token

Response

A successful request returns HTTP status 200 with a JSON array of database objects:

[
  {
    "db": "home",
    "retention_period": "30d"
  },
  {
    "db": "home_actions",
    "retention_period": "7d"
  },
  {
    "db": "noaa",
    "retention_period": "none"
  }
]

List databases using InfluxDB 3 Explorer

You can also view all databases using the InfluxDB 3 Explorer web interface:

1. If you haven’t already, see how to get started with Explorer and connect to your InfluxDB 3 Enterprise server.
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.