Database Best Practices Skill

Purpose

Provides best practices and patterns for database operations in Shopify apps using Prisma ORM, focusing on data isolation, query optimization, and safe migrations.

When This Skill Activates

• Working with Prisma schema or queries
• Creating database migrations
• Optimizing database performance
• Implementing multi-tenant data isolation
• Handling transactions

Critical: Multi-Tenant Data Isolation

ALWAYS filter by shopId - This prevents data leaks between shops.