---
title: "Execute a query within your schema"
method: POST
path: "/executeQuery"
tags: ["fiddles"]
---

# Execute a query within your schema

`POST /executeQuery`

Query the schema to see the results

## Request body

- object
  - `db_type_id` integer — The id of the database type returned from /dbTypes
  - `schema_short_code` string — The value for 'short_code' produced by the call to createSchema
  - `sql` string — The statements used to query within the schema
  - `statement_separator` string — The separator used to separate each statement within the ddl value

## Response `200`

successful operation

- object
  - `ID` integer
  - `sets` object[]
    - `SUCCEEDED` boolean
    - `STATEMENT` string
    - `EXECUTIONTIME` integer
    - `EXECUTIONPLAN` object[]
      - `COLUMNS` string[]
      - `DATA` array[]
        - unknown[] — The items for 'DATA' could be anything, based on the query definition. There will be one entry in each DATA item for each entry in the COLUMNS array
          - unknown
    - `EXECUTIONPLANRAW` object[]
      - `COLUMNS` string[]
      - `DATA` array[]
        - unknown[] — The items for 'DATA' could be anything, based on the query definition. There will be one entry in each DATA item for each entry in the COLUMNS array
          - unknown
    - `RESULTS` object[]
      - `COLUMNS` string[]
      - `DATA` array[]
        - unknown[] — The items for 'DATA' could be anything, based on the query definition. There will be one entry in each DATA item for each entry in the COLUMNS array
          - unknown

---

[API](https://skmtc.dev/zzzprojects/apis/sql-fiddle.md) · [All operations](https://skmtc.dev/zzzprojects/apis/sql-fiddle/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/zzzprojects/sql-fiddle/revisions/b325b8b31739/schema)