Juan DenisandClaude Fable 5 5417c39100 perf(models): index every foreign-key column ...

An audit found 102 FK columns with no index — every join, per-parent
listing, and the delete cascades from _delete_cascade_policy scanned
whole tables on them (deployments.app_id, audit_logs.user_id,
dns_records.zone_id, webhook_logs.webhook_id, ...). All FK columns now
declare index=True; migration 096 creates the same indexes on existing
installs, deriving the list from the live schema at upgrade time (so
it is idempotent and cannot drift from what an install actually has).

Ratchet: test_every_fk_column_is_indexed pins the rule with no
allowlist — a new FK column is born indexed or the build fails.

Co-Authored-By: Claude Fable 5 <noreply@anthropic.com>

2026-08-31 20:42:53 -04:00

..

__init__.py

refactor(models): one door for delete cascades on NOT NULL child FKs

2026-08-31 20:04:12 -04:00

_delete_cascade_policy.py

fix(models): close all 26 dangling-on-delete FKs + orphan sweep migration

2026-08-31 20:25:29 -04:00

agent_plugin.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

ai.py

fix(models): close all 26 dangling-on-delete FKs + orphan sweep migration

2026-08-31 20:25:29 -04:00

api_key.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

api_usage.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

app_volume.py

refactor(models): TimestampMixin + uuid_pk() one-door shapes (plan 77 B1/B3)

2026-08-19 01:59:10 -04:00

application_manifest.py

fix(models): close all 26 dangling-on-delete FKs + orphan sweep migration

2026-08-31 20:25:29 -04:00

application_preview.py

fix(models): close all 26 dangling-on-delete FKs + orphan sweep migration

2026-08-31 20:25:29 -04:00

application.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

audit_log.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

backup_policy.py

refactor(models): TimestampMixin + uuid_pk() one-door shapes (plan 77 B1/B3)

2026-08-19 01:59:10 -04:00

backup_run.py

refactor(models): one JsonColumnMixin instead of 24 hand-rolled copies

2026-08-17 21:43:59 -04:00

cf_ops_change.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

chat_webhook.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

cloud_server.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

cloudflare_tunnel.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

cloudflare_worker.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

container_registry.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

container_scale_policy.py

refactor(models): one door for delete cascades on NOT NULL child FKs

2026-08-31 20:04:12 -04:00

container_sleep_policy.py

refactor(models): one door for delete cascades on NOT NULL child FKs

2026-08-31 20:04:12 -04:00

cron_run.py

refactor(models): SerializableMixin — mechanical to_dicts become introspection (plan 77 B2)

2026-08-19 05:33:17 -04:00

dashboard.py

fix(models): close all 26 dangling-on-delete FKs + orphan sweep migration

2026-08-31 20:25:29 -04:00

db_snapshot.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

ddns_host.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

deployment_job.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

deployment_snapshot.py

refactor(models): one door for delete cascades on NOT NULL child FKs

2026-08-31 20:04:12 -04:00

deployment.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

dns_change.py

feat(restore-points): add surface adapters and checkpoints

2026-08-23 16:41:02 -04:00

dns_cutover_snapshot.py

refactor(models): one JsonColumnMixin instead of 24 hand-rolled copies

2026-08-17 21:43:59 -04:00

dns_zone.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

domain_registration.py

feat(domains): unify domains & DNS into one surface + admin-only Connections

2026-06-23 00:34:55 -04:00

domain.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

email_bounce.py

refactor(models): TimestampMixin + uuid_pk() one-door shapes (plan 77 B1/B3)

2026-08-19 01:59:10 -04:00

email_provider.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

email.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

env_variable.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

environment_activity.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

environment.py

feat(recycle-bin): applications are soft-deletable, and a delete stops keeping data hostage

2026-08-12 20:26:04 -04:00

error_log.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

event_subscription.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

exposed_service.py

fix(models): close all 26 dangling-on-delete FKs + orphan sweep migration

2026-08-31 20:25:29 -04:00

fleet_doctor_result.py

fix(models): close all 26 dangling-on-delete FKs + orphan sweep migration

2026-08-31 20:25:29 -04:00

host_snapshot.py

refactor(models): finish JsonColumnMixin adoption — no hand-rolled json.loads (plan 77 B4)

2026-08-19 02:15:09 -04:00

image_scan.py

