Backend Queries

关于

This skill empowers Claude to architect high-performance data access layers by implementing secure parameterized statements and efficient fetching patterns. It provides specialized guidance for working with popular ORMs like Prisma and TypeORM, as well as raw SQL, ensuring code adheres to strict standards for pagination, eager loading, and transaction management. Whether you are optimizing slow queries or building complex filtering systems, this skill ensures backend interactions are robust, scalable, and free from common pitfalls like N+1 performance issues.

主要功能

• Strategies for database transactions and data consistency
• Optimization of data fetching patterns to prevent N+1 query problems
• Guidance for ORM usage including Prisma, TypeORM, Drizzle, and Sequelize
• Implementation of parameterized statements for secure database interaction
• 0 GitHub stars
• Advanced techniques for pagination, filtering, and query caching

使用场景

• Refactoring legacy SQL queries to improve performance and prevent injection vulnerabilities
• Developing complex API routes that require efficient data fetching and multi-table joins
• Implementing database transaction logic to ensure data integrity during complex writes