litellm/litellm-proxy-extras/litellm_proxy_extras/migrations
devin-ai-integration[bot] 001457af8b
fix(keys): persist key_type so the UI shows correct key scope instead of "All Proxy Models" (#33115)
* fix(ui): derive key model scope so SCIM/management/read-only keys stop showing 'All Proxy Models'

key_type is not persisted on a key (the proxy maps it to allowed_routes and
drops it), so the keys tables only inspected the models list and rendered
'All Proxy Models' for any key with an empty models array, including SCIM,
Management and Read-only keys that cannot call a single model.

Add deriveKeyModelScope(allowed_routes) and render 'No model access' with a
scope tooltip for those recognized scopes; unrestricted, AI-API and custom
keys keep the existing model-list rendering.

Co-Authored-By: Devin AI <158243242+devin-ai-integration[bot]@users.noreply.github.com>

* refactor(ui): move key_scope helper to components root

Co-Authored-By: Devin AI <158243242+devin-ai-integration[bot]@users.noreply.github.com>

* feat(keys): persist key_type on virtual keys so the UI reads scope directly

Add a nullable key_type column to LiteLLM_VerificationToken (root, proxy,
and proxy-extras schemas plus an additive migration) and stop dropping the
value in handle_key_type, so management/read_only/llm_api/default keys store
their type alongside the derived allowed_routes. Surface it on the key read
and create response models. The dashboard now prefers the persisted key_type
for the no-inference buckets and keeps the allowed_routes derivation as the
fallback for keys created before the column existed (key_type null), so no
backfill is required.

Co-Authored-By: Devin AI <158243242+devin-ai-integration[bot]@users.noreply.github.com>

* style(keys): use PEP604 X | None for new key_type annotations to satisfy ruff UP045 budget

Co-Authored-By: Devin AI <158243242+devin-ai-integration[bot]@users.noreply.github.com>

* fix(keys): add key_type column to LiteLLM_DeletedVerificationToken

The deleted-token archive model inherits key_type from the verification
token, so regenerate/delete flows write key_type into
LiteLLM_DeletedVerificationToken. Add the column (all schemas + migration)
so the archive insert does not fail with FieldNotFoundError.

Co-Authored-By: Devin AI <158243242+devin-ai-integration[bot]@users.noreply.github.com>

* fix(migrations): regenerate key_type migration via runbook (canonical ADD COLUMN)

Co-Authored-By: Devin AI <158243242+devin-ai-integration[bot]@users.noreply.github.com>

---------

Co-authored-by: ryan <ryan@berri.ai>
Co-authored-by: Devin AI <158243242+devin-ai-integration[bot]@users.noreply.github.com>
2026-07-13 18:08:43 -07: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
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