refactor(models): one door for delete cascades on NOT NULL child FKs

2026-08-31 20:04:12 -04:00

image_update.py

refactor(models): one door for delete cascades on NOT NULL child FKs

2026-08-31 20:04:12 -04:00

invitation.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

json_column_mixin.py

refactor(models): finish JsonColumnMixin adoption — no hand-rolled json.loads (plan 77 B4)

2026-08-19 02:15:09 -04:00

linked_panel.py

refactor(models): TimestampMixin + uuid_pk() one-door shapes (plan 77 B1/B3)

2026-08-19 01:59:10 -04:00

login_link.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

managed_database_user.py

refactor(models): TimestampMixin + uuid_pk() one-door shapes (plan 77 B1/B3)

2026-08-19 01:59:10 -04:00

managed_database.py

feat(databases): ManagedDatabase adopts SoftDelete into the Recycle Bin (plan 77 B5)

2026-08-19 05:43:53 -04:00

managed_dns_record.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

metric_alert.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

metrics_history.py

fix(metrics): unknown is not zero, and zero is not unknown

2026-08-17 22:40:12 -04:00

mixins.py

refactor(models): SerializableMixin — mechanical to_dicts become introspection (plan 77 B2)

2026-08-19 05:33:17 -04:00

notification_preferences.py

refactor(models): one door for delete cascades on NOT NULL child FKs

2026-08-31 20:04:12 -04:00

oauth_identity.py

refactor(models): one door for delete cascades on NOT NULL child FKs

2026-08-31 20:04:12 -04:00

passkey.py

refactor(models): one door for delete cascades on NOT NULL child FKs

2026-08-31 20:04:12 -04:00

pending_agent.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

plugin_store.py

refactor(models): TimestampMixin + uuid_pk() one-door shapes (plan 77 B1/B3)

2026-08-19 01:59:10 -04:00

plugin.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

project.py

fix(models): close all 26 dangling-on-delete FKs + orphan sweep migration

2026-08-31 20:25:29 -04:00

promotion_job.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

proxy_stack.py

fix(models): close all 26 dangling-on-delete FKs + orphan sweep migration

2026-08-31 20:25:29 -04:00

registrar_connection.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

restore_drill.py

fix(models): close all 26 dangling-on-delete FKs + orphan sweep migration

2026-08-31 20:25:29 -04:00

restore_point.py

fix(restore-points): json one-door model reads; modernize last-domain restore test

2026-08-25 03:13:06 -04:00

run_log.py

feat(realtime): generalized run envelope — one stream door for every run kind (plan 77 E1)

2026-08-19 05:13:02 -04:00

sandbox_run.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

sanitization_profile.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

saved_view.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

secret_vault.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

security_alert.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

server_onboarding_log.py

refactor(models): finish JsonColumnMixin adoption — no hand-rolled json.loads (plan 77 B4)

2026-08-19 02:15:09 -04:00

server_survey.py

fix(models): close all 26 dangling-on-delete FKs + orphan sweep migration

2026-08-31 20:25:29 -04:00

server_template.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

server.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

shared_resource.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

site_bandwidth.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

site_base_domain.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

site_import.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

source_connection.py

refactor(models): one door for delete cascades on NOT NULL child FKs

2026-08-31 20:04:12 -04:00

status_page.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

status.py

feat(models): canonical status vocabulary + RunLifecycleMixin (plan 77 D1/D2)

2026-08-19 02:06:05 -04:00

system_event.py

refactor(models): one JsonColumnMixin instead of 24 hand-rolled copies

2026-08-17 21:43:59 -04:00

system_settings.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

theme.py

refactor(models): TimestampMixin + uuid_pk() one-door shapes (plan 77 B1/B3)

2026-08-19 01:59:10 -04:00

tunnel.py

fix(models): close all 26 dangling-on-delete FKs + orphan sweep migration

2026-08-31 20:25:29 -04:00

user.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

waf_policy.py

fix(models): close all 26 dangling-on-delete FKs + orphan sweep migration

2026-08-31 20:25:29 -04:00

webhook_gateway.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

webhook.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

wordpress_custom_plugin.py

fix(models): close all 26 dangling-on-delete FKs + orphan sweep migration

2026-08-31 20:25:29 -04:00

wordpress_site.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

workflow.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00

workspace.py

perf(models): index every foreign-key column

2026-08-31 20:42:53 -04:00