---
title: "Query Database"
method: GET
path: "/api/v1/databases/{database_id}/query"
tags: ["databases"]
---

# Query Database

`GET /api/v1/databases/{database_id}/query`

Run a DuckDB SQL query against the database's Parquet data.

## Path parameters

- `database_id` string, uuid, required

## Query parameters

- `sql` string, required — SQL query (table is named 'data')
- `limit` integer

## Response `200`

Successful Response

- DataQueryResponse
  - `columns` string[], required
  - `rows` object[], required
  - `total_rows` integer, required
  - `truncated` boolean, required

## Other responses

- `422` — Validation Error

---

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