Back to Prompts

Generate Database Migration Scripts

Have Copilot generate migration scripts for schema changes based on a before/after view.

category:database
migrations
schema
0

Prompt

Generate database migration steps for the following schema change.
  
  Current schema:
  [Describe or paste current table definitions]
  
  Desired schema:
  [Describe or paste desired table definitions]
  
  Provide:
  - SQL ALTER statements (or migration DSL for the chosen tool).
  - Notes about data backfills or transformations if needed.

Related Prompts

View all →

Migrate SQL Schema to Prisma Schema

Convert CREATE TABLE SQL into a Prisma schema.prisma file.

category:modernizationprismasql+2

Investigate a Slow Database Query

Use Copilot to analyze and optimize slow SQL/Prisma queries.

category:databaseperformancesql+2

Add a New Prisma Entity

Use Copilot to define a new Prisma model, migrate, seed, and test it.

category:databaseprismaschema+2

Optimize a Slow SQL Query

Use Copilot to diagnose and optimize a slow SQL query, including index suggestions.

category:databasesqlperformance+1

Write a SQL Query from Requirements

Ask Copilot to translate a human requirement into a SQL SELECT query.

category:databasesqlqueries+1

Update Gradle build for Spring Boot 3

Update build.gradle with Spring Boot 3 plugin and Jakarta EE compatible dependencies.

spring-bootgradlebuild+4
Browse More Prompts