---
title: "Get Clickhouse Queries"
method: GET
path: "/api/langfuse/queries"
tags: ["langfuse"]
---

# Get Clickhouse Queries

`GET /api/langfuse/queries`

Get ClickHouse queries from Langfuse observations.

Fetches observations with name 'mcp__altimate__clickhouse_query' from Langfuse
within the specified date range. Returns paginated results.

## Query parameters

- `start_date` string, nullable — Start date in ISO format
- `end_date` string, nullable — End date in ISO format
- `page` integer — Page number
- `limit` integer — Results per page

## Response `200`

Successful Response

- LangfuseQueriesResponse — Response containing ClickHouse queries.
  - `queries` ClickHouseQueryDetail[] — List of queries
    - `id` string, required — Observation ID
    - `query` string, required — SQL query text
    - `tables` string[] — Tables referenced
    - `session_id` string, nullable — Session ID if available
    - `trace_id` string, required — Trace ID
    - `user_id` string, nullable — User ID
    - `tenant` string, required — Tenant name
    - `executed_at` string, date-time, required — Execution timestamp
    - `duration_ms` number, nullable — Execution duration in ms
    - `status` string, required — Execution status
    - `error_message` string, nullable — Error message if failed
    - `result_preview` object[], nullable — Preview of query results
  - `total_pages` integer, required — Total number of pages
  - `current_page` integer, required — Current page number
  - `has_more` boolean — Whether there are more pages
  - `langfuse_project_id` string, nullable — Langfuse project ID for constructing trace links

## Other responses

- `422` — Validation Error

---

[API](https://skmtc.net/myaltimate/apis/fastapi.md) · [All operations](https://skmtc.net/myaltimate/apis/fastapi/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/myaltimate/fastapi/versions/aab3fe5c9f05/schema)