pin_live_query
Keep a live query URL alive, name it, or kill it (#2374). Every execute_sql over the curated warehouse returns a live_url — a link that re-runs THAT query and returns the latest rows as JSON on a plain GET, with no API key, because the id in the link is the access and it grants only that one query. Those links last 24 hours. Pin one the moment a user is going to put it anywhere durable: a dashboard they host, an HTML file, an embedded widget, a chart they want to keep. Omit days for an indefinite link — that is usually what they want. Pass revoke: true to kill a link permanently; re-creating the same query then gives a DIFFERENT url, so the old one stays dead. Whenever you hand a user a live URL, tell them plainly that anyone with the link can read that data.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"live_url": "<live_url>"
},
"name": "pin_live_query"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| days | No | How many more days it should answer for. **Omit for indefinite** — the right choice when the user is putting the URL somewhere durable, which is the whole reason to pin one. | |
| label | No | What this link is for, in the user's words: "SA wind vs price, hourly". Shown in `list_live_queries`, which is the only way anyone tells their links apart later. | |
| revoke | No | Pass `true` to kill the URL instead. Immediate and permanent: anything polling it starts getting 404s, and pinning the same SQL again mints a NEW url, so whoever holds the old one stays locked out. | |
| live_url | Yes | The live query to keep, as the `live_url` an `execute_sql` response returned or the bare id out of it. Both work — pass whichever you have. | |
| question_id | No | Optional UUID returned by an earlier `start_question` call. When provided, this tool call is attributed to that question. |