drizzle
Drizzle ORM for backend database queries and schema.
When & Why to Use This Skill
This Claude skill provides expert guidance for using Drizzle ORM in backend development, focusing on efficient database queries and schema management. It helps developers implement performance-oriented patterns such as type-safe selects, optimized joins, and precise column filtering to ensure high-performance database interactions and maintainable codebases.
Use Cases
- Efficient Query Construction: Use specialized Drizzle ORM syntax like `db.select()` instead of generic methods to build performant and type-safe database queries.
- Database Performance Optimization: Implement best practices such as `pickColumns` and strategic `leftJoin` or `innerJoin` usage to reduce data overhead and minimize database load.
- Schema and Migration Management: Streamline the definition and maintenance of backend database schemas using Drizzle's declarative approach for better consistency and developer productivity.
| name | drizzle |
|---|---|
| description | Drizzle ORM for backend database queries and schema. |
- Use drizzle-orm
db.select()instead of findMany() - Prefer leftJoin, innerJoin over many query
- Utilize
pickColumnsin db.select() or returning()