How does it handle database errors?

It includes standardized error-handling patterns for common Prisma issues, such as P2002 Unique Constraint Violations and P2025 Record Not Found errors.

How does this skill prevent data leaks in Shopify apps?

The skill enforces a strict multi-tenant pattern that requires every database query to include a specific shopId filter, ensuring merchants can never access or modify data belonging to another shop.

Can it help with Prisma schema migrations?

Yes, it provides best practices for safe migrations, such as adding fields as optional first, running backfill scripts, and then making fields required to avoid breaking production.

Does this skill address performance issues like N+1 queries?

Absolutely. It provides specific patterns for using Prisma's 'include' and 'select' features to batch queries and reduce the number of database roundtrips.

Shopify Database Best Practices

Name: Shopify Database Best Practices
Author: sarojpunde

bysarojpunde

•

Database Management

Optimizes Shopify app database operations using Prisma ORM with a focus on multi-tenant data isolation and high-performance query patterns.

This skill provides specialized guidance for developers building Shopify applications with Prisma ORM, ensuring data security and performance. It enforces critical multi-tenant architecture by requiring shopId filtering on all queries to prevent cross-merchant data leaks. Beyond security, it offers implementation patterns for complex database tasks such as safe schema migrations, transaction management, bulk operations, and N+1 query prevention. Whether you are setting up a new schema or optimizing an existing production database, this skill helps maintain data integrity and application responsiveness within the Shopify ecosystem.

Key Features

01Provides robust patterns for transactions, upserts, and bulk operations

02Enforces strict multi-tenant data isolation via shopId filtering

03Guides safe Prisma schema migrations and sequential data backfilling

041 GitHub stars

05Optimizes query performance through selective fields and indexing strategies

06Automates error handling for common Prisma constraint violations

Use Cases

01Building a secure multi-tenant Shopify app backend with Prisma

02Refactoring inefficient database queries to resolve N+1 performance issues

03Managing complex database schema updates and production migrations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add sarojpunde/shopify-dev-toolkit-claude-plugins database-best-practices

For use in Claude.ai and ChatGPT

Download Skill