---
title: "Clickhouse Customers List"
method: GET
path: "/clickhouse/customers/"
tags: ["users"]
---

# Clickhouse Customers List

`GET /clickhouse/customers/`

List/search organizations (customers).

Supports both JWT and API key authentication.
Requires superadmin access (is_superadmin=True).

## Query parameters

- `page` integer
- `page_size` integer

## Headers

- `Authorization` string, required

## Response `200`

- PaginatedCHCustomerListList
  - `count` integer, required
  - `next` string, uri, nullable
  - `previous` string, uri, nullable
  - `total_count` integer
  - `current_filters` FilterParamDictPydantic — Pydantic model for FilterParamDict. A dictionary that maps metric names to their filter parameters. Each key is a metric name (str), and each value can be: - A single MetricFilterParamPydantic (one condition) - A List[MetricFilterParamPydantic] (multiple conditions for same metric) - A FilterBundlePydantic (nested filter bundle with connector) Note: Uses extra="allow" for dynamic metric name fields. The __pydantic_extra__ annotation tells Pydantic what types to expect for extra fields, and generates typed additionalProperties in JSON Schema.
  - `filters_data` PaginatedChCustomerListListFiltersData
  - `results` CHCustomerList[], required
    - `id` string, required
    - `organization_id` string, required
    - `unique_organization_id` string
    - `owner_email` string
    - `organization_name` string
    - `stripe_customer_identifier` string
    - `user_count` integer
    - `plan` string
    - `is_blocked` boolean
    - `disable_log` boolean
    - `first_seen` string, required
    - `starred` boolean
    - `last_active` string, required
    - `total_tokens` integer, required
    - `total_requests` integer, required
    - `total_cost` number, double, required
    - `active_days` integer
    - `credit_balance` number, double, nullable

---

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