Manages PostgreSQL database schemas and Prisma ORM migrations within the ClaudeCode Sentiment Monitor project.
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.
Key Features
01Automated Prisma migration and client generation scripts
02Integrated Prisma Studio support for visual database management
03Optimization strategies for PostgreSQL indexing and query performance
04Enforcement of non-standard schema locations and specific import patterns
050 GitHub stars
06Implementation guidance for idempotent upserts and complex transaction logic
Use Cases
01Optimizing slow database queries with specific composite index patterns
02Troubleshooting Prisma client generation and database connection issues
03Adding or modifying database tables and fields in the Sentiment Monitor project
