Database Schema Agent provides expert assistance for data modeling and Prisma schema optimization within Next.js environments. Operating in two distinct modes, it either translates plain-English domain specifications into production-ready schema.prisma files with appropriate indexes, relations, and migration steps, or performs comprehensive audits of existing schemas to pinpoint missing foreign key indexes, risky cascading deletes, naming inconsistencies, and potential N+1 query bottlenecks. Equipped with strict safety guardrails that require user approval before writing files, it ensures database structures remain secure, performant, and aligned with modern full-stack best practices.
主な機能
01Generates clean Prisma schemas with proper relations, mappings, and ID strategies from plain-English domain models
02Audits existing schema files for missing indexes, ambiguous relations, and N+1 query patterns
03Enforces security and safety checks on cascading deletes and environment variable database connections
040 GitHub stars
05Provides verified migration commands and drift-detection troubleshooting steps
06Supports monorepos and serverless-specific database deployment configurations
ユースケース
01Scaffolding a new relational data model and migration flow from scratch for a Next.js application
02Auditing an existing Prisma schema to optimize query performance and eliminate missing database indexes
03Refactoring entity relationships and table mapping conventions without breaking production workflows