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 Core.
- 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
--formatoption - (Optional) Show deleted databases with the
--show-deletedoption - InfluxDB 3 Core admin token with the
-t,--tokenoption
influxdb3 show databasesOutput formats
The influxdb3 show databases command supports output formats:
pretty(default)jsonjsonlcsv
Use the --format flag to specify the output format:
influxdb3 show databases --format jsonExample output
Output to Parquet
To output your list of databases to a Parquet file, use the influxdb3 query command
--format:parquet-o,--output: the filepath to the Parquet file to output to
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:
influxdb3 show databases --show-deletedList 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=prettyInclude the format query parameter and specify one of the following formats:
prettyjsonjsonlcsvparquet
Include the following in your request:
- Headers:
Authorization: Bearerwith your token
- Query Parameters:
format=pretty
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:
+---------------------+
| iox::database |
+---------------------+
| _internal |
| home |
| home_actions |
| noaa |
+---------------------+Include the following in your request:
- Headers:
Authorization: Bearerwith your token
- Query Parameters:
format=json
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:
[
{
"iox::database": "home"
},
{
"iox::database": "home_actions"
},
{
"iox::database": "noaa"
}
]Include the following in your request:
- Headers:
Authorization: Bearerwith your token
- Query Parameters:
format=parquet
- An output destination for the Parquet file
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.
A successful request returns HTTP status 200.
List databases using InfluxDB 3 Explorer
You can also view all databases using the InfluxDB 3 Explorer web interface:
- If you haven’t already, see how to get started with Explorer and connect to your InfluxDB 3 Core server.
- In Explorer, click Databases in the left navigation.
- 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.
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB 3 Core and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.