• ISOLATION
  • VERIFICATION
  • OVERSIGHT
  • HUMAN

How to test schema changes with your AI agent

Connect PlanetScale to your agent to fork production schemas into isolated branches. You'll test migrations in a safe sandbox before they ever touch live traffic.

Ask AI about this page

Short answer

How can I test schema changes with my AI?

Your agent creates a branch of your production database to run migrations in isolation. This lets you verify new schemas work as expected without breaking anything. You get a clear view of the results below.

The outcomes of testing

Where your testing lands.

These are the specific results you get when your agent manages your database branches.

ISOLATION

Safe testing branches

The agent creates a copy of your schema. You run your migration tests here so your production environment stays stable.

VERIFICATION

Validated schema state

The agent pulls branch details to confirm the schema matches your requirements. You'll know exactly what changed.

OVERSIGHT

Branch inventory

The agent lists all active branches. You can see every experimental environment currently active in your account.

HUMAN

Manual final approval

The agent stops after the branch is ready. You decide when to merge the changes back to production.

The workflow

What your AI does when a migration is requested.

Your agent handles the environment setup so you can focus on the migration logic.

  1. Fork the schema

    The agent creates a new branch from your production database to provide a safe testing area.

    create_branch

  2. Check existing branches

    The agent looks through your current branches to ensure the new one doesn't conflict with existing work.

    list_branches

  3. Inspect the branch

    The agent retrieves specific data about the new branch to confirm it's ready for your migration scripts.

    get_branch

  4. Verify branch status

    The agent uses branch information to confirm the environment is correctly configured for your tests.

    get_branch

Try it

Copy these to start.

Use these prompts to start testing your migrations.

Starting points

Replace the database and branch names with your actual PlanetScale identifiers.

PlanetScale Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_Cj1wlp2M7NG4xG8y4bWLeF2TWX2ttuftARXCdWYR/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — PlanetScale capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "planetscale-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_Cj1wlp2M7NG4xG8y4bWLeF2TWX2ttuftARXCdWYR/mcp"
    }
  }
}
Copy into chat04

  • Create a new branch called 'migration-test-alpha' from my production database.

  • List all my PlanetScale branches so I can see what's active.

  • Get the details for the 'test-schema-v1' branch.

  • Check my current branches and tell me if 'dev-branch' already exists.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect PlanetScale once, then ask.

Link your account once and your credentials stay encrypted. You can then manage branches directly through your agent.

Connect PlanetScale to your AI

FAQ

How this task behaves

  • 01

    Can the AI delete my production data?

    No. The tools only allow for creating, listing, and getting branch information.

  • 02

    Will this affect my live production traffic?

    No. The agent works on isolated branches, so your production environment remains untouched.

  • 03

    Can the AI merge the branch to production?

    No. The agent manages the branches, but you must perform the actual merge to production yourself.

  • 04

    Can the AI run SQL queries on my database?

    No. This MCP is limited to branch management via the provided tools.

  • 05

    How do I know which branch the AI is looking at?

    The agent will tell you the specific branch name it is accessing after it uses the branch tools.

  • More questions about PlanetScale? The Connector page answers them. See everything the PlanetScale Connector can do

Connect PlanetScale to Claude, Cursor, ChatGPT & more