---
title: "Create a database"
method: POST
path: "/api/v1/databases"
tags: ["Databases"]
---

# Create a database

`POST /api/v1/databases`

## Request

- Base URL: `https://app.khotan.com`
- URL: `https://app.khotan.com/api/v1/databases`
- Auth: one of:
  - HTTP bearer
  - API key in header `x-api-key`

Provisions a production Postgres database synchronously and responds 201 with the persisted record whether provisioning ends ready or failed; branch on the returned status. This operation is not idempotent: retrying a request that already succeeded provisions a second database. Omit regionId to use the default region.

## Request body

- object
  - `name` string, required
  - `regionId` string, nullable
  - `idempotencyKey` string

## Response `201`

The persisted database record, in ready or failed status.

- object
  - `id` string, required
  - `displayName` string, required
  - `status` 'creating' | 'ready' | 'failed', required
  - `provider` string, required
  - `regionId` string, required
  - `environment` 'production', required
  - `postgresVersion` integer, required
  - `providerDatabaseName` string, nullable, required
  - `providerRoleName` string, nullable, required
  - `endpointHost` string, nullable, required
  - `protected` boolean, required
  - `tags` string[], required
  - `createdAt` string, required
  - `updatedAt` string, required
  - `readyAt` string, nullable, required
  - `failedAt` string, nullable, required
  - `failureState` object, nullable, required
    - `code` 'provider_unavailable' | 'provider_rejected' | 'internal_error', required
    - `message` string, required

## Other responses

- `400`: The request was malformed or failed validation.
- `401`: Authentication is missing or invalid.
- `429`: Too many requests; retry after the indicated delay.

---

[API](https://skmtc.dev/khotan/apis/khotan-api.md) - [All operations](https://skmtc.dev/khotan/apis/khotan-api/llms.txt) - [OpenAPI document](https://skmtc.dev/khotan/apis/khotan-api/revisions/90b512a53e42?raw)