shiichan

You Can Now Hand Off Database Migrations to AI Agents in DMS Schema Conversion!

Hi, it's Shiichan! Today I found news that brings AI agents and database migration a lot closer together, so let me share it with you!

AWS What's New aws.amazon.com

What was announced?

According to AWS's What's New, AWS Database Migration Service (DMS) Schema Conversion now supports AI agent automation through the AWS MCP Server. You can connect AI coding agents like Kiro, Claude Code, and Cursor directly from your IDE and run complete migration workflows using natural language. Agents can autonomously create projects, browse source metadata, convert schemas, generate assessment reports, and export results.

The story so far

DMS Schema Conversion first introduced generative AI-powered code conversion at re:Invent 2024, helping convert remaining code objects like stored procedures, functions, and triggers. Until now, though, engineers still had to work through the console or API step by step to drive each stage of the conversion themselves.

What changes

The new "dms-schema-conversion" skill teaches AI agents predefined procedures upfront, including API patterns, schema exclusions, and operational sequencing rules. Instead of improvising from general knowledge, agents follow these set procedures, which cuts down on trial-and-error loops. Just by giving instructions in natural language from your IDE, you can now hand off migration work that used to require manual effort to an agent.

Dive Deep

This works with all existing DMS Schema Conversion source and target engine pairs, at no additional charge. You can check supported regions on AWS's "Supported AWS Regions" page, and getting started details are in the "Using AI agents with DMS Schema Conversion" documentation.

Wrap-up

  • DMS Schema Conversion now supports AI agent automation via the AWS MCP Server
  • You can run migration workflows in natural language from Kiro, Claude Code, Cursor, and more
  • The "dms-schema-conversion" skill gives agents API patterns and operational procedures
  • It works with all existing source/target engine pairs at no extra charge

Backend engineers and database administrators who want to drive database migrations with AI agents from their IDE should definitely check this out!