MCP App: EF Migration Timeline — Database schema evolution viewer

[jongalloway]

Summary

Create an interactive EF Migration Timeline MCP App that visualizes database migrations as a navigable timeline with apply/rollback controls.

MCP Apps Pattern: Multi-step workflows

Reviewing and applying EF Core migrations is inherently sequential — list migrations, check which are pending, apply specific ones, verify. A timeline UI makes this a one-screen experience with visual state and action buttons.

Design

• Timeline view: Horizontal or vertical timeline showing each migration with timestamp and name
• Status badges: Applied (green), Pending (yellow), Current (blue) for each migration
• Apply controls: "Apply up to here" button on any pending migration
• Migration details: Click to see the SQL script preview (via MigrationsScript action)
• DbContext selector: Dropdown if multiple DbContexts exist (from DbContextList)
• Database status: Show current migration pointer and connection info

Data Sources

• DotnetEntityFramework tool actions: MigrationsList, DatabaseUpdate, MigrationsScript, DbContextList, DbContextInfo
• Structured output from migration list (name, timestamp, applied status)

Resource URI

ui://dotnet-mcp/ef-migrations

Priority

High — strong multi-step workflow showcase, unique to MCP (no equivalent in C# Dev Kit).