René's URL Explorer Experiment


Title: feat: rotate, decrypt, and delete encrypted chat_mcp_servers headers by ethanndickson · Pull Request #29520 · coder/coder · GitHub

Open Graph Title: feat: rotate, decrypt, and delete encrypted chat_mcp_servers headers by ethanndickson · Pull Request #29520 · coder/coder

X Title: feat: rotate, decrypt, and delete encrypted chat_mcp_servers headers by ethanndickson · Pull Request #29520 · coder/coder

Description: Relates to #25381 chat_mcp_servers.headers_key_id has a foreign key to dbcrypt_keys(active_key_digest), but dbcrypt rotate, decrypt and delete didn't know about the table. rotate finishes by revoking every old key, so an encrypted header row would fail that revoke with an FK violation, which is the same class of bug as #25381. This PR adds chat_mcp_servers to all three commands. rotate re-encrypts under the new key (and encrypts plaintext rows with no key ID, like gitsshkeys), decrypt writes the plaintext back and clears the key ID, and delete removes the encrypted rows outright, like user_secrets, since a server without its headers can't authenticate anyway. Rows with {} headers are never encrypted, so they're left alone. The org-level mcp_server_configs gap is still tracked at #25381. I've stacked this on the mcpclient PR, though it only depends on the chat_mcp_servers table PR, as gh stack is linear. Part of CODAGT-1131

Open Graph Description: Relates to #25381 chat_mcp_servers.headers_key_id has a foreign key to dbcrypt_keys(active_key_digest), but dbcrypt rotate, decrypt and delete didn't know about the table. rotate finishes by re...

X Description: Relates to #25381 chat_mcp_servers.headers_key_id has a foreign key to dbcrypt_keys(active_key_digest), but dbcrypt rotate, decrypt and delete didn't know about the table. rotate finishes b...

Opengraph URL: https://github.com/coder/coder/pull/29520

X: @github

direct link

