get-ratelimits - Unkey Docs

Run SQL queries against your rate limit analytics. Queries can use the raw ratelimits_v1 table or the per-minute, per-hour, per-day, and per-month aggregate tables. Unkey restricts every query to the authenticated workspace. Workspace retention and query limits apply.

Usage

unkey api analytics get-ratelimits [flags]

Flags

string

required

SQL query to execute against your rate limit analytics data. The query can reference ratelimits_v1, ratelimits_per_minute_v1, ratelimits_per_hour_v1, ratelimits_per_day_v1, or ratelimits_per_month_v1.

Global flags

Flag	Type	Description
`--root-key`	string	Override root key (`$UNKEY_ROOT_KEY`)
`--api-url`	string	Override API base URL (default: `https://api.unkey.com`)
`--config`	string	Path to config file (default: `~/.unkey/config.toml`)
`--output`	string	Output format. Use `json` for raw JSON
`--body`	string	Send this JSON string as the request body. You cannot combine it with request-building flags.

Examples

unkey api analytics get-ratelimits \
  --query="SELECT namespace_id, COUNT(*) AS total FROM ratelimits_v1 WHERE namespace_id = 'rlns_123' GROUP BY namespace_id"

unkey api analytics get-ratelimits \
  --query="SELECT time, sum(total) AS requests FROM ratelimits_per_hour_v1 WHERE namespace_id = 'rlns_123' GROUP BY time ORDER BY time"

See Query rate limit analytics for table schemas, query restrictions, and more examples.

Last modified on August 25, 2026

⌘I