Postgres Migrations
Automates PostgreSQL schema migrations based on pull requests, ensuring safe and repeatable database updates.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add pr-pm-postgres-migrations npx -- -y @trustedskills/pr-pm-postgres-migrations
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"pr-pm-postgres-migrations": {
"command": "npx",
"args": [
"-y",
"@trustedskills/pr-pm-postgres-migrations"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill automates database migrations using PostgreSQL. It allows you to apply, rollback, and manage changes to your database schema in a controlled and repeatable manner. The skill simplifies the process of evolving your database structure over time, reducing manual errors and improving deployment consistency.
When to use it
- Deploying application updates: Automatically apply necessary database schema changes when deploying new versions of an application.
- Rolling back problematic deployments: Quickly revert database migrations if a deployment introduces unexpected issues.
- Managing evolving schemas: Handle complex database schema modifications in a structured and versioned way.
- Automating development workflows: Integrate database migration management into continuous integration/continuous delivery (CI/CD) pipelines.
Key capabilities
- Apply database migrations
- Rollback database migrations
- Manage migration versions
Example prompts
- "Run the latest pending PostgreSQL migrations."
- "Revert the last three applied PostgreSQL migrations."
- “Show me a list of all available PostgreSQL migrations.”
Tips & gotchas
This skill requires access to a PostgreSQL database and appropriate credentials. Ensure that migration files are correctly formatted and follow established conventions for your project.
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.