---
title: "List Query History"
method: GET
path: "/api/v1/insights/history"
tags: ["Insights"]
---

# List Query History

`GET /api/v1/insights/history`

Returns a paginated history of recently executed queries with timing and row counts.

## Query parameters

- `page[limit]` integer
- `page[offset]` integer

## Response `200`

Paginated list of history entries

- PaginatedHistoryEntryList — Paginated list of query history entries.
  - `data` HistoryEntry[], required
    - `id` string, required — Unique history entry identifier.
    - `sql` string, required — SQL query that was executed.
    - `timestamp` string, date-time, required — ISO 8601 timestamp of execution.
    - `elapsed` number, required — Query execution time in seconds.
    - `row_count` integer, required — Number of rows returned.
  - `meta` PaginationMeta, required — Pagination metadata included in every paginated response.
    - `has_more` boolean, required — Whether additional pages of results are available.
    - `total` integer — Total number of items matching the current filters. Optional — only populated by endpoints that compute the full count cheaply (e.g. in-memory filtering). When omitted, clients should rely on `has_more` and cursor through pages.

---

[API](https://skmtc.net/fabro-sh/apis/fabro-run-api.md) · [All operations](https://skmtc.net/fabro-sh/apis/fabro-run-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/fabro-sh/fabro-run-api/revisions/52f1d8aaf083/schema)