litellm/litellm-proxy-extras/litellm_proxy_extras/migrations
tin-berri 32deaff015
feat(spend): rebuild the auto-router benchmarks backend as a per-session rollup (#35910)
Folds every successful auto-routed request into LiteLLM_AutoRouterSession with one
conditional upsert at spend-write time, classifying each turn (same model, first
visit, return to tier, out of order) against the row's own columns so nothing is
read before the write. The upsert's placeholders and argument tuple both derive
from the transaction dataclass's own field order, so the SQL and the call site
cannot drift apart. GET /auto_router/benchmarks aggregates the rollup, grouped
by the full (router, type) identity, and never scans LiteLLM_SpendLogs. A turn's
cache interaction is derived once from its usage record (savings.py owns the
extraction; compute_savings_spend derives cache reads from usage_object itself),
hits are counted order-independently so the overall hit rate matches its covered
denominator, caller-chosen session ids are bounded before entering the primary
key, and a poisoned statement drops only its own session's remaining turns.
Return misses inside the recorded TTL are named for what the telemetry shows
(within_ttl) rather than a presumed cause, since a provider can evict early.
Savings ride each router's derived baseline by default, so the response carries
no deployment-wide baseline label. Rollup retention has its own
maximum_autorouter_session_retention_period setting, pattern-identical to the
spend-logs knob and running in the same cleanup job on its own cutoff. Every
drain trigger sizes the queues through one owner and the enqueue honors
disable_spend_logs beside the tool-usage queue it mirrors.
2026-08-05 20:06:32 +00:00
..
20260108_add_user_email_lower_idx fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250326162113_baseline fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250326171002_add_daily_user_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250327180120_add_api_requests_to_daily_user_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250329084805_new_cron_job_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250331215456_track_success_and_failed_requests_daily_agg_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250411215431_add_managed_file_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250412081753_team_member_permissions fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250415151647_add_cache_read_write_tokens_daily_spend_transactions fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250415191926_add_daily_team_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250416115320_add_tag_table_to_db fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250416151339_drop_tag_uniqueness_requirement fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250416185146_add_allowed_routes_litellm_verification_token fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250425182129_add_session_id fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250430193429_add_managed_vector_stores fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250507161526_add_mcp_table_to_db fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250507161527_add_health_check_fields_to_mcp_servers fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250507184818_add_mcp_key_team_permission_mgmt fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250508072103_add_status_to_spendlogs fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250509141545_use_big_int_for_daily_spend_tables build: use big int for daily spend tables 2025-05-09 14:16:18 -07:00
20250510142544_add_session_id_index_spend_logs fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250514142245_add_guardrails_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250522223020_managed_object_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250526154401_allow_null_entity_id build(ui/): Allow empty values in daily agg table + reintroduce 'unassigned' teams in spend tracking 2025-05-26 22:03:34 -07:00
20250528185438_add_vector_stores_to_object_permissions fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250603210143_cascade_budget_changes fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250618225828_add_health_check_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250625145206_cascade_budget_and_loosen_managed_file_json fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250625213625_add_status_to_managed_object_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250707212517_add_mcp_info_column_mcp_servers fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250707230009_add_mcp_namespaced_tool_name fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250711220620_add_stdio_mcp fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250718125714_add_litellm_params_to_vector_stores fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250802162330_prompt_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250806095134_rename_alias_to_server_name_mcp_table added new migration files (#13345) 2025-08-06 13:12:39 -07:00
20250918083359_drop_spec_version_column_from_mcp_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20250926194702_unnamed_migration fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251003165142_add_allowed_tools_to_mcp fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251003190954_extra_headers_to_mcp_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251006143948_add_mcp_tool_permissions fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251011084309_add_tag_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251023141814_add_search_tool_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251031181430_add_cache_config_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251101131415_add_managed_vector_store_index_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251103072422_add_static_headers fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251104220043_add_credentials_to_mcp_servers fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251113000000_add_project_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251113000001_add_project_fields fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251114173537_add_request_id_to_daily_tag_spend fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251114180624_Add_org_usage_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251114182247_agents_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251119131227_add_prompt_versioning fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251122125322_Add organization_id to spend logs fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251204124859_add_end_user_spend_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251204142718_add_agent_permissions [Feat] Agent Access Control - Enforce Allowed agents by key, team + add agent access groups on backend (#17502) 2025-12-04 16:31:00 -08:00
20251209112246_add_ui_settings_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251210125210_add_storage_backend_to_managed_files Add support for target_storage param 2025-12-11 15:08:17 +05:30
20251210205007_add_daily_agent_spend_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251211100212_schema_sync [Fix] CI/CD – Clean Up Performance PR Changes & others (#17838) 2025-12-11 12:50:03 -08:00
20251219110931_add_deleted_keys_and_deleted_teams_tables fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20251220144550_schema_update fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260102131258_add_metadata_urls_to_mcp_servers fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260105151539_add_allow_all_keys_to_mcp_servers fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260106155622_add_endpoint_to_daily_activity_tables fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260107111013_add_router_settings_to_keys_teams fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260116142756_update_deleted_keys_teams_table_routing_settings fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260123131407_add_policy_tables_and_policies_field fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260131150814_add_team_user_to_vector_stores fix: Make vector stores migration idempotent (#21325) 2026-02-16 18:36:36 -08:00
20260203120000_add_deprecated_verification_token_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260205091235_allow_team_guardrail_config fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260205144610_add_soft_budget_to_team_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260207093506_add_available_on_public_internet_to_mcp_servers fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260207110613_add_soft_budget_to_deleted_teams_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260209085821_add_verificationtoken_indexes fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260212103349_adjust_tags_policy_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260212143306_add_access_group_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260213105436_add_managed_vector_store_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260213170952_access_group_change_to_model_name fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260214094754_schema_sync fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260214163027_add_pipeline_to_policy_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260214185341_object_permissions_for_end_users fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260218231534_add_last_active_to_key_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260219105005_add_project_id_to_deleted_keys fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260219181415_baseline_diff fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260220124742_add_spec_path_to_mcp_servers fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260220153844_add_composite_index_aggregate_tables fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260221000000_ensure_project_id_verification_token fix(migrations): add ensure_project_id migration + bump litellm-proxy-extras to 0.4.46 (#21800) 2026-02-21 12:15:21 -08:00
20260221183800_add_policy_versioning fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260222000000_add_batch_processed_to_managed_object_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260224201417_spend_logs_request_duration fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260224203854_add_agent_object_permissions_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260226000000_add_blocked_tools_to_object_permission fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260226120000_add_spend_log_tool_index fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260226202727_add_agent_id_to_delete_keys fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260228000000_add_claude_code_plugin_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260228100000_add_spend_logs_composite_index fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260228110000_mcp_default_public_internet_true [Release Fix] (#22411) 2026-02-28 09:46:35 -08:00
20260228170127_support_team_based_guardrails fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260303000000_update_tool_table_policies fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260304175016_add_spend_to_agent_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260305000000_add_agent_headers feat(agents): add Prisma migration for agent header columns 2026-03-05 14:28:36 +05:30
20260305000000_add_rate_limits_to_agents fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260306175056_add_configs_override_table fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260306233848_schema_sync fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260309000000_add_mcp_approval_status feat(mcp): BYOM — non-admin MCP server submission + admin review workflow (#23205) 2026-03-10 13:58:59 -07:00
20260309000001_add_mcp_source_url feat(mcp): BYOM — non-admin MCP server submission + admin review workflow (#23205) 2026-03-10 13:58:59 -07:00
20260312124619_schema_sync fix: prisma migrate deploy failures on pre-existing instances (#23655) 2026-03-14 16:54:21 -07:00
20260318140652_add_index_to_team_table Add IF NOT EXISTS to index creation in migration 2026-03-19 09:22:10 +01:00
20260319000000_restore_mcp_approval_fields fix(schema): restore MCP server fields dropped by schema_sync migration 2026-03-19 10:55:17 +07:00
20260321000000_add_mcp_toolsets Litellm ishaan march23 - MCP Toolsets + GCP Caching fix (#25146) (#25155) 2026-04-04 16:23:21 -07:00
20260331000000_add_prompt_environment_and_created_by Litellm ishaan april1 try2 (#25110) 2026-04-03 14:57:44 -07:00
20260401000000_add_budget_limits feat: multiple concurrent budget windows per API key and team (#24883) (#25109) 2026-04-06 14:02:04 -07:00
20260401000000_add_team_member_model_scope feat(teams): per-member model scope + team default_team_member_models (#24950) 2026-04-06 13:48:43 -07:00
20260414140000_add_mcp_server_instructions feat(mcp): gateway InitializeResult.instructions from upstream or YAML 2026-04-14 14:19:31 +03:00
20260415120000_health_check_latest_per_model_index Added concurrent index creation. Added necessary disclaimers to index creation. 2026-04-15 22:52:47 +00:00
20260418000000_add_adaptive_router_tables fix(adaptive_router): 3 P1 review defects 2026-04-20 15:22:18 -07:00
20260421120000_add_memory_table feat(proxy): add /v1/memory CRUD endpoints (#26218) 2026-04-24 18:38:07 -07:00
20260421135425_add_team_membership_total_spend fix: harden /key/update authorization checks (#27878) 2026-05-14 04:16:04 +00:00
20260429120000_search_tools_on_object_permission Add migration script 2026-04-29 12:30:10 +05:30
20260429161855_workflow_runs_tables feat(proxy): durable agent workflow run tracking via /v1/workflows/runs (#26793) 2026-04-29 17:12:18 -07:00
20260501195714_managed_resource_team_owner fix(proxy): normalize managed resource team owner field 2026-05-04 17:05:50 -07:00
20260513120000_add_delegate_auth_to_upstream_to_mcp_servers feat(mcp): add delegate_auth_to_upstream flag for PKCE passthrough (#27834) 2026-05-13 12:06:13 -07:00
20260514120000_add_blocked_to_proxy_model_table Litellm oss staging (#28161) 2026-05-18 16:27:44 -07:00
20260520120000_add_mcp_env_vars feat(mcp): per-server env vars with global + per-user scopes (#28917) 2026-06-05 20:15:11 -07:00
20260526120000_add_oauth_passthrough_to_mcp_servers [internal copy of #28008] Support MCP OAuth passthrough and issuer-scoped JWT auth (#28356) 2026-06-02 12:22:04 -07:00
20260604120000_add_oauth2_flow_to_mcp_servers fix(proxy): persist oauth2_flow on MCP server registration (#29690) 2026-06-05 18:52:52 +05:30
20260605182307_add_timeout_to_mcp_server_table Litellm oss staging 050626 (#29774) 2026-06-05 13:51:51 -07:00
20260626120000_add_mcp_tool_search_enabled feat(mcp): add mcp_tool_search virtual tools for large tool catalogs (#31777) 2026-06-30 20:03:59 -07:00
20260629000000_add_max_concurrent_requests_to_mcp_server_table feat(mcp): bound outbound tool-call concurrency per MCP server (#31641) 2026-07-02 15:33:44 -07:00
20260630120000_add_token_exchange_to_mcp_servers feat(mcp): support oauth2_token_exchange auth type via REST API and dashboard (#31772) 2026-07-07 15:26:12 -07:00
20260630190000_add_budget_fallbacks_to_litellm_verification_token feat(proxy): add key-level budget_fallbacks to reroute requests when a per-model budget is exceeded (#31783) 2026-07-03 12:20:12 -07:00
20260703120000_add_token_exchange_profile_to_mcp_servers feat(mcp): let users select the entra_obo token_exchange profile in the UI and API (#32144) 2026-07-07 16:39:20 -07:00
20260710000000_add_dcr_bridge_to_mcp_server_table feat(mcp): add dcr_bridge column and plumbing for client-forwarded auth modes 2026-07-10 00:14:45 -07:00
20260713230852_add_key_type_to_litellm_verification_token fix(keys): persist key_type so the UI shows correct key scope instead of "All Proxy Models" (#33115) 2026-07-13 18:08:43 -07:00
20260715000000_add_issuer_to_mcp_server_table feat(mcp): issuer-anchored OAuth discovery (RFC 8414 §3.3) as the trust anchor 2026-07-15 16:59:01 -07:00
20260717000000_add_compression_saved_tokens feat(spend): track prompt compression saved tokens in daily spend aggregates (#33810) 2026-07-18 17:47:54 -07:00
20260717000000_add_mcp_server_oauth_client_table fix(mcp): persist config.yaml DCR clients in a server-scoped store 2026-07-17 19:42:32 -07:00
20260718000000_add_savings_spend feat(spend): track prompt compression saved tokens in daily spend aggregates (#33810) 2026-07-18 17:47:54 -07:00
20260721000000_add_sso_identity_assertion feat(mcp): store the enterprise IdP identity assertion at SSO login for EMA egress 2026-07-21 14:54:37 -07:00
20260724000000_add_spend_log_tool_index_start_time_idx fix(proxy): cap tool spend window at 30 days and bound every SpendLogs read 2026-07-24 17:24:24 -07:00
20260725000000_add_daily_tool_spend fix(proxy): roll up tool spend daily instead of scanning SpendLogs 2026-07-25 21:52:58 -07:00
20260729000000_add_reload_tracking_to_litellm_config fix(proxy): persist periodic reload schedule state so status survives restarts and fires without store_model_in_db (#35165) 2026-08-04 15:42:57 -07:00
20260731000000_add_autorouter_savings_spend feat(spend): add net auto-router savings to the cost-optimization dashboard (#35521) 2026-08-04 03:10:37 +00:00
20260803000000_add_daily_gateway_requests feat(sgr): make the gateway middleware the source of truth for successful requests (#35717) 2026-08-05 12:40:47 -07:00
20260805000000_add_autorouter_session_rollup feat(spend): rebuild the auto-router benchmarks backend as a per-session rollup (#35910) 2026-08-05 20:06:32 +00:00
migration_lock.toml install prisma migration files - connects litellm proxy to litellm's prisma migration files (#9637) 2025-03-29 15:27:09 -07:00