---
title: "POST /api/ee/workspace/{ws-id}/query"
method: POST
path: "/api/ee/workspace/{ws-id}/query"
tags: ["/api/ee/workspace"]
---

# POST /api/ee/workspace/{ws-id}/query

`POST /api/ee/workspace/{ws-id}/query`

Execute an arbitrary SQL query in the workspace's isolated database context.
   Table references are remapped to isolated workspace tables.
   Returns the first 2000 rows of query results.

## Path parameters

- `ws-id` integer, required — value must be an integer greater than zero.

## Request body

- object
  - `sql` string, required

## Response `2XX`

Successful response

- MetabaseEnterpriseWorkspacesTypesQueryResult — Result of a query preview (dry-run or ad-hoc query). Data is nested under :data to match /api/dataset response format.
  - `ancestors` MetabaseEnterpriseWorkspacesTypesAncestorsResult — Result of running stale ancestor transforms.
    - `failed` MetabaseEnterpriseWorkspacesTypesRefId[], required
    - `not_run` MetabaseEnterpriseWorkspacesTypesRefId[], required
    - `succeeded` MetabaseEnterpriseWorkspacesTypesRefId[], required
  - `data` object
    - `cols` object[]
    - `results_metadata` object
      - `columns` object[]
    - `rows` unknown[]
      - unknown
  - `message` string, nullable
  - `running_time` integer, nullable
  - `started_at` unknown
  - `status` 'succeeded' | 'failed', required

## Other responses

- `4XX` — Client error response
- `5XX` — Server error response

## Changes

- **2026-03-09** `78297d193ca4` — 1 info
  - endpoint added

[Change history](https://skmtc.dev/metabase/apis/metabase-api/changes/api/ee/workspace/:ws-id/query/post.md)

---

[API](https://skmtc.dev/metabase/apis/metabase-api.md) · [All operations](https://skmtc.dev/metabase/apis/metabase-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/metabase/metabase-api/revisions/cb841428e285/schema)