---
title: "Query a database"
method: POST
path: "/v0/api/databases/{databaseId}/query"
tags: ["Databases"]
---

# Query a database

`POST /v0/api/databases/{databaseId}/query`

## Request

- Base URL: `https://api.anything.com`
- URL: `https://api.anything.com/v0/api/databases/{databaseId}/query`
- Auth: HTTP basic
- TypeScript: <https://skmtc.dev/anything/apis/anything-api/docs/v0/api/databases/:databaseId/query/post.ts> (a function with typed inputs; its response is checked against the schema)

Executes a read-only SQL query against the database. Only SELECT, WITH, EXPLAIN, and SHOW statements are allowed.

## Path parameters

- `databaseId` string, uuid, required

## Request body

- object
  - `sql` string, required

## Response `200`

Query results

- object
  - `columns` string[], required
  - `rows` array[], required
    - unknown[]
      - unknown
  - `rowCount` number, required

## Other responses

- `400`: Invalid request
- `401`: Unauthorized
- `403`: Forbidden
- `404`: Database not found

---

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