> ## Documentation Index
> Fetch the complete documentation index at: https://docs.photon.codes/docs/llms.txt
> Use this file to discover all available pages before exploring further.

> ## Agent Instructions
> Use Stable documentation by default. Honor an explicit Beta request or a URL under /docs/beta/. If the requested version conflicts with the installed CLI package or API origin, clarify the target before writing integration code.
> Pages under /docs/beta/ document Beta; other product pages document Stable. Keep the CLI package, commands, API origin, and credentials within the selected version. State the documentation version in your answer.
> For MCP search, always pass version: Stable or version: Beta. Unfiltered search mixes both versions. For filesystem reads, keep Beta queries under /beta/ and exclude /beta/ from Stable queries; discover paths before reading them.
> The public docs base is https://photon.codes/docs. Convert MCP page paths to public URLs under that base, preserving /beta/ when present. Read https://photon.codes/docs/skill.md for version selection and https://photon.codes/docs/llms.txt for the version indexes.

# Query metrics

> Query metrics: queryMessageMetrics in the TypeScript, Python and Rust clients.

`POST /v1/projects/{projectId}/metrics/query`

Runs read-only SQL over the Project's message\_events or call\_events table. Get the SQL schema for supported columns, capabilities, and limits.

<Tabs>
  <Tab title="TypeScript">
    ```typescript TypeScript theme={null}
    photon.projects.queryMessageMetrics(input: QueryMessageMetricsInput, options?: RequestOptions): Promise<QueryMessageMetricsOutput>
    ```
  </Tab>

  <Tab title="Python">
    ```python Python theme={null}
    photon.projects.query_message_metrics(input: QueryMessageMetricsInput) -> models.QueryMessageMetricsResponse
    ```
  </Tab>

  <Tab title="Rust">
    ```rust Rust theme={null}
    client.query_message_metrics(project_id: String, params: Option<QueryMessageMetricsParams>, body: &types::ClickHouseSqlQueryRequest).await -> Result<ResponseValue<types::QueryMessageMetricsResponse>, Error<QueryMessageMetricsError>>
    ```
  </Tab>
</Tabs>

<RequestExample>
  ```typescript TypeScript theme={null}
  import { Photon } from "@photon-ai/api";

  const photon = new Photon({
    headers: { Authorization: `Bearer ${process.env.PHOTON_API_TOKEN}` },
  });
  const result = await photon.projects.queryMessageMetrics({
    path: {
      projectId: "projectId",
    },
    body: {
      sql: "sql",
    },
  });
  ```

  ```python Python theme={null}
  import os

  from photon_api import Photon
  from photon_api.rpc_generated import QueryMessageMetricsInput

  photon = Photon(headers={"Authorization": f"Bearer {os.environ['PHOTON_API_TOKEN']}"})
  result = photon.projects.query_message_metrics(
      QueryMessageMetricsInput.model_validate({
          "path": {
              "projectId": "projectId",
          },
          "body": {
              "sql": "sql",
          },
      })
  )
  ```

  ```rust Rust theme={null}
  use photon_ai_api::{Credential, PhotonClientBuilder, SecretString};

  let token = std::env::var("PHOTON_API_TOKEN")?;
  let client = PhotonClientBuilder::new()
      .credential("accountServiceKey", Credential::Bearer(SecretString::from(token)))
      .build()?;
  let result = client
      .query_message_metrics(
          "projectId".to_owned(),
          None,
          &serde_json::from_value(serde_json::json!({
              "sql": "sql",
          }))?,
      )
      .await
      .map_err(|error| format!("{error:?}"))?
      .into_inner();
  ```
</RequestExample>

<ResponseExample>
  ```json 200 theme={null}
  {
    "columns": [
      {
        "name": "string",
        "type": "string"
      }
    ],
    "rows": [
      [
        "string"
      ]
    ],
    "statistics": {
      "bytesRead": 0,
      "elapsedSeconds": 0,
      "rowsRead": 0
    }
  }
  ```
</ResponseExample>

## Parameters

<ParamField path="projectId" type={"string"} required />

<ParamField header="x-photon-version" type={"string (date)"}>
  API schema date. Defaults to the latest served version; resolves to the latest served date on or before this value.
</ParamField>

## Body

<ParamField body="parameters" type={"object"} />

<ParamField body="sql" type={"string"} required />

## Returns

**`200`** Dynamic SQL columns and rows followed by bounded ClickHouse read statistics. QueryMessageMetricsResponse

<ResponseField name="columns" type={"array of MessageMetricsQueryColumn"} required />

<ResponseField name="rows" type={"array of array of object"} required />

<ResponseField name="statistics" type={"MessageMetricsQueryStatistics"} required />


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.