> ## Documentation Index
> Fetch the complete documentation index at: https://docs.open-metadata.org/llms.txt
> Use this file to discover all available pages before exploring further.

# Databases

> Create and manage database containers within a service

# Databases

A **Database** is a container within a Database Service. It holds Database Schemas, which in turn contain Tables.

<Info>
  Entity schema follows the [OpenMetadata Standard](https://openmetadatastandards.org/data-assets/databases/database/).
</Info>

## Entity Hierarchy

Databases sit between Services and Schemas in the hierarchy:

<CodeGroup>
  ```txt Database theme={null}
  DatabaseService
  └── Database (this page)
      └── DatabaseSchema
          └── Table
  ```
</CodeGroup>

## Inheritance

When you set an **owner** or **domain** on a Database, it is inherited by all child schemas and tables.

***

## API Endpoints

| Method   | Endpoint                                | Description                                                                             |
| -------- | --------------------------------------- | --------------------------------------------------------------------------------------- |
| `PUT`    | `/v1/databases`                         | [Create or update a database](/v1.12.x/api-reference/data-assets/databases/create)      |
| `POST`   | `/v1/databases`                         | [Create a database (POST variant)](/v1.12.x/api-reference/data-assets/databases/create) |
| `GET`    | `/v1/databases`                         | [List databases](/v1.12.x/api-reference/data-assets/databases/list)                     |
| `GET`    | `/v1/databases/{id}`                    | [Get by ID](/v1.12.x/api-reference/data-assets/databases/retrieve)                      |
| `GET`    | `/v1/databases/name/{fqn}`              | [Get by FQN](/v1.12.x/api-reference/data-assets/databases/retrieve)                     |
| `PATCH`  | `/v1/databases/{id}`                    | [Update by ID](/v1.12.x/api-reference/data-assets/databases/update)                     |
| `PATCH`  | `/v1/databases/name/{fqn}`              | [Update by name](/v1.12.x/api-reference/data-assets/databases/update)                   |
| `DELETE` | `/v1/databases/{id}`                    | [Delete by ID](/v1.12.x/api-reference/data-assets/databases/delete)                     |
| `DELETE` | `/v1/databases/name/{fqn}`              | [Delete by name](/v1.12.x/api-reference/data-assets/databases/delete)                   |
| `PUT`    | `/v1/databases/restore`                 | [Restore soft-deleted database](/v1.12.x/api-reference/data-assets/databases/delete)    |
| `GET`    | `/v1/databases/{id}/versions`           | [List versions](/v1.12.x/api-reference/data-assets/databases/versions)                  |
| `GET`    | `/v1/databases/{id}/versions/{version}` | [Get specific version](/v1.12.x/api-reference/data-assets/databases/versions)           |
| `GET`    | `/v1/databases/name/{fqn}/export`       | [Export to CSV](/v1.12.x/api-reference/data-assets/databases/import-export)             |
| `GET`    | `/v1/databases/name/{fqn}/exportAsync`  | [Export to CSV (async)](/v1.12.x/api-reference/data-assets/databases/import-export)     |
| `PUT`    | `/v1/databases/name/{fqn}/import`       | [Import from CSV](/v1.12.x/api-reference/data-assets/databases/import-export)           |
| `PUT`    | `/v1/databases/name/{fqn}/importAsync`  | [Import from CSV (async)](/v1.12.x/api-reference/data-assets/databases/import-export)   |
| `PUT`    | `/v1/databases/{id}/followers`          | [Add follower](/v1.12.x/api-reference/data-assets/databases/advanced)                   |
| `DELETE` | `/v1/databases/{id}/followers/{userId}` | [Remove follower](/v1.12.x/api-reference/data-assets/databases/advanced)                |
| `PUT`    | `/v1/databases/{id}/vote`               | [Add/update vote](/v1.12.x/api-reference/data-assets/databases/advanced)                |
| `GET`    | `/v1/databases/{id}/profilerConfig`     | [Get profiler config](/v1.12.x/api-reference/data-assets/databases/advanced)            |
| `PUT`    | `/v1/databases/{id}/profilerConfig`     | [Set profiler config](/v1.12.x/api-reference/data-assets/databases/advanced)            |
| `DELETE` | `/v1/databases/{id}/profilerConfig`     | [Delete profiler config](/v1.12.x/api-reference/data-assets/databases/advanced)         |