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

# Create a SQLite database

`POST /api/v1/sqlite-databases`

## Request

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

Provisions a SQLite 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.

## Request body

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

## Response `201`

The persisted SQLite database record, ready or failed.

- object
  - `id` string, required
  - `displayName` string, required
  - `status` 'creating' | 'ready' | 'failed', required
  - `provider` string, required
  - `primaryRegion` string, nullable, required
  - `regions` string[], nullable, required
  - `providerDatabaseName` 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)