---
title: "Get a SQLite database"
method: GET
path: "/api/v1/sqlite-databases/{databaseId}"
tags: ["SQLite Databases"]
---

# Get a SQLite database

`GET /api/v1/sqlite-databases/{databaseId}`

## Request

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

Returns one SQLite database's record, including status and failure state when present. Responses never include connection credentials.

## Path parameters

- `databaseId` string, required

## Response `200`

The SQLite database record.

- 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

- `401`: Authentication is missing or invalid.
- `404`: The resource was not found.
- `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)