---
title: "Query SQLite database"
method: POST
path: "/v1/services/{service_id}/sqlite/{database}/query"
tags: ["Deploy"]
---

# Query SQLite database

`POST /v1/services/{service_id}/sqlite/{database}/query`

## Path parameters

- `service_id` string, required
- `database` string, required

## Request body

- SqliteQueryRequest
  - `params` union[]
    - union
      - string
      - integer
      - number
      - boolean
  - `sql` string
  - `statements` SqliteStatementRequest[]
    - `params` union[]
      - union
        - string
        - integer
        - number
        - boolean
    - `sql` string, required

## Response `200`

- SqliteQueryResponse
  - `database` SqliteDatabaseBinding, required
    - `id` string, required
    - `name` string, required
    - `queryTimeoutSeconds` integer, required
    - `quotaState` string, required
    - `storageLimitMib` integer, required
    - `storageUsedMib` integer, required
    - `timeTravelDays` integer, required
  - `meta` SqliteQueryMeta, required
    - `duration` number, double, required
    - `rows_read` integer, required
    - `rows_written` integer, required
    - `size_after` integer, required
  - `nextActions` string[], required
  - `results` SqliteStatementResult[], required
    - `changes` integer, required
    - `columns` string[], required
    - `durationMs` integer, required
    - `fullscanSteps` integer, required
    - `lastInsertRowid` integer, required
    - `rows` object[], required
    - `rowsRead` integer, required
    - `rowsWritten` integer, required
    - `success` boolean, required
    - `vmSteps` integer, required
  - `rowsRead` integer, required
  - `rowsWritten` integer, required
  - `storageUsedMib` integer, required

## Other responses

- `400`
- `401`
- `402`
- `404`
- `429`
- `500`

---

[API](https://skmtc.dev/tovuk/apis/tovuk-api.md) · [All operations](https://skmtc.dev/tovuk/apis/tovuk-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/tovuk/tovuk-api/revisions/830163d2c8bf/schema)