---
title: "Get database schema"
method: GET
path: "/v1/helicone-sql/schema"
tags: ["HeliconeSql"]
---

# Get database schema

`GET /v1/helicone-sql/schema`

Get ClickHouse schema (tables and columns)

## Response `200`

Array of table schemas with columns

- union
  - ResultSuccessClickHouseTableSchemaArray
    - `data` ClickHouseTableSchema[], required
      - `table_name` string, required
      - `columns` ClickHouseTableColumn[], required
        - `name` string, required
        - `type` string, required
        - `default_type` string
        - `default_expression` string
        - `comment` string
        - `codec_expression` string
        - `ttl_expression` string
    - `error` null, nullable, required
  - ResultErrorString
    - `data` null, nullable, required
    - `error` string, required

---

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