Sql Migrations
Automates SQL schema updates via migrations, ensuring consistent and reliable database deployments across environments – a crucial tool for developers.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add sql-migrations npx -- -y @trustedskills/sql-migrations
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"sql-migrations": {
"command": "npx",
"args": [
"-y",
"@trustedskills/sql-migrations"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill allows AI agents to generate and apply SQL migration scripts. It facilitates database schema changes, ensuring a controlled and versioned evolution of your database structure. The agent can create new tables, modify existing ones, or add/remove constraints based on specified requirements.
When to use it
- Database Refactoring: When you need to restructure your database (e.g., splitting large tables, changing data types).
- Adding New Features: To automate the creation of new database entities required for a software feature.
- Deploying Schema Changes: Applying changes across different environments (development, staging, production) in a consistent manner.
- Rolling Back Changes: Reverting to previous schema versions if errors are encountered during deployment.
Key capabilities
- Generates SQL migration scripts
- Applies generated SQL scripts
- Handles database schema evolution
- Supports versioned changes
Example prompts
- "Create a new table called 'users' with columns for id, name, and email."
- "Add a column named 'created_at' to the 'posts' table with a timestamp data type."
- “Generate a migration script to remove the ‘old_table’ table.”
Tips & gotchas
The agent requires access to a database environment (e.g., PostgreSQL, MySQL) and appropriate credentials to execute the generated SQL scripts. Ensure proper testing in non-production environments before applying migrations to production databases.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.