serverpod/serverpod-migrations
packages/serverpod/skills/serverpod-migrations/SKILL.md
Serverpod database migrations — when and how to create/apply/repair migrations. Use whenever database schema changes are involved.
$ install --global
skillsauthnpx skillsauth add serverpod/serverpod serverpod-migrationsInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: May 14, 2026, 4:50 AM118.3s1 file scanned
SKILL.md
- name:
- serverpod-migrations
- description:
- Serverpod database migrations — when and how to create/apply/repair migrations. Use whenever database schema changes are involved.
Serverpod Migrations
Serverpod has a migration system that generates SQL for changes to models with table in .spy.yaml. The migrations are applied:
- When the
apply_migrationstool is called via theserverpodMCP. Typically during development with a runningserverpod start. - When the server is started with
dart run bin/main.dart --apply-migrationsflag. Typically when running the server in production.
When migrations are needed
- Added, removed, or renamed
tablemodels or fields in.spy.yaml. - Changed relation fields that alter generated foreign keys.
- Added, removed, or changed indexes.
Migrations are not needed when the project has no database configured (e.g. config/<runMode>.yaml with no database section).
Standard flow
The standard flow for creating and applying migrations is simplified when a serverpod start is running.
With a running serverpod start and MCP server
When the server is running from serverpod start use the serverpod MCP to:
- Create a migration using the
create_migrationtool. - Apply the migration using the
apply_migrationstool.
ALWAYS use the MCP server if it is available.
ONLY if MCP server fails to connect
When the server is not running from serverpod start use the CLI commands to:
- Ensure the code is generated by running
serverpod generate. - Create a migration using the
serverpod create-migrationcommand.
Repair migrations
If the database is in an inconsistent state, the repair migration can be used to bring it back to a consistent state.
# Use the `--mode` flag to specify the run mode
# Use the `--version` flag to specify the target version
# Use the `--force` flag to create a migration with destructive changes
# Use the `--tag` flag to name the migration
serverpod create-repair-migration [--mode production] [--version <name>] [--force] [--tag <tag>]
Apply the repair migration by restarting the server with dart run bin/main.dart --apply-repair-migration. This can only be done through the CLI. Ask the user to run this command.
Related Skills
serverpod/serverpod-flutter-frontend
development
VerifiedTrustedCommunity
Build highly distinctive, production-ready Flutter interfaces with exceptional design fidelity. Include this skill whenever a user requests Flutter widgets, screens, or full apps.
3,192SKILL.mdUpdated Jun 4, 2026
serverpod/serverpod-auth
testing
VerifiedTrustedCommunity
Serverpod Authentication — Signing in users, verify if they are authenticated, assinging scopes (e.g., admin). Use when adding features that require the user to be signed in.
3,192SKILL.mdUpdated May 13, 2026
serverpod/serverpod-webserver
development
VerifiedTrustedCommunity
Serverpod web server (Relic) — REST APIs, webhooks, middleware, static files, server-rendered HTML, SPAs, Flutter web. Use when adding HTTP routes, serving web pages or web apps, intercepting requests, or working with the Relic web server.
3,187SKILL.mdUpdated Apr 15, 2026
serverpod/serverpod-overview
tools
VerifiedTrustedCommunity
Serverpod overview — what it is, project structure, how to work with. Always use at least once when working with projects that use Serverpod.
3,180SKILL.mdUpdated Apr 15, 2026