Database Schema Management

关于

Streamlines database operations by providing project-specific guidance for working with PostgreSQL and Prisma ORM. It ensures consistent schema modifications, migration handling, and optimized querying patterns while enforcing strict architectural requirements like custom schema locations and specialized import paths. This skill is essential for developers needing to maintain the data integrity of the Sentiment Monitor project through automated scripts and best practices for indexing, performance optimization, and transaction management.

主要功能

• Automated Prisma migration and client generation scripts
• Integrated Prisma Studio support for visual database management
• Optimization strategies for PostgreSQL indexing and query performance
• Enforcement of non-standard schema locations and specific import patterns
• 0 GitHub stars
• Implementation guidance for idempotent upserts and complex transaction logic

使用场景

• Optimizing slow database queries with specific composite index patterns
• Troubleshooting Prisma client generation and database connection issues
• Adding or modifying database tables and fields in the Sentiment Monitor project