---
title: "Execute a read-only SQL query against ClickHouse"
method: POST
path: "/v0/sql"
tags: ["SQL"]
---

# Execute a read-only SQL query against ClickHouse

`POST /v0/sql`

## Request body

- object
  - `query` string, required

## Response `200`

Query executed successfully

- object
  - `data` object[]
  - `meta` object
    - `columns` object[]
      - `name` string
      - `type` string
    - `rows` integer
    - `statistics` object
      - `elapsed` number
      - `rows_read` integer
      - `bytes_read` integer

## Other responses

- `400` — Invalid or disallowed query
- `403` — Enterprise plan required
- `408` — Query timed out
- `503` — ClickHouse not configured

---

[API](https://skmtc.dev/pmxt-dev/apis/pmxt-hosted-router-api-2.md) · [All operations](https://skmtc.dev/pmxt-dev/apis/pmxt-hosted-router-api-2/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/pmxt-dev/pmxt-hosted-router-api-2/revisions/50653c6d513e/schema)