Automate PostgreSQL migrations, backups, and pgvector management with Alembic.
npx skills add https://github.com/shredbx/demo-3d-model --skill devops-database
Please help me install this Agent Skill. Skill: devops-database Source: https://github.com/shredbx/demo-3d-model/tree/main/.claude/skills/devops-database Command: npx skills add https://github.com/shredbx/demo-3d-model --skill devops-database
This Skill centralizes and automates PostgreSQL database management, including schema migrations, reliable backups, and restoration procedures, ensuring data integrity and simplifying database operations for both development and production.
users table. Use this Skill to auto-generate an Alembic migration, review it, apply it to the development database, and then perform a backup before deploying to production.Use the devops-database skill to create a new Alembic migration script for adding a 'last_login' column to the 'users' table.
High-intent search queries and answers about installing and using this skill.
Alembic migrations automate schema changes with version control by generating migration scripts that track database revisions. Create migrations with `alembic revision`, review the generated SQL, and apply them with `alembic upgrade` to manage schema changes reliably across environments.
Yes. This Skill implements backup and restoration procedures using SQL dumps to ensure data integrity. Back up your database before deployments, then restore from dumps when needed, protecting against data loss and enabling quick recovery.
Yes. The Skill manages the pgvector extension alongside standard PostgreSQL operations, enabling you to version-control vector columns and back up vector data as part of your migration and recovery workflows.
Use Alembic's `downgrade` command to roll back schema changes to a previous revision. Migrations are reversible, allowing you to undo changes safely when needed during development or troubleshooting.
Yes. The Skill supports environment-specific configuration and Docker/host integration, letting you apply the same migration workflows consistently across development, staging, and production with secure connection handling.
Use shell access to query the database, diagnose connection or schema problems, and troubleshoot migration errors. Rollback with `alembic downgrade` if needed, then refine the migration before reapplying it.
kivo360Configure Claude Code settings.json, tool permissions, and environment variables.
cffrankBack up D1 databases and restore them with Time Travel bookmarks.
liutao96Automate Alibaba Cloud server management via SSH for Docker, monitoring, and maintenance.
inbharataiGenerate up/down database migration scripts for Alembic, Flyway, and Liquibase.