# Create a database

> Create a managed Postgres database in a workspace and wait for it to come up.

> Nevia is in beta and open to selected teams. Public launch in Dec 2026. The CLI installs with `curl -fsSL https://get.nevia.cloud | sh`, and the MCP server is at https://api.nevia.cloud/mcp. A person signs in once in the browser.
> Setup, sign-in and requesting access: [SKILL.md](https://nevia.cloud/SKILL.md). When Nevia fits and when it doesn't: [why.md](https://nevia.cloud/why.md).

> For the complete documentation index, see [llms.txt](https://nevia.cloud/llms.txt). This page's HTML version: https://nevia.cloud/docs/reference/api/databases/createDatabase

`POST https://api.nevia.cloud/v1/databases`

## Authorization

- `bearerAuth`: HTTP bearer in the Authorization header

Send the token in the `Authorization: Bearer <token>` header. See [Authenticate](https://nevia.cloud/docs/reference/api.md#authenticate).

## Parameters

| Name | In | Type | Required | Description |
|---|---|---|---|---|
| `Idempotency-Key` | header | string | yes | Retry key. A retry with the same key and body replays the first response. Length `1 <= length <= 255`. |

## Request body

Content type: `application/json`, required

Schema: `DatabaseCreateRequest`

Managed Postgres with fixed size and storage

| Field | Type | Required | Description |
|---|---|---|---|
| `workspace` | string | yes | Workspace id: 27 lowercase letters and digits. Match `^[A-Za-z0-9_-]{1,64}$`. |
| `name` | string | no | Unique within the workspace per resource kind. Match `^[a-z0-9]([a-z0-9-]*[a-z0-9])?$`. Length `1 <= length <= 63`. |
| `engine` | string | no | Database engine. |
| `from_checkpoint` | string | no | Checkpoint id: 27 lowercase letters and digits. Match `^[A-Za-z0-9_-]{1,64}$`. |
| `protected` | boolean | no | Blocks deletion while true. Default `false`. |

## Behavior

The response carries a `database.create` operation, finished in a `200` and running in a `202`. If `connection` is null, read it with `GET /v1/databases/{db}/connection` once the database is `ready`.

## Example request

### cURL

```bash
curl -X POST "https://api.nevia.cloud/v1/databases" \
  -H "Authorization: Bearer $TOKEN" \
  -H "Idempotency-Key: 8f1c2a7e-3b4d-4c5e-9f0a-1b2c3d4e5f60" \
  -H "Content-Type: application/json" \
  -d '{
    "workspace": "01d4cnjjq40hnnh0nwmkg35nv2h",
    "name": "orders"
  }'
```

### JavaScript

```js
const body = JSON.stringify({
  "workspace": "01d4cnjjq40hnnh0nwmkg35nv2h",
  "name": "orders"
})

fetch("https://api.nevia.cloud/v1/databases", {
  method: "POST",
  headers: {
    "Content-Type": "application/json",
    "Authorization": `Bearer ${process.env.TOKEN}`,
    "Idempotency-Key": "8f1c2a7e-3b4d-4c5e-9f0a-1b2c3d4e5f60"
  },
  body
})
```

### Python

```python
import os
import requests

url = "https://api.nevia.cloud/v1/databases"
body = """{
  "workspace": "01d4cnjjq40hnnh0nwmkg35nv2h",
  "name": "orders"
}"""
response = requests.request("POST", url, data = body, headers = {
  "Content-Type": "application/json", 
  "Authorization": f"Bearer {os.environ['TOKEN']}", 
  "Idempotency-Key": "8f1c2a7e-3b4d-4c5e-9f0a-1b2c3d4e5f60"
})

print(response.text)
```

## Responses

### 200

The database, `ready` or `failed`, when the create finished during the request.

Content type: `application/json`

Schema: `DatabaseCreateResponse`

Database, its connection and the create operation

| Field | Type | Required | Description |
|---|---|---|---|
| `database` | Database | yes | A managed Postgres database. |
| `connection` | Connection \| null | yes | Connection details. Only connection and reset calls return the password. |
| `operations` | array<OperationId> | yes | Operations this request started. |

Example:

```json
{
  "database": {
    "id": "01d4cnjkgq02b6tfqvy8yh391pq",
    "workspace": "01d4cnjjq40hnnh0nwmkg35nv2h",
    "name": "api-staging",
    "state": "ready",
    "pending": null,
    "engine": "postgres",
    "version": "18.6",
    "host": "01d4cnjkgq02b6tfqvy8yh391pq.live.nevia.cloud",
    "port": 5432,
    "parent": null,
    "from_checkpoint": "01d4cnjkwhftngfp8vkmp723mhv",
    "generation": 1,
    "protected": false,
    "error": null,
    "created_at": "2026-09-10T12:34:56Z",
    "deleted_at": "2026-09-10T12:34:56Z"
  },
  "connection": {
    "host": "01d4cnjkgq02b6tfqvy8yh391pq.live.nevia.cloud",
    "port": 5432,
    "database": "nevia",
    "user": "nevia_admin",
    "password": "<password>",
    "password_status": "tracked",
    "reset_pending": true,
    "uri": "postgres://nevia_admin:<password>@01d4cnjkgq02b6tfqvy8yh391pq.live.nevia.cloud:5432/nevia?sslmode=require",
    "pooler_uri": "postgres://nevia_admin:<password>@01d4cnjkgq02b6tfqvy8yh391pq.live.nevia.cloud:6432/nevia?sslmode=require",
    "ssl_mode": "require",
    "server_ca": null,
    "pooler_port": 6432
  },
  "operations": [
    "01d4cnjm89yk0r3xtv80dy0x7by"
  ]
}
```

### 202

The database `creating`, when the create is still running.

Content type: `application/json`

Schema: `DatabaseCreateResponse`

Database, its connection and the create operation

| Field | Type | Required | Description |
|---|---|---|---|
| `database` | Database | yes | A managed Postgres database. |
| `connection` | Connection \| null | yes | Connection details. Only connection and reset calls return the password. |
| `operations` | array<OperationId> | yes | Operations this request started. |

Example:

```json
{
  "database": {
    "id": "01d4cnjkgq02b6tfqvy8yh391pq",
    "workspace": "01d4cnjjq40hnnh0nwmkg35nv2h",
    "name": "api-staging",
    "state": "ready",
    "pending": null,
    "engine": "postgres",
    "version": "18.6",
    "host": "01d4cnjkgq02b6tfqvy8yh391pq.live.nevia.cloud",
    "port": 5432,
    "parent": null,
    "from_checkpoint": "01d4cnjkwhftngfp8vkmp723mhv",
    "generation": 1,
    "protected": false,
    "error": null,
    "created_at": "2026-09-10T12:34:56Z",
    "deleted_at": "2026-09-10T12:34:56Z"
  },
  "connection": {
    "host": "01d4cnjkgq02b6tfqvy8yh391pq.live.nevia.cloud",
    "port": 5432,
    "database": "nevia",
    "user": "nevia_admin",
    "password": "<password>",
    "password_status": "tracked",
    "reset_pending": true,
    "uri": "postgres://nevia_admin:<password>@01d4cnjkgq02b6tfqvy8yh391pq.live.nevia.cloud:5432/nevia?sslmode=require",
    "pooler_uri": "postgres://nevia_admin:<password>@01d4cnjkgq02b6tfqvy8yh391pq.live.nevia.cloud:6432/nevia?sslmode=require",
    "ssl_mode": "require",
    "server_ca": null,
    "pooler_port": 6432
  },
  "operations": [
    "01d4cnjm89yk0r3xtv80dy0x7by"
  ]
}
```

### 400

`validation_failed`: malformed body, unknown field, or invalid id or name. Fix `details.field` and retry.

Content type: `application/json`

Schema: `ErrorEnvelope`

Body of every error response

| Field | Type | Required | Description |
|---|---|---|---|
| `error` | Error | yes |  |

Example `validation_failed`:

```json
{
  "error": {
    "code": "validation_failed",
    "message": "Unknown field `colour` in the request body. Remove it; request bodies are strict.",
    "details": {
      "field": "colour",
      "in": "body"
    },
    "request_id": "req_01j9k3m2p7q4r8s1"
  }
}
```

### 401

`unauthorized`: the credential is missing, malformed, expired, or revoked. Send a valid bearer token.

Content type: `application/json`

Schema: `ErrorEnvelope`

Body of every error response

| Field | Type | Required | Description |
|---|---|---|---|
| `error` | Error | yes |  |

Example `unauthorized`:

```json
{
  "error": {
    "code": "unauthorized",
    "message": "Missing credential. Send `Authorization: Bearer <token>` with an access token.",
    "details": {},
    "request_id": "req_01j9k3m2p7q4r8s1"
  }
}
```

### 403

`forbidden`: the token is read-only or scoped elsewhere, or the role cannot do this. Use a token or role that allows it.

Content type: `application/json`

Schema: `ErrorEnvelope`

Body of every error response

| Field | Type | Required | Description |
|---|---|---|---|
| `error` | Error | yes |  |

Example `forbidden`:

```json
{
  "error": {
    "code": "forbidden",
    "message": "You can view computer 01d4cnjk3xg90y576w8y6t4gdwm but your role does not allow computer#edit. Ask a workspace admin to change your role (PATCH /v1/workspaces/{ws}/access/{principal}).",
    "details": {
      "computer": "01d4cnjk3xg90y576w8y6t4gdwm",
      "permission": "computer#edit"
    },
    "request_id": "req_01j9k3m2p7q4r8s1"
  }
}
```

### 404

`not_found`: the workspace does not exist, or you cannot see it. Both return the same response.

Content type: `application/json`

Schema: `ErrorEnvelope`

Body of every error response

| Field | Type | Required | Description |
|---|---|---|---|
| `error` | Error | yes |  |

Example `not_found`:

```json
{
  "error": {
    "code": "not_found",
    "message": "Workspace 01d4cnjjq40hnnh0nwmkg35nv2h was not found. List the workspaces you can access with GET /v1/workspaces.",
    "details": {
      "workspace": "01d4cnjjq40hnnh0nwmkg35nv2h"
    },
    "request_id": "req_01j9k3m2p7q4r8s1"
  }
}
```

### 409

`name_conflict`: a database in the workspace already has this name. `limit_exceeded`: the beta limit on live databases is reached. `idempotency_conflict`: the `Idempotency-Key` was already used with a different body.

Content type: `application/json`

Schema: `ErrorEnvelope`

Body of every error response

| Field | Type | Required | Description |
|---|---|---|---|
| `error` | Error | yes |  |

Example `name_conflict`:

```json
{
  "error": {
    "code": "name_conflict",
    "message": "A database named orders already exists in workspace 01d4cnjjq40hnnh0nwmkg35nv2h. Pick another name, or find it with GET /v1/databases?workspace=01d4cnjjq40hnnh0nwmkg35nv2h&name=orders.",
    "details": {
      "workspace": "01d4cnjjq40hnnh0nwmkg35nv2h",
      "name": "orders",
      "list_route": "GET /v1/databases?workspace=01d4cnjjq40hnnh0nwmkg35nv2h"
    },
    "request_id": "req_01j9k3m2p7q4r8s1"
  }
}
```

Example `limit_exceeded`:

```json
{
  "error": {
    "code": "limit_exceeded",
    "message": "Beta limit reached: 5 of 5 databases. Delete one to create another.",
    "details": {
      "kind": "database",
      "scope": "workspace",
      "count": 5,
      "limit": 5
    },
    "request_id": "req_01j9k3m2p7q4r8s1"
  }
}
```

Example `idempotency_conflict`:

```json
{
  "error": {
    "code": "idempotency_conflict",
    "message": "Idempotency-Key 8f1c2a7e-3b4d-4c5e-9f0a-1b2c3d4e5f60 was already used for a different POST /v1/databases request. Use a new key for a new request.",
    "details": {
      "idempotency_key": "8f1c2a7e-3b4d-4c5e-9f0a-1b2c3d4e5f60"
    },
    "request_id": "req_01j9k3m2p7q4r8s1"
  }
}
```

### 422

`not_supported`: the request sets `from_checkpoint`, asks for an engine other than `postgres`, or the platform has no capacity left for a database.

Content type: `application/json`

Schema: `ErrorEnvelope`

Body of every error response

| Field | Type | Required | Description |
|---|---|---|---|
| `error` | Error | yes |  |

Example `not_supported`:

```json
{
  "error": {
    "code": "not_supported",
    "message": "`from_checkpoint` is not available in this build: database checkpoints wait for the quiesce point. Create the database fresh, or branch one with POST /v1/databases/{db}/branch.",
    "details": {
      "field": "from_checkpoint"
    },
    "request_id": "req_01j9k3m2p7q4r8s1"
  }
}
```

### 423

`operation_in_progress`: a conflicting operation runs. Retry after `Retry-After`, or poll `details.operation_id` for completion.

Content type: `application/json`

Schema: `ErrorEnvelope`

Body of every error response

| Field | Type | Required | Description |
|---|---|---|---|
| `error` | Error | yes |  |

Example `operation_in_progress`:

```json
{
  "error": {
    "code": "operation_in_progress",
    "message": "Computer 01d4cnjk3xg90y576w8y6t4gdwm has an operation in progress. Poll GET /v1/operations/01d4cnjm89yk0r3xtv80dy0x7by until it finishes, then retry.",
    "details": {
      "computer": "01d4cnjk3xg90y576w8y6t4gdwm",
      "operation_id": "01d4cnjm89yk0r3xtv80dy0x7by",
      "retry_after_seconds": 2
    },
    "request_id": "req_01j9k3m2p7q4r8s1"
  }
}
```

### 429

`rate_limited`: slow down. Retry after `Retry-After`.

Content type: `application/json`

Schema: `ErrorEnvelope`

Body of every error response

| Field | Type | Required | Description |
|---|---|---|---|
| `error` | Error | yes |  |

Example `rate_limited`:

```json
{
  "error": {
    "code": "rate_limited",
    "message": "Too many requests. Retry after 2 seconds.",
    "details": {
      "retry_after_seconds": 2
    },
    "request_id": "req_01j9k3m2p7q4r8s1"
  }
}
```

### 500

`request_failed`, or the failed action's own code, such as `creation_failed`, `authorization_failed` or `command_execution_failed`. Quote `request_id` when reporting. The diagnostic stays in server logs.

Content type: `application/json`

Schema: `ErrorEnvelope`

Body of every error response

| Field | Type | Required | Description |
|---|---|---|---|
| `error` | Error | yes |  |

Example `request_failed`:

```json
{
  "error": {
    "code": "request_failed",
    "message": "request failed",
    "details": {},
    "request_id": "req_01j9k3m2p7q4r8s1"
  }
}
```

### 503

The action is temporarily unavailable, named by its code (`creation_failed`, `wake_failed`, ...). Wait at least `Retry-After` seconds (60 by default). `details.retryable` says whether repeating the request is safe. Keep the original `Idempotency-Key`. Signing in again does not help.

Content type: `application/json`

Schema: `ErrorEnvelope`

Body of every error response

| Field | Type | Required | Description |
|---|---|---|---|
| `error` | Error | yes |  |

Example `creation_failed`:

```json
{
  "error": {
    "code": "creation_failed",
    "message": "The computer could not be created. Try again later, and quote request_id if it persists.",
    "details": {
      "retryable": true
    },
    "request_id": "req_01j9k3m2p7q4r8s1"
  }
}
```