database-migration-assistant

01 前言 Front Matter

name

database-migration-assistant

tags

[ "database", "postgres", "migration", "rollback", "schema", "productivity", "ai" ]

author

Apple <skelitalynn@gmail.com>

scripts

{ "enabled": true, "definitions": [ { "file": "plan_migrations.py", "name": "plan_migrations", "type": "python", "timeout": 30, "description": "Build a migration plan and detect drift." }, { "file": "apply_migrations.py", "name": "apply_migrations", "type": "python", "timeout": 60, "description": "Apply pending up migrations (supports dry-run)." }, { "file": "rollback_migrations.py", "name": "rollback_migrations", "type": "python", "timeout": 60, "description": "Roll back the latest migration or down to a target version." }, { "file": "generate_migration.py", "name": "generate_migration", "type": "python", "timeout": 30, "description": "Generate a new migration SQL template." } ], "working_directory": "./scripts" }

version

1.0.0

triggers

[ { "type": "keyword", "keywords": [ "migration", "database migration", "schema migration", "rollback", "drift", "postgres", "schema change" ] } ]

composable

true

parameters

[ { "name": "action", "type": "string", "required": false, "description": "Operation to perform (plan/apply/rollback/generate)." }, { "name": "migrations_dir", "type": "string", "default": "migrations", "required": false, "description": "Directory that contains versioned SQL migration files." }, { "name": "dry_run", "type": "boolean", "default": false, "required": false, "description": "If true, show planned SQL without executing it." }, { "name": "to_version", "type": "string", "required": false, "description": "Target version for apply or rollback." }, { "name": "name", "type": "string", "required": false, "description": "Migration name when generating a template." } ]

description

PostgreSQL migration assistant that plans, applies, and rolls back schema changes with drift detection for safe AI-agent execution.

persist_state

true

prerequisites

{ "skills": [], "env_vars": [ "DB_URL" ] }

02 资源文件 13

• 脚本examples/demo_agent.py639 B
• 参考文档examples/demo_prompt.txt93 B
• 参考文档examples/example_usage.md267 B
• 其他examples/example.env57 B
• 其他migrations/20260208_091909_create_users_table.sql234 B
• 参考文档README.md7.4 KB
• 脚本scripts/apply_migrations.py3.6 KB
• 脚本scripts/generate_migration.py2.3 KB
• 脚本scripts/migration_utils.py4.3 KB
• 脚本scripts/plan_migrations.py2.3 KB
• 脚本scripts/rollback_migrations.py3.6 KB
• 参考文档SOURCE.md389 B
• 参考文档TRUST.auto.yaml2.1 KB

03 SKILL.md 正文

from spoon_ai.agents import SpoonReactSkill

agent = SpoonReactSkill(
    name="db_migration_agent",
    skill_paths=["./ai-productivity"],
    scripts_enabled=True
)

result = await agent.run("Plan database migrations for this project")
print(result)