Description
drizzle is an agent skill from the LobeHub repository with a style guide for Drizzle ORM schemas and queries. It covers tables, indexes, relations, joins and inferred types, and it says rollout belongs to the separate db-migrations skill. The project layout is set out clearly: the configuration is in drizzle.config.ts, the schemas are in packages/database/src/schemas, and the migrations are in packages/database/migrations, using the postgresql dialect with strict mode on. The guide adds a testing rule that matters for contributors: every new model or repository file under packages/database/src/models or src/repositories needs a sibling test in a matching __tests__ file, because the continuous-integration coverage check will not reliably catch an untested new file. It points to the testing skill for the test database helper, user-isolation tests and the guard that skips database tests when no server database is configured. The skill helps keep schemas consistent with the rest of the codebase. It passes Gen Agent Trust Hub, Socket and Snyk on skills.sh. Install it with npx skills add https://github.com/lobehub/lobehub --skill drizzle.…
Highlights
- Style guide for Drizzle tables, indexes, relations and joins
- Covers inferred types and helper functions
- Uses postgresql dialect with strict mode in the repo
- Requires a sibling test for new model and repository files
Ratings & Reviews
No ratings yet
Be the first to rate drizzle.
People also visit
database-migrations
Safe, reversible database migration patterns: forward-only production changes
kotlin-exposed-patterns
JetBrains Exposed ORM patterns including DSL queries, DAO pattern, transactions
postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing
drizzle FAQ
What does the skill cover?
Drizzle schemas and queries, including tables, indexes, relations, joins and inferred types.
Where are the schemas and migrations?
Schemas are in packages/database/src/schemas and migrations are in packages/database/migrations.
What if I add a new model?
Add a matching test file in the __tests__ folder next to it, since CI's coverage check may miss a new untested file.
Does it cover rolling out a migration?
No. That belongs to the db-migrations skill.
How do I install it?
Run npx skills add https://github.com/lobehub/lobehub --skill drizzle.
Which security audits does it have?
On skills.sh, Gen Agent Trust Hub, Socket and Snyk all pass.
What are the best drizzle alternatives?
Popular alternatives to drizzle include database-design, prisma-expert and database-migrations. See all drizzle alternatives