---
title: "Extract Structured Data"
method: POST
path: "/api/databases/{connection_id}/extract"
tags: ["Database Connections"]
---

# Extract Structured Data

`POST /api/databases/{connection_id}/extract`

Extract data from database and optionally structure it with AI

Similar to document extraction, but from database queries

Args:
    connection_id: Database connection ID
    extract_request: Query, max rows, and AI structuring option

Returns:
    Raw query results + AI-structured data (if requested)

## Path parameters

- `connection_id` string, required

## Request body

- ExtractRequest — Request model for extracting structured data from database
  - `query` string, required
  - `max_rows` integer
  - `structure_with_ai` boolean

## Response `200`

Successful Response

- unknown

## Other responses

- `422` — Validation Error

---

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