---
title: "Ask Remy Data Endpoint"
method: POST
path: "/api/v1/remy/ask"
tags: ["remy", "remy"]
---

# Ask Remy Data Endpoint

`POST /api/v1/remy/ask`

Ask a plain-English question about the Remy tables and get the rows back.

gpt-4o-mini writes one SELECT against the remy_* schema; it is checked before it
runs and then executed READ ONLY under its own statement timeout, so no question
can write, reach another schema, or hold a worker open. The statement comes back
on the response so any answer can be audited against what actually ran.

Internal accounts only — a generated statement cannot be reliably scoped to one
user's roster, so the route is gated on shared-corpus access rather than trusting
the model to filter by user_id.

## Request body

- RemyDataQuestionRequestDTO — One plain-English question about the Remy tables.
  - `question` string, required

## Response `200`

Successful Response

- RemyDataQuestionResponseDTO
  - `question` string, required
  - `answerable` boolean, required
  - `sql` string, nullable
  - `explanation` string, nullable
  - `row_count` integer
  - `rows` object[]
  - `truncated` boolean

## Other responses

- `422` — Validation Error

## Changes

> 15 revisions in range; 1 not diffed.

- **2026-09-16** `dda5cf04b73d` — 1 info
  - endpoint added

[Change history](https://skmtc.dev/brandbooster/apis/fastapi/changes/api/v1/remy/ask/post.md)

---

[API](https://skmtc.dev/brandbooster/apis/fastapi.md) · [All operations](https://skmtc.dev/brandbooster/apis/fastapi/llms.txt) · [OpenAPI document](https://skmtc.dev/brandbooster/apis/fastapi/revisions/7ba0627b6b4c?raw)