# Database context

Source: https://www.hotdata.dev/docs/api-reference/database-context
Site index: https://www.hotdata.dev/llms.txt

Store and retrieve named text or Markdown documents scoped to a specific database.

## List database contexts

`GET /v1/databases/{database_id}/context`

**Path parameters**

- `database_id` `string` — **required**. Database ID

**Response** `200` — Contexts

- `contexts` `DatabaseContextEntry`[] — **required**
  - `content` `string` — **required**
  - `name` `string` — **required**
  - `updated_at` `string` — **required**

```json
{
  "contexts": [
    {
      "content": "string",
      "name": "string",
      "updated_at": "2026-01-01T00:00:00Z"
    }
  ]
}
```

**Errors**

| Status | Description |
| ------ | ----------- |
| `404` | Database not found |

## Create or update database context

`POST /v1/databases/{database_id}/context`

Stores a named document (for example Markdown) scoped to a database. Reuses the same name to replace content.

**Path parameters**

- `database_id` `string` — **required**. Database ID

**Request body**

- `content` `string` — **required**
- `name` `string` — **required**. Upsert key in the catalog. Validated with table-name rules (preserves case): ASCII letter or `_` first; then alphanumeric or `_` only; 1–128 chars; not a SQL reserved word.

```json
{
  "content": "The orders table holds one row per completed purchase. `amount` is in USD cents.",
  "name": "orders_overview"
}
```

**Response** `200` — Context saved

- `context` `DatabaseContextEntry` — **required**. One context entry returned by the API.
  - `content` `string` — **required**
  - `name` `string` — **required**
  - `updated_at` `string` — **required**

```json
{
  "context": {
    "content": "string",
    "name": "string",
    "updated_at": "2026-01-01T00:00:00Z"
  }
}
```

**Errors**

| Status | Description |
| ------ | ----------- |
| `400` | Invalid request |
| `404` | Database not found |

## Get one database context

`GET /v1/databases/{database_id}/context/{name}`

**Path parameters**

- `database_id` `string` — **required**. Database ID
- `name` `string` — **required**. Context key: same character rules as a table name

**Response** `200` — Context found

- `context` `DatabaseContextEntry` — **required**. One context entry returned by the API.
  - `content` `string` — **required**
  - `name` `string` — **required**
  - `updated_at` `string` — **required**

```json
{
  "context": {
    "content": "string",
    "name": "string",
    "updated_at": "2026-01-01T00:00:00Z"
  }
}
```

**Errors**

| Status | Description |
| ------ | ----------- |
| `400` | Invalid request |
| `404` | Database or context not found |

## Delete database context

`DELETE /v1/databases/{database_id}/context/{name}`

Removes a named context document from a database.

**Path parameters**

- `database_id` `string` — **required**. Database ID
- `name` `string` — **required**. Context key: same character rules as a table name

**Response** `204` — Context deleted

**Errors**

| Status | Description |
| ------ | ----------- |
| `400` | Invalid request |
| `404` | Database or context not found |