---
title: "Execute an SQL query"
method: POST
path: "/project/{project}/service/{service_name}/clickhouse/query"
tags: ["Service:_ClickHouse"]
---

# Execute an SQL query

`POST /project/{project}/service/{service_name}/clickhouse/query`

Executes an SQL query.

## Path parameters

- `project` string, required
- `service_name` string, required

## Request body

- ServiceClickHouseQueryRequestBody — ServiceClickHouseQueryRequestBody
  - `database` string, required — Service database name
  - `query` string, required — Query

## Response `200`

Response

- ServiceClickHouseQueryResponse — ServiceClickHouseQueryResponse
  - `data` array[], required — Data
    - unknown[]
      - unknown
  - `errors` object[] — List of errors occurred during request processing
    - `message` string, required — Printable error message
    - `more_info` string — URL to the documentation of the error
    - `status` integer, required — HTTP error status code
  - `message` string — Printable result of the request
  - `meta` object[], required — Meta
    - `name` string, required — Column name
    - `type` string, required — Column type
  - `summary` object, required — Summary
    - `elapsed_ns` integer — Elapsed time in nanoseconds
    - `read_bytes` integer — Number of bytes read
    - `read_rows` integer — Number of rows read
    - `result_bytes` integer — Number of bytes in the result
    - `result_rows` integer — Number of rows in the result
    - `written_bytes` integer — Number of bytes written
    - `written_rows` integer — Number of rows written

---

[API](https://skmtc.net/aiven/apis/aiven-api-documentation.md) · [All operations](https://skmtc.net/aiven/apis/aiven-api-documentation/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/aiven/aiven-api-documentation/versions/ecaeabf1da31/schema)