Domain: github.com

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322
route-pattern/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:cab2d914-434d-2145-7270-430da6923f74
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idCF78:FC5BE:23E9A91:2FAC763:6B0194F1
html-safe-nonce3a3c1d51517aba19446c41204d548916994c9745d58ee8ac538424155be2c766
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDRjc4OkZDNUJFOjIzRTlBOTE6MkZBQzc2Mzo2QjAxOTRGMSIsInZpc2l0b3JfaWQiOiI3MDAyMjE1MjQ4OTU4NjkwNTQ1IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac7d0746e6353c158fea225f86ab239e2f5236fa4a683acb9b5859649b4b78c2d8
hovercard-subject-tagpull_request:4566106369
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///pull_requests/show/files
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/coder/coder/pull/29520/files
twitter:imagehttps://avatars.githubusercontent.com/u/39577870?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/39577870?s=400&v=4
og:image:altRelates to #25381 chat_mcp_servers.headers_key_id has a foreign key to dbcrypt_keys(active_key_digest), but dbcrypt rotate, decrypt and delete didn't know about the table. rotate finishes by re...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
Nonecc5dfdd32f62ebd3223cab3af3aa2b268d3605218237326a48a99d1efd89495c
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/coder/coder git https://github.com/coder/coder.git
octolytics-dimension-user_id95932066
octolytics-dimension-user_logincoder
octolytics-dimension-repository_id440752086
octolytics-dimension-repository_nwocoder/coder
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id440752086
octolytics-dimension-repository_network_root_nwocoder/coder
turbo-body-classeslogged-out env-production page-responsive full-width
disable-turbotrue
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release8c77c9e8439031ad54c75a250694842892f693e1
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/coder/coder/pull/29520/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fcoder%2Fcoder%2Fpull%2F29520%2Ffiles
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fcoder%2Fcoder%2Fpull%2F29520%2Ffiles
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fpull_requests%2Fshow%2Ffiles&source=header-repo&source_repo=coder%2Fcoder
Reloadhttps://github.com/coder/coder/pull/29520/files
Reloadhttps://github.com/coder/coder/pull/29520/files
Reloadhttps://github.com/coder/coder/pull/29520/files
coderhttps://github.com/coder
coderhttps://github.com/coder/coder
Codehttps://github.com/coder/coder
Issues320 (320)https://github.com/coder/coder/issues
Pull requests470 (470)https://github.com/coder/coder/pulls
Discussionshttps://github.com/coder/coder/discussions
Actionshttps://github.com/coder/coder/actions
Projectshttps://github.com/coder/coder/projects
Security and quality49 (49)https://github.com/coder/coder/security
Insightshttps://github.com/coder/coder/insights
Sign up for GitHub https://github.com/signup?return_to=%2Fcoder%2Fcoder%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fcoder%2Fcoder%2Fissues%2Fnew%2Fchoose
ethanndicksonhttps://github.com/ethanndickson
ethanndickson/chat-mcp-servers-mcpclienthttps://github.com/coder/coder/tree/ethanndickson/chat-mcp-servers-mcpclient
ethanndickson/chat-mcp-servers-dbcrypthttps://github.com/coder/coder/tree/ethanndickson/chat-mcp-servers-dbcrypt
Conversation 7 https://github.com/coder/coder/pull/29520
Commits 1 https://github.com/coder/coder/pull/29520/commits
Checks 41 https://github.com/coder/coder/pull/29520/checks
Files changed https://github.com/coder/coder/pull/29520/files
Please reload this pagehttps://github.com/coder/coder/pull/29520/files
feat: rotate, decrypt, and delete encrypted chat_mcp_servers headers https://github.com/coder/coder/pull/29520/files#top
Show all changes 1 commit https://github.com/coder/coder/pull/29520/files
873bb82 feat: rotate, decrypt, and delete encrypted chat_mcp_servers headers ethanndickson Sep 18, 2026 https://github.com/coder/coder/pull/29520/commits/873bb829907e0865fd05097a315407b23bc40eae
Clear filters https://github.com/coder/coder/pull/29520/files
Please reload this pagehttps://github.com/coder/coder/pull/29520/files
Please reload this pagehttps://github.com/coder/coder/pull/29520/files
database-encryption.md https://github.com/coder/coder/pull/29520/files#diff-df2a56ce9dd787c99e82841964b305e69ee511fd2626e9b169f181f1da279312
server_dbcrypt_test.go https://github.com/coder/coder/pull/29520/files#diff-58a4cd5bf914af2d112ed490b5380c3ce0d32efc7bcdb0cb8f3d15905a084b99
cliutil.go https://github.com/coder/coder/pull/29520/files#diff-3d5af79ec814eef464334ef53a2e13dac399bdb0ffcf55d4b6e7de8e4fb3712a
docs/admin/security/database-encryption.mdhttps://github.com/coder/coder/pull/29520/files#diff-df2a56ce9dd787c99e82841964b305e69ee511fd2626e9b169f181f1da279312
View file https://github.com/coder/coder/blob/873bb829907e0865fd05097a315407b23bc40eae/docs/admin/security/database-encryption.md
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/coder/coder/pull/29520/{{ revealButtonHref }}
https://github.com/coder/coder/pull/29520/files#diff-df2a56ce9dd787c99e82841964b305e69ee511fd2626e9b169f181f1da279312
https://github.com/coder/coder/pull/29520/files#diff-df2a56ce9dd787c99e82841964b305e69ee511fd2626e9b169f181f1da279312
https://github.com/coder/coder/actions/runs/36113265609/job/108001497478?pr=29520
https://github.com/coder/coder/pull/29520/files#diff-df2a56ce9dd787c99e82841964b305e69ee511fd2626e9b169f181f1da279312
https://github.com/coder/coder/pull/29520/files#diff-df2a56ce9dd787c99e82841964b305e69ee511fd2626e9b169f181f1da279312
https://github.com/coder/coder/actions/runs/36113265609/job/108001497478?pr=29520
https://github.com/coder/coder/pull/29520/files#diff-df2a56ce9dd787c99e82841964b305e69ee511fd2626e9b169f181f1da279312
https://github.com/coder/coder/pull/29520/files#diff-df2a56ce9dd787c99e82841964b305e69ee511fd2626e9b169f181f1da279312
https://github.com/coder/coder/actions/runs/36113265609/job/108001497478?pr=29520
https://github.com/coder/coder/pull/29520/files#diff-df2a56ce9dd787c99e82841964b305e69ee511fd2626e9b169f181f1da279312
https://github.com/coder/coder/actions/runs/36113265609/job/108001497478?pr=29520
https://github.com/coder/coder/pull/29520/files#diff-df2a56ce9dd787c99e82841964b305e69ee511fd2626e9b169f181f1da279312
enterprise/cli/server_dbcrypt_test.gohttps://github.com/coder/coder/pull/29520/files#diff-58a4cd5bf914af2d112ed490b5380c3ce0d32efc7bcdb0cb8f3d15905a084b99
View file https://github.com/coder/coder/blob/873bb829907e0865fd05097a315407b23bc40eae/enterprise/cli/server_dbcrypt_test.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/coder/coder/pull/29520/{{ revealButtonHref }}
https://github.com/coder/coder/pull/29520/files#diff-58a4cd5bf914af2d112ed490b5380c3ce0d32efc7bcdb0cb8f3d15905a084b99
https://github.com/coder/coder/pull/29520/files#diff-58a4cd5bf914af2d112ed490b5380c3ce0d32efc7bcdb0cb8f3d15905a084b99
https://github.com/coder/coder/pull/29520/files#diff-58a4cd5bf914af2d112ed490b5380c3ce0d32efc7bcdb0cb8f3d15905a084b99
https://github.com/coder/coder/pull/29520/files#diff-58a4cd5bf914af2d112ed490b5380c3ce0d32efc7bcdb0cb8f3d15905a084b99
https://github.com/coder/coder/pull/29520/files#diff-58a4cd5bf914af2d112ed490b5380c3ce0d32efc7bcdb0cb8f3d15905a084b99
https://github.com/coder/coder/pull/29520/files#diff-58a4cd5bf914af2d112ed490b5380c3ce0d32efc7bcdb0cb8f3d15905a084b99
enterprise/dbcrypt/cliutil.gohttps://github.com/coder/coder/pull/29520/files#diff-3d5af79ec814eef464334ef53a2e13dac399bdb0ffcf55d4b6e7de8e4fb3712a
View file https://github.com/coder/coder/blob/873bb829907e0865fd05097a315407b23bc40eae/enterprise/dbcrypt/cliutil.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/coder/coder/pull/29520/{{ revealButtonHref }}
https://github.com/coder/coder/pull/29520/files#diff-3d5af79ec814eef464334ef53a2e13dac399bdb0ffcf55d4b6e7de8e4fb3712a
https://github.com/coder/coder/pull/29520/files#diff-3d5af79ec814eef464334ef53a2e13dac399bdb0ffcf55d4b6e7de8e4fb3712a
https://github.com/coder/coder/pull/29520/files#diff-3d5af79ec814eef464334ef53a2e13dac399bdb0ffcf55d4b6e7de8e4fb3712a
https://github.com/coder/coder/pull/29520/files#diff-3d5af79ec814eef464334ef53a2e13dac399bdb0ffcf55d4b6e7de8e4fb3712a
https://github.com/coder/coder/pull/29520/files#diff-3d5af79ec814eef464334ef53a2e13dac399bdb0ffcf55d4b6e7de8e4fb3712a
https://github.com/coder/coder/pull/29520/files#diff-3d5af79ec814eef464334ef53a2e13dac399bdb0ffcf55d4b6e7de8e4fb3712a
Please reload this pagehttps://github.com/coder/coder/pull/29520/files
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.