List Saved Queries

curl -X GET https://api.trellis.sh/v1/queries \
  -H "Authorization: Bearer YOUR_TOKEN"

import requests

response = requests.get(
    "https://api.trellis.sh/v1/queries",
    headers={"Authorization": "Bearer YOUR_TOKEN"}
)
queries = response.json()["queries"]

const response = await fetch("https://api.trellis.sh/v1/queries", {
  headers: { Authorization: "Bearer YOUR_TOKEN" },
});
const { queries } = await response.json();

{
  "queries": [
    {
      "id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
      "organization_id": "20000000-0000-4000-8000-000000000001",
      "title": "Monthly Order Value",
      "description": "Total order value grouped by month for a selected year",
      "prompt": "Summarize monthly order value and highlight notable changes.",
      "sql": "SELECT DATEFROMPARTS(YEAR(CreatedAt), MONTH(CreatedAt), 1) AS [Month], SUM(Amount) AS TotalAmount FROM dbo.Orders WHERE YEAR(CreatedAt) = {{year}} GROUP BY YEAR(CreatedAt), MONTH(CreatedAt) ORDER BY [Month]",
      "parameters": ["year"],
      "last_updated_by": "30000000-0000-4000-8000-000000000001",
      "last_updated_by_name": "John Doe",
      "created_at": "2026-08-01T10:00:00+00:00",
      "updated_at": "2026-08-02T15:30:00+00:00"
    }
  ]
}

curl -X GET https://api.trellis.sh/v1/queries \
  -H "Authorization: Bearer YOUR_TOKEN"

import requests

response = requests.get(
    "https://api.trellis.sh/v1/queries",
    headers={"Authorization": "Bearer YOUR_TOKEN"}
)
queries = response.json()["queries"]

const response = await fetch("https://api.trellis.sh/v1/queries", {
  headers: { Authorization: "Bearer YOUR_TOKEN" },
});
const { queries } = await response.json();

{
  "queries": [
    {
      "id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
      "organization_id": "20000000-0000-4000-8000-000000000001",
      "title": "Monthly Order Value",
      "description": "Total order value grouped by month for a selected year",
      "prompt": "Summarize monthly order value and highlight notable changes.",
      "sql": "SELECT DATEFROMPARTS(YEAR(CreatedAt), MONTH(CreatedAt), 1) AS [Month], SUM(Amount) AS TotalAmount FROM dbo.Orders WHERE YEAR(CreatedAt) = {{year}} GROUP BY YEAR(CreatedAt), MONTH(CreatedAt) ORDER BY [Month]",
      "parameters": ["year"],
      "last_updated_by": "30000000-0000-4000-8000-000000000001",
      "last_updated_by_name": "John Doe",
      "created_at": "2026-08-01T10:00:00+00:00",
      "updated_at": "2026-08-02T15:30:00+00:00"
    }
  ]
}

Saved queries store reusable, parameterized SQL Server queries paired with a natural-language formatting instruction. Run one as a chat turn over the WebSocket or the durable REST turn endpoint. The server executes the stored SQL through the same datasource permission gates used by the agent, emits synthetic tool_call and tool_result frames, then asks the model to format the result using the stored prompt. There is no standalone saved-query execution endpoint. The turn must have a datasource integration. Supply every parameter value as a string. The turn’s free-text message is persisted for display, but the stored saved-query prompt is the instruction passed to the model. This endpoint returns only user-visible queries (display = true), ordered by most recent update. It is not paginated.

string

required

Bearer token obtained from the authenticate endpoint.

Response

array

required

List of saved queries.

Show Query object

string

required

Unique identifier for the saved query.

string

required

Organization the query belongs to.

string

required

Display title for the query.

string | null

Optional human-readable description of what the query does.

string

required

The natural language instruction passed to the AI agent when this query is invoked.

string | null

The SQL Server statement stored for this query. It may contain {{param_name}} placeholders. Although the storage API accepts null, a saved query needs SQL to run as a chat turn.

string[]

required

Unique placeholder names found in sql, in first-appearance order. Supply every value as a string when running the query over WebSocket or REST.

string

required

Member ID of the user who last modified this query.

string

Display name of the user who last modified this query.

string

required

ISO 8601 timestamp when the query was created.

string

required

ISO 8601 timestamp when the query was last modified.

curl -X GET https://api.trellis.sh/v1/queries \
  -H "Authorization: Bearer YOUR_TOKEN"

import requests

response = requests.get(
    "https://api.trellis.sh/v1/queries",
    headers={"Authorization": "Bearer YOUR_TOKEN"}
)
queries = response.json()["queries"]

const response = await fetch("https://api.trellis.sh/v1/queries", {
  headers: { Authorization: "Bearer YOUR_TOKEN" },
});
const { queries } = await response.json();

{
  "queries": [
    {
      "id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
      "organization_id": "20000000-0000-4000-8000-000000000001",
      "title": "Monthly Order Value",
      "description": "Total order value grouped by month for a selected year",
      "prompt": "Summarize monthly order value and highlight notable changes.",
      "sql": "SELECT DATEFROMPARTS(YEAR(CreatedAt), MONTH(CreatedAt), 1) AS [Month], SUM(Amount) AS TotalAmount FROM dbo.Orders WHERE YEAR(CreatedAt) = {{year}} GROUP BY YEAR(CreatedAt), MONTH(CreatedAt) ORDER BY [Month]",
      "parameters": ["year"],
      "last_updated_by": "30000000-0000-4000-8000-000000000001",
      "last_updated_by_name": "John Doe",
      "created_at": "2026-08-01T10:00:00+00:00",
      "updated_at": "2026-08-02T15:30:00+00:00"
    }
  ]
}

Overview

Authentication

Agents

Datasources

Saved Queries

Models

Chats

Artifacts

Jobs

Voice

Audio

User Memories

Organization Rules

Admin

Response

​Response

Response