---
title: "Execute a SQL query"
method: POST
path: "/query/sql"
tags: ["Query API"]
---

# Execute a SQL query

`POST /query/sql`

Run SQL queries on StarTree Cloud's real-time analytics engine.

## Headers

- `database` string, required

## Request body

- object
  - `sql` string, required

## Response `200`

Query executed successfully.

- object
  - `resultTable` object
    - `dataSchema` object
      - `columnNames` string[]
      - `columnDataTypes` string[]
    - `rows` array[]
      - unknown[]
        - unknown

---

[API](https://skmtc.net/startree/apis/pinot-controller-api.md) · [All operations](https://skmtc.net/startree/apis/pinot-controller-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/startree/pinot-controller-api/revisions/f1cc8a0ba2e0/schema)