Schema migrations for Google Antigravity IDE
# Database Migrations Guide for Google Antigravity
Master database migrations in Google Antigravity IDE. This guide covers migration strategies, rollbacks, and zero-downtime deployments.
## Prisma Migrations
```typescript
// prisma/schema.prisma
model User {
id String @id @default(cuid())
email String @unique
name String?
posts Post[]
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
}
model Post {
id String @id @default(cuid())
title String
content String?
published Boolean @default(false)
author User @relation(fields: [authorId], references: [id])
authorId String
createdAt DateTime @default(now())
}
```
## Migration Commands
```bash
# Create migration
npx prisma migrate dev --name add_user_table
# Apply migrations in production
npx prisma migrate deploy
# Reset database (dev only)
npx prisma migrate reset
```
## Safe Migration Patterns
```typescript
// Adding a column with default
model User {
id String @id
email String
role String @default("user") // Safe: has default
}
// Adding nullable column
model User {
id String @id
email String
bio String? // Safe: nullable
}
// Renaming (two-step process)
// Step 1: Add new column, copy data
// Step 2: Remove old column after verification
```
## Seed Data
```typescript
// prisma/seed.ts
import { PrismaClient } from "@prisma/client";
const prisma = new PrismaClient();
async function main() {
await prisma.user.upsert({
where: { email: "admin@example.com" },
update: {},
create: {
email: "admin@example.com",
name: "Admin",
role: "admin"
}
});
}
main()
.catch(console.error)
.finally(() => prisma.$disconnect());
```
## Best Practices
1. **Small migrations** - Easier to rollback
2. **Test migrations** - Run on staging first
3. **Backup data** - Before major changes
Google Antigravity IDE provides migration scaffolding.This Database prompt is ideal for developers working on:
By using this prompt, you can save hours of manual coding and ensure best practices are followed from the start. It's particularly valuable for teams looking to maintain consistency across their database implementations.
Yes! All prompts on Antigravity AI Directory are free to use for both personal and commercial projects. No attribution required, though it's always appreciated.
This prompt works excellently with Claude, ChatGPT, Cursor, GitHub Copilot, and other modern AI coding assistants. For best results, use models with large context windows.
You can modify the prompt by adding specific requirements, constraints, or preferences. For Database projects, consider mentioning your framework version, coding style, and any specific libraries you're using.