Ethan eb2c2799ca fix: strip deleted MCP IDs from chats on delete (#25763) ...

Adds a database migration that reconciles existing stale chat MCP server
IDs, then installs a `BEFORE DELETE` trigger on `mcp_server_configs` to
remove the deleted ID from `chats.mcp_server_ids`. This keeps chat
continuation from failing with `400 One or more MCP server IDs are
invalid` after an MCP server config is deleted.

This matches the existing repo precedent in
`coderd/database/migrations/000241_delete_user_roles.up.sql`, where
deleting a custom role cleans `organization_members.roles`, a similarly
structured array of references that cannot be protected by a normal
foreign key.

Closes CODAGT-505

2026-05-29 16:49:25 +10:00

..

awsiamrds

…

db2sdk

feat: add GitLab support to coderd/externalauth/gitprovider

2026-05-25 17:41:02 +01:00

dbauthz

feat: implement SCIM handler for SCIM 2.0 compliance (#25572)

2026-05-28 10:00:37 -05:00

dbfake

…

dbgen

feat: route chatd provider traffic through aibridge (#25629)

2026-05-26 19:31:52 +00:00

dbmetrics

feat(coderd/database): add boundary_sessions and boundary_logs tables (#25441)

2026-05-25 11:14:36 +02:00

dbmock

feat(coderd/database): add boundary_sessions and boundary_logs tables (#25441)

2026-05-25 11:14:36 +02:00

dbpurge

fix: use UTC day boundaries for chat auto-archive eligibility (#25597)

2026-05-22 11:39:44 +01:00

dbrollup

…

dbtestutil

…

dbtime

…

gen/dump

build(coderd/database/gen/dump): fall back to embedded postgres without docker (#25332)

2026-05-15 09:39:05 +02:00

gentest

feat: add chat ACL database foundation (#25080)

2026-05-14 17:18:50 +01:00

migrations

fix: strip deleted MCP IDs from chats on delete (#25763)

2026-05-29 16:49:25 +10:00

provisionerjobs

…

pubsub

chore: export MsgQueue from pubsub package (#25707)

2026-05-27 10:11:51 -04:00

queries

feat: implement SCIM handler for SCIM 2.0 compliance (#25572)

2026-05-28 10:00:37 -05:00

sdk2db

…

.gitignore

…

check_constraint.go

feat(coderd/database): add boundary_sessions and boundary_logs tables (#25441)

2026-05-25 11:14:36 +02:00

connector.go

…

constants.go

…

db_test.go

…

db.go

…

dump.sql

fix: strip deleted MCP IDs from chats on delete (#25763)

2026-05-29 16:49:25 +10:00

errors.go

…

foreign_key_constraint.go

feat: route chatd provider traffic through aibridge (#25629)

2026-05-26 19:31:52 +00:00

generate.sh

…

legacy_chat_provider_compat.go

feat: remove legacy chat provider tables (#25416)

2026-05-22 09:50:01 +02:00

lock.go

feat!: seed ai_providers from env on server startup (#24895)

2026-05-22 08:37:27 +02:00

modelmethods_internal_test.go

feat: add chat sharing foundation (#25041)

2026-05-18 22:32:05 +01:00

modelmethods.go

feat: add personal skill storage, API, and SDK (#25363)

2026-05-20 00:09:09 +02:00

modelqueries_internal_test.go

…

modelqueries.go

feat: implement SCIM handler for SCIM 2.0 compliance (#25572)

2026-05-28 10:00:37 -05:00

models.go

feat: route chatd provider traffic through aibridge (#25629)

2026-05-26 19:31:52 +00:00

no_slim.go

…

oidcclaims_test.go

…

pglocks.go

…

querier_test.go

feat: add pr, repo, pr_title chat search filters (#25569)

2026-05-22 13:58:07 +01:00

querier.go

feat(coderd/database): add boundary_sessions and boundary_logs tables (#25441)

2026-05-25 11:14:36 +02:00

queries.sql.go

feat: implement SCIM handler for SCIM 2.0 compliance (#25572)

2026-05-28 10:00:37 -05:00

sqlc.yaml

feat: add AI provider schema expansion (#25412)

2026-05-22 02:16:01 +02:00

tx_test.go

…

tx.go

…

types.go

feat: add chat sharing foundation (#25041)

2026-05-18 22:32:05 +01:00

unique_constraint.go

feat(coderd/database): add boundary_sessions and boundary_logs tables (#25441)

2026-05-25 11:14:36 +02:00

user_skills_test.go

feat: add personal skill storage, API, and SDK (#25363)

2026-05-20 00:09:09 +02:00