coder/coderd/database/migrations/000441_chat_usage_limits.down.sql at coder-agents-mv0p - coder - Gitea: Git with a cup of tea

shishantbiswas/coder

mirror of https://github.com/coder/coder.git synced 2026-06-03 21:18:24 +00:00

Files

T

Michael Suchacz 1031da9738 feat: add agent chat spend limiting (backend) (#23071 )

Introduces deployment-scoped spend limiting for Coder Agents, enabling
administrators to control LLM costs at global, group, and individual
user levels.

## Changes

- **Database migration (000437)**: `chat_usage_limit_config`
(singleton), `chat_usage_limit_overrides` (per-user),
`chat_usage_limit_group_overrides` (per-group)
- **Single-query limit resolution**: individual override > min(group) >
global default via `ResolveUserChatSpendLimit`
- **Fail-open enforcement** in chatd with documented TOCTOU trade-off
- **Experimental API** under `/api/experimental/chats/usage-limits` for
CRUD on limits
- **`AsChatd` RBAC subject** for narrowly-scoped daemon access (replaces
`AsSystemRestricted`)
- **Generated TypeScript types** for the frontend SDK

## Hierarchy

1. Individual user override (highest)
2. Minimum of group limits
3. Global default
4. Disabled / unlimited

Currency stored as micro-dollars (`1,000,000` = $1.00).

Frontend PR: #23072

2026-03-17 01:24:03 +01:00

5 lines

229 B

SQL

Raw Permalink Blame History

 DROP INDEX IF EXISTS idx_chat_messages_owner_spend;
 ALTER TABLE groups DROP COLUMN IF EXISTS chat_spend_limit_micros;
 ALTER TABLE users DROP COLUMN IF EXISTS chat_spend_limit_micros;
 DROP TABLE IF EXISTS chat_usage_limit_config;