enclave-bay.vercel.app

run_sql

Run a read-only DuckDB SQL SELECT against the table `data` and return the result. This is your main instrument. DuckDB dialect: bucket months with strftime(order_date, '%Y-%m'), and compare dates as ISO strings. Group by several dimensions at once rather than issuing one query per dimension. Results are capped at 50 rows and 4 KB, so aggregate rather than selecting raw rows. `data` already reflects any global filter.

Page: /app

Input schema

{
  "type": "object",
  "properties": {
    "sql": {
      "type": "string",
      "description": "A SELECT statement referencing the table `data`"
    }
  },
  "required": [
    "sql"
  ],
  "additionalProperties": false
}