Tags
Best Database migrations Skills for AI Agents
84 Database migrations skills for AI coding assistants — ranked by popularity.
Managing database migrations often involves repetitive tasks and complex schema adjustments that can lead to errors. This collection provides curated skill files for AI agents like Claude Code, Codex, and Cursor, specifically focused on database migrations and infrastructure management. These skills act as specialized instructions that guide your AI to handle schema definitions, ORM-specific patterns, and complex SQL operations. Whether you are building pipelines with Drizzle ORM, orchestrating migrations through Flyway, or automating Supabase project administration, these modules supply the necessary context for accurate execution. This resource is for developers who want to reduce manual coding in database lifecycle management. You can expect granular guidance for defining table structures, writing stored procedures, and maintaining data integrity across different environments. By offloading these technical patterns to an AI equipped with these structured skill files, you ensure your database operations remain consistent and follow best practices for scaling and optimization.
Top Database migrations skills
drizzle
lobehub
Drizzle ORM schema and database guide. Use when working with database schemas (src/database/schemas/*), defining tables, creating migrations, or database model code. Triggers on Drizzle schema definition, database migrations, or ORM usage questions.
drizzle-orm
EpicenterHQ
Drizzle ORM patterns for type branding and custom types. Use when working with Drizzle column definitions, branded types, or custom type conversions.
senior-data-engineer
davila7
World-class data engineering skill for building scalable data pipelines, ETL/ELT systems, and data infrastructure. Expertise in Python, SQL, Spark, Airflow, dbt, Kafka, and modern data stack. Includes data modeling, pipeline orchestration, data quality, and DataOps. Use when designing data architectures, building data pipelines, optimizing data workflows, or implementing data governance.
moai-domain-database
modu-ai
Manage and query domain-specific data efficiently, enabling streamlined access to information and insights.
database-design
davila7
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
snowflake-semanticview
github
Create, alter, and validate Snowflake semantic views using Snowflake CLI (snow). Use when asked to build or troubleshoot semantic views/semantic layer definitions with CREATE/ALTER SEMANTIC VIEW, to validate semantic-view DDL against Snowflake via CLI, or to guide Snowflake CLI installation and connection setup.
prisma-expert
davila7
Prisma ORM expert for schema design, migrations, query optimization, relations modeling, and database operations. Use PROACTIVELY for Prisma schema issues, migration problems, query performance, relation design, or database connection issues.
database-schema-designer
davila7
Design robust, scalable database schemas for SQL and NoSQL databases. Provides normalization guidelines, indexing strategies, migration patterns, constraint design, and performance optimization. Ensures data integrity, query performance, and maintainable data models.
database-migration
wshobson
Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data transformations, or implementing zero-downtime deployment strategies.
database-migrations-sql-migrations
sickn33
SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server
database-migrations
dadbodgeoff
Safe database migration strategies for zero-downtime deployments. Covers backward-compatible changes, data migrations, and rollback procedures.
generate-migration
getsentry
Generate Django database migrations for Sentry. Use when creating migrations, adding/removing columns or tables, adding indexes, or resolving migration conflicts.
postgresql-syntax-reference
pgschema
Consult PostgreSQL's parser and grammar (gram.y) to understand SQL syntax, DDL statement structure, and parsing rules when implementing pgschema features
database-development
vm0-ai
Database migrations and Drizzle ORM guidelines for the vm0 project
databases
mrgoonie
Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin). Use when designing database schemas, writing queries and aggregations, optimizing indexes for performance, performing database migrations, configuring replication and sharding, implementing backup and restore strategies, managing database users and permissions, analyzing query performance, or administering production databases.
migrate-postgres-tables-to-hypertables
timescale
Use this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and validation. **Trigger when user asks to:** - Migrate or convert PostgreSQL tables to hypertables - Execute hypertable migration with minimal downtime - Plan blue-green migration for large tables - Validate hypertable migration success - Configure compression after migration **Prerequisites:** Tables already identified as candidates (use find-hypertable-candidates first if needed) **Keywords:** migrate to hypertable, convert table, Timescale, TimescaleDB, blue-green migration, in-place conversion, create_hypertable, migration validation, compression setup Step-by-step migration planning including: partition column selection, chunk interval calculation, PK/constraint handling, migration execution (in-place vs blue-green), and performance validation queries.
migration
JaguarJack
Generate database migration file for CatchAdmin module.
setup-timescaledb-hypertables
timescale
Use this skill when creating database schemas or tables for Timescale, TimescaleDB, TigerData, or Tiger Cloud, especially for time-series, IoT, metrics, events, or log data. Use this to improve the performance of any insert-heavy table. **Trigger when user asks to:** - Create or design SQL schemas/tables AND Timescale/TimescaleDB/TigerData/Tiger Cloud is available - Set up hypertables, compression, retention policies, or continuous aggregates - Configure partition columns, segment_by, order_by, or chunk intervals - Optimize time-series database performance or storage - Create tables for sensors, metrics, telemetry, events, or transaction logs **Keywords:** CREATE TABLE, hypertable, Timescale, TimescaleDB, time-series, IoT, metrics, sensor data, compression policy, continuous aggregates, columnstore, retention policy, chunk interval, segment_by, order_by Step-by-step instructions for hypertable creation, column selection, compression policies, retention, continuous aggregates, and indexes.
supabase
alinaqi
Core Supabase CLI, migrations, RLS, Edge Functions
app-commands
growilabs
GROWI main application (apps/app) specific commands and scripts. Auto-invoked when working in apps/app.
create-migration
owid
Create a new database migration file for the OWID MySQL database. Use when the user needs to create a database schema change or migration.
format-migration
dailydotdev
Format TypeORM migrations with beautifully formatted SQL code. Use this skill after generating migrations to ensure consistent SQL formatting.
run-tests
pgschema
Run pgschema automated tests (go test) to validate diff logic, plan generation, and dump functionality using test fixtures
dbx-regenerate
storj
Regenerate DBX code after making changes to .dbx schema files. Runs code generation, shows diff summary, validates compilation, and reports any errors.
How to choose a Database migrations skill
Select a skill based on the specific stack and scope of your database project. Start by matching the skill to your ORM—such as Drizzle or Exposed—or your migration tool like Flyway. Check the specific capabilities listed in the file; for instance, some focus on low-level schema visualization and ERD generation, while others prioritize production-grade stored procedures or ETL pipelines. Evaluate the documentation quality within each file to ensure the prompts align with your existing workflow, as these skills vary from specialized repository-level helpers to broader infrastructure management tools.