# MV\_BOTTOMLESS\_DATABASES

This view provides basic information about all the databases on an unlimited storage cluster. It includes databases currently attached on the cluster.

| Column name                | Description                                                                                                                                                                                           |
| -------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `DATABASE_NAME`            | Name of the database.                                                                                                                                                                                 |
| `STORAGE_ID`               | The unique ID of the storage backing the unlimited storage database.                                                                                                                                  |
| `COMPUTE_ID`               | Compute ID of the database.                                                                                                                                                                           |
| `CREATED_TIME`             | Time at which the unlimited storage database was created.                                                                                                                                             |
| `IS_DETACHED`              | Values can be "DETACHED" or "ATTACHED" depending on whether the database is currently detached or attached.                                                                                           |
| `RETENTION_PERIOD_MINUTES` | Minimum period of time, in minutes, before GC will clean up remote storage.Configured via`bottomless_gc_retention_period_minutes`.                                                                    |
| `EARLIEST_AVAILABLE_TIME`  | Earliest timestamp at which this database is attachable.                                                                                                                                              |
| `LAST_DETACHED_MILESTONE`  | The most recent milestone at which this database was detached.                                                                                                                                        |
| `STORAGE_CONFIG`           | The unlimited storage configuration information which with this database was created.                                                                                                                 |
| `STORAGE_TYPE`             | The cloud service provider (S3/Azure/GCP) on which the storage for this unlimited storage database exists.                                                                                            |
| `HAS_METADATA_SERVICE`     | Whether this database has the unlimited storage metadata service enabled.                                                                                                                             |
| `MEMORY_USE_ON_DETACH`     | The memory usage, in bytes, of this unlimited storage database's storage at time of detach. NULL if the database is attached (this column is not used for tracking memory usage of active databases). |

Example:

Version 8.5 and newer:

```sql
SELECT * FROM information_schema.MV_BOTTOMLESS_DATABASES;

```

```output

+-----------------+------------------------------------------+-------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+----------------------+----------------------+
| DATABASE_NAME   | STORAGE_ID                               | COMPUTE_ID              | CREATED_TIME        | IS_DETACHED | RETENTION_PERIOD_MINUTES | EARLIEST_AVAILABLE_TIME | LAST_DETACHED_MILESTONE    | STORAGE_CONFIG                                       | STORAGE_TYPE | HAS_METADATA_SERVICE | MEMORY_USE_ON_DETACH |
+-----------------+------------------------------------------+-------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+----------------------+----------------------+
| attached_db     | 2396611468173586007:12754783369249135506 | 16632719075037216741:5  | 2023-09-12 12:00:02 | ATTACHED    | 1440                     | 2023-09-12 12:00:02     |                            | {"endpoint_url": "http://storage_provider_endpoint"} | S3           | 0                    | NULL                 |
| detached_db     | 7514729589540251805:4355643310554835616  | NULL                    | 2023-09-12 12:01:01 | DETACHED    | 1440                     | 2023-09-12 12:01:01     | 2023-09-12 12_01_17.682054 | {"endpoint_url": "http://storage_provider_endpoint"} | S3           | 0                    | 0                    |
+-----------------+------------------------------------------+-------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+----------------------+----------------------+

```

Versions 7.6 through 8.1:

```sql
+-----------------+------------------------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+--------------+
| DATABASE_NAME   | STORAGE_ID                               | CREATED_TIME        | IS_DETACHED | RETENTION_PERIOD_MINUTES | EARLIEST_AVAILABLE_TIME | LAST_DETACHED_MILESTONE    | STORAGE_CONFIG                                       | STORAGE_TYPE | MEMORY_USAGE |
+-----------------+------------------------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+--------------+
| attached_db     | 2396611468173586007:12754783369249135506 | 2023-09-12 12:00:02 | ATTACHED    | 1440                     | 2023-09-12 12:00:02     |                            | {"endpoint_url": "http://storage_provider_endpoint"} | S3           | NULL         |
| detached_db     | 7514729589540251805:4355643310554835616  | 2023-09-12 12:01:01 | DETACHED    | 1440                     | 2023-09-12 12:01:01     | 2023-09-12 12_01_17.682054 | {"endpoint_url": "http://storage_provider_endpoint"} | S3           | 0            |
+-----------------+------------------------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+--------------+
```

***

Modified at: January 6, 2026

Source: [/db/v9.1/reference/information-schema-reference/unlimited-storage/mv-bottomless-databases/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/unlimited-storage/mv-bottomless-databases/)

(An index of the documentation is available at /llms.txt)