# Change the schema or data with a way back

> Change the schema or data with a way back: 0 companies fully do it, 3 with a limit, 14 carry the tag. Every listing in Databases & files with the reason and a source.

- Canonical: https://www.anchorterminal.com/niches/data.safe-migration/
- Markdown: https://www.anchorterminal.com/niches/data.safe-migration/index.md (~1,350 tokens)
- Slim: https://www.anchorterminal.com/niches/data.safe-migration/index.min.md (~280 tokens, same facts, less prose, for token-sensitive contexts)
- JSON: https://www.anchorterminal.com/niches/data.safe-migration/index.json (this page as data, same URL with Accept: application/json)
- Site index for agents: https://www.anchorterminal.com/llms.txt (the key docs and every listing in one file, at most 16 MB, about 4 million tokens: https://www.anchorterminal.com/llms-full.txt)
- API: https://www.anchorterminal.com/api/v1/index.json
- MCP: https://www.anchorterminal.com/mcp (the whole catalogue as tools, no key)
- DNS: dig +short TXT <slug>.grade.anchorterminal.com (the grade as a DNS TXT record, for a sandbox with no HTTP where names still resolve; also top., best.<category>. and <a>.vs.<b>. under the zone, and the same under grade.letme.dev)
- Licence: CC BY 4.0, credit Anchor Terminal and link this page (https://www.anchorterminal.com/terms/#data)
- Updated: 2026-11-15

No company's docs show a full fit yet. The listings below do the job with a limit, or not at all.

| Companies, full fit | With a limit | Carry the tag | Share of the category's work | First-hand accounts |
| --- | --- | --- | --- | --- |
| 0 | 3 | 14 | 14 | 9 |

## What counts as done

The change runs on a branch, staging or a dry run first, the person sees the exact DDL or DELETE before it touches the main branch, the migration is recorded, and production is changed only by the approved step.

How agents ask for it: add a column and migrate the data; apply this migration to staging; restore yesterday's snapshot; run the migration on a branch first

## Does the job, with a limit

It does the job, but something in the docs or a user's account will get in an agent's way. The limit is named in each row.

- **Neon MCP Server (Neon, LLC (subsidiary of Databricks, Inc.))**: prepare_database_migration applies changes on a temporary branch and complete_database_migration applies them separately, but #444 (open) reports restore_snapshot with only snapshot_id swapping production twice, against the README's description.
- **PlanetScale MCP Server (PlanetScale, Inc.)**: execute_write_query takes a branch and carries destructiveHint, but DELETE and DDL approval is a confirm_destructive argument the model sets after the tool asks it to check with the user, not a prompt the client shows.
- **Supabase API + MCP (Supabase Pte. Ltd.)**: Experimental branching (create, merge, reset, rebase), tracked apply_migration and SQL elicitation on destructive statements fit, but #472 shows the confirmation failing so a reviewed staging migration could not run, and the docs call elicitation a guardrail.

- not this job: Mirage (AgentVFS) (Strukto.AI): The Postgres VFS is read-only; no migration, branch or dry-run path.
- not this job: ClickHouse MCP Server (ClickHouse, Inc.): No branch or dry-run apply; CLICKHOUSE_ALLOW_DROP is an operator flag, not a confirmation the person sees, and the README calls it best-effort. #24 shows Claude going round read-only with curl.
- not this job: CoinMarketCap x402 API (CoinMarketCap): No schema or write operations on a database.
- not this job: DBHub (Bytebase): No branch, dry-run apply or migration record; with readonly off, execute_sql runs DDL and DELETE directly with no confirmation step.
- not this job: Filesystem (MCP reference server) (Model Context Protocol, a Series of LF Projects, LLC): No database or migration tools; edit_file dryRun previews file edits only.
- not this job: MCP Toolbox for Databases (Google LLC): No branch or migration record; execute_sql runs DDL directly and its docs say it is for human-in-the-loop developer use. BigQuery dry-run validates SELECTs only.
- not this job: Memory (MCP reference server) (Model Context Protocol, a Series of LF Projects, LLC): No schema changes or branches.
- not this job: MongoDB MCP Server (MongoDB, Inc.): No branch, dry run or migration record. Elicitation confirms drop and delete-many by default, but the README says the tool runs without confirmation when the client lacks elicitation.
- not this job: Nansen x402 API (Nansen): No schema or write operations on a database.
- not this job: ObsessionDB (Kellerkind UG (haftungsbeschränkt)): No branch, dry-run or migration tool in the twelve MCP tools; per-agent branches are marked early access on the home page only.
- not this job: Postgres MCP Pro (Crystal Corp.): No branch, dry-run apply or confirmation; unrestricted mode executes DDL directly and restricted mode blocks writes.
- not this job: Redis MCP (Redis Ltd.): No schema changes, branches or dry runs; deletes run without confirmation.
- not this job: ReqRes MCP server (ReqRes): No schema migrations, branches or dry runs.
- not this job: Snowflake-managed MCP server (Snowflake Inc.): No branch, dry-run or migration tools; SQL execution runs what it is given under the role.

## What stops agents finishing

- confirmation step fails in the client so an approved write cannot run
- destructive defaults (restore onto source branch, finalise true)
- agent routes round a read-only server through another tool

## Around it

Before: data.schema-check. After: code.ticket-to-pr.

## Where this comes from

Weight 14 of 100 in Databases & files: 9 of 52 accounts, most of them failures (deleted or swapped production, a confirmation flow that breaks, writes blocked by read-only); weighted for the cost of getting it wrong

As data: https://www.anchorterminal.com/api/v1/use-cases/data.safe-migration.json, or the MCP tool get_use_case with id data.safe-migration. Draft, read 2026-11-15 from public docs and first-hand accounts, not yet reviewed by a person.

---

Query this catalogue directly over MCP: https://www.anchorterminal.com/mcp (Streamable HTTP, no key). How: https://www.anchorterminal.com/agents/#mcp
