Project Migration Guide

1aUpdate the project's .mcp.json

Point the project to the production coordinator:

Copy{
  "mcpServers": {
    "MigrationCoordinator": {
      "type": "http",
      "url": "https://mc.shareddev.com/rpc",
      "headers": {
        "Mcp-Session-Id": "YourProjectName",
        "X-Api-Key": "your-production-api-key"
      }
    }
  }
}

1bRegister via Claude Code

From a Claude Code session in the project, the agent will call:

mc_register_project(name: "YourProjectName", github_repo: "SharedDev01/YourRepo")

This creates the project in the coordinator database. All other MCP tools will be blocked until an administrator configures the project settings in the dashboard.

2Fill in settings on the dashboard

Go to mc.shareddev.com → click the project → Settings tab.

3Click "Sync from Git" on the project dashboard

Go to the project's main page (Dashboard tab). You should see a Maintenance section with buttons.

Click Sync from Git. This will:

1. Clone the repo to /repos/YourProject/ on the server (first time)
2. Or pull the latest default branch (subsequent syncs)
3. The baseline .mdf and migration files will be on the server

4Click "Recreate Reference DB"

This will:

1. Copy the baseline .mdf to the SQL Server data directory
2. Attach it as YourProject_ref
3. Apply any pending migration scripts
4. Fix file permissions (Linux)

After this, the deployment status banner should show green with the migration count.

5Copy the ticket sequence from the local coordinator

If the project was previously registered on the local coordinator (port 8620) and has issued ticket IDs, you need to copy the sequence to avoid ID conflicts.

On the local coordinator database:

CopySELECT t.LastTicketId FROM dbo.TicketSequences t
JOIN dbo.Projects p ON t.ProjectId = p.ProjectId
WHERE p.Name = 'YourProjectName'

On the remote coordinator database (MigrationCoordinator_prod):

CopyINSERT INTO dbo.TicketSequences (ProjectId, LastTicketId)
SELECT ProjectId, <value-from-above> FROM dbo.Projects WHERE Name = 'YourProjectName'

6Verify everything works from Claude Code

• mc_get_ticket_id — returns a ticket number
• mc_register_branch — creates a dev database on the server
• Dev database is reachable from your local machine at 136.144.128.65
• mc_reserve_migration + mc_apply_migration — migration workflow works
• mc_complete_branch — cleans up dev database

7Remove from local coordinator

Once verified, the project can be removed from the local coordinator (port 8620). This is optional — leaving it is harmless.