Drizzle Orm
This skill covers Drizzle ORM fundamentals for building type-safe database layers, including schema organization, prepared statements, and transaction patterns. Learn performance-first practices like indexing strategies, N+1 prevention, and safe migration workflows using package scripts. Covers common pitfalls and validation steps to ensure robust database code.
Drizzle Orm teaches type-safe database operations with schema definitions, queries, transactions, and migration best practices.
AI-generated summary based on this skill's SKILL.md
Decision gist · record as of 2026-07-26
Drizzle Orm teaches type-safe database operations with schema definitions, queries, transactions, and migration best practices. This skill covers Drizzle ORM fundamentals for building type-safe database layers, including schema organization, prepared statements, and transaction patterns. Learn performance-first practices like indexing strategies, N+1 prevention, and safe migration workflows using package scripts. Covers common pitfalls and validation steps to ensure robust database code.
Use it when
- Drizzle ORM builds type-safe database queries by leveraging TypeScript's type system throughout the entire query lifecycle.
- Drizzle ORM uses a declarative schema definition approach where you define tables and columns using Drizzle's schema builders.
Install
pedronauck/skills/drizzle-orm · repository language: JavaScript
generated, unverified - the skill's exact subdirectory could not be determined; check the repository on GitHub
Open directory. Skills are indexed for reading, not audited. Review a skill's body before installing it.
Frequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
How to use Drizzle ORM for database operations?
Drizzle ORM provides a TypeScript-first approach to database management. Start by defining your schema using Drizzle's schema builders, then initialize a database connection. Drizzle ORM supports prepared statements for performance and type safety. Use the query builder to construct type-safe queries, leverage transactions for multi-step operations, and implement proper error handling. The skill covers setup workflows, common patterns, and validation steps to ensure robust database code.
What makes Drizzle ORM type-safe for database queries?
Drizzle ORM builds type-safe database queries by leveraging TypeScript's type system throughout the entire query lifecycle. When you define your schema, Drizzle generates corresponding TypeScript types automatically. This means your queries, results, and parameters are all type-checked at compile time. Prepared statements in Drizzle ORM further enhance safety by separating query structure from data, preventing SQL injection and ensuring predictable performance.
How do you define and manage database schemas in Drizzle?
Drizzle ORM uses a declarative schema definition approach where you define tables and columns using Drizzle's schema builders. Each table definition specifies column types, constraints, and relationships. Drizzle ORM generates migrations from your schema changes, which you manage through package scripts. The skill covers schema organization best practices, relationship configuration, and safe migration workflows to prevent data loss and maintain consistency.
What performance-first practices does Drizzle ORM recommend?
Drizzle ORM emphasizes performance through indexing strategies, N+1 query prevention, and efficient transaction patterns. Use prepared statements to reduce parsing overhead and leverage batch operations where possible. The skill teaches validation steps, common pitfalls to avoid, and monitoring approaches. Proper schema design with appropriate indexes, combined with thoughtful query construction, ensures your Drizzle ORM applications scale efficiently.
How does Drizzle ORM handle database migrations?
Drizzle ORM generates migrations automatically from your schema definitions, which you manage through package scripts. This approach ensures migrations stay synchronized with your TypeScript schema code. The skill covers safe migration workflows, including testing strategies and rollback procedures. Drizzle ORM supports both SQL and programmatic migrations, allowing you to handle complex schema changes while maintaining data integrity.
Can you manage database relationships and transactions in Drizzle?
Drizzle ORM supports relationship definitions through foreign keys and provides comprehensive transaction support for multi-step operations. Define relationships in your schema, then use Drizzle ORM's query builder to fetch related data efficiently. Transactions ensure data consistency across multiple operations. The skill covers relationship patterns, transaction best practices, and techniques to prevent common issues like N+1 queries when working with related data.
Let your AI agent find skills like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 56,283 agent skills by what they can do, searchable in plain language.
wish › “Learn how to set up and use Drizzle ORM for database operations”
Give your agent the search over MCP, or paste the wish link into any chat. No install? Search from any chat →
Related skills
Build type-safe PostgreSQL applications using Drizzle ORM with guidance on schema design, migrations, and query optimization. Covers essential patterns for relationships, transactions, and connection pooling alongside performance best practices like indexing foreign keys and avoiding N+1 queries.
Drizzle is a TypeScript-first ORM built for compile-time type safety and edge-runtime performance. Define schemas with SQL-like syntax, execute queries with full type inference, and manage one-to-many and many-to-many relations without runtime dependencies.
This skill covers Drizzle ORM usage in the `@internal/dashboard-agent-db` package, the agent's dedicated conversation store. Learn schema definition with pg-core, postgres.js driver configuration, drizzle-kit migrations, and the repo's access-pattern query layer enforcing tenant scoping and foreign-key-free design. Drizzle is isolated from the main Prisma database.
Build type-safe database applications pairing PostgreSQL with Drizzle ORM. This skill covers schema design, relational queries, migrations via drizzle-kit, connection pooling, and common performance pitfalls like N+1 queries and missing indexes. Includes decision trees for modeling relationships and diagnosing slow queries.
Drizzle ORM is a lightweight, type-safe TypeScript ORM that treats SQL as a first-class citizen. This skill covers schema definition, database connections across PostgreSQL, SQLite, and Turso, relational queries, and performance patterns like proper indexing and pagination.
drizzle-orm-d1 equips you with a complete type-safe ORM layer for Cloudflare D1 databases, handling schema definition, migration generation via Drizzle Kit, and D1-specific patterns like batch operations instead of traditional transactions. It includes templates for common queries, relations, and prepared statements, plus an error catalog addressing D1-specific issues like binding errors and foreign key constraints.
More skills Drizzle Orm (unlicensed)