pitfalls-drizzle-orm
Avoid Drizzle ORM Migration Pitfalls
Drizzle ORM schema mistakes can break migrations and weaken type safety. This skill guides Claude, Codex, and Claude Code toward safer patterns.
Install with my Agent
Copy this request to your Agent. It includes the canonical Skill page and manifest.
Review the Skillstore skill "pitfalls-drizzle-orm" from https://skillstore.io/skills/barissozen-pitfalls-drizzle-orm.md and its manifest at https://skillstore.io/api/skills/barissozen-pitfalls-drizzle-orm/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.Your Agent should still show its plan and request any confirmation required by the security policy.
Agent-readable resources
Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.
Test it
Using "pitfalls-drizzle-orm". A schema review request with an array column and missing inferred insert type.
Expected outcome:
- Flags the incorrect array column pattern.
- Recommends the Drizzle array helper style used by the skill.
- Notes that insert and select types should be exported from the schema.
Using "pitfalls-drizzle-orm". A migration plan that changes a primary key from serial to uuid.
Expected outcome:
- Marks the primary key type change as a migration blocker.
- Explains that production data and references need a safer migration plan.
- Suggests testing in development and preparing backups before any risky operation.
Using "pitfalls-drizzle-orm". A request to add validation around Drizzle inserts.
Expected outcome:
- Recommends using drizzle-zod schema generation.
- Connects validation types to the Drizzle table definition.
- Keeps database and runtime validation contracts aligned.
Security Audit
SafeAll static findings were false positives caused by Markdown code fences and explanatory database examples. No prompt injection, credential access, network activity, or malicious command execution intent was found in SKILL.md.
Risk Factors
⚙️ External commands (6)
Share & cite this report
Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.
Copy report link
https://skillstore.io/skills/barissozen-pitfalls-drizzle-orm/audits/8?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_reportMarkdown badge
[](https://skillstore.io/skills/barissozen-pitfalls-drizzle-orm?utm_source=security_passport_badge)HTML badge
<a href="https://skillstore.io/skills/barissozen-pitfalls-drizzle-orm?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/barissozen-pitfalls-drizzle-orm/security.svg" alt="Skillstore security assessment" loading="lazy"></a>Embed card
<iframe src="https://skillstore.io/embed/skills/barissozen-pitfalls-drizzle-orm.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>Academic citations (APA · BibTeX · CFF)
APA citation
BarisSozen. (2026). pitfalls-drizzle-orm security audit report (audit version 8) [Author version unspecified]. Skillstore. https://skillstore.io/skills/barissozen-pitfalls-drizzle-orm/audits/8BibTeX citation
@techreport{barissozen-barissozen-pitfalls-drizzle-orm-2026,
author = {BarisSozen},
title = {pitfalls-drizzle-orm security audit report (audit version 8)},
institution = {Skillstore},
year = {2026},
number = {8},
url = {https://skillstore.io/skills/barissozen-pitfalls-drizzle-orm/audits/8},
note = {Author version unspecified}
}CITATION.cff
cff-version: 1.2.0
message: "If you use this Skill, cite its author and this versioned security audit report."
title: "pitfalls-drizzle-orm security audit report (audit version 8)"
version: "unspecified"
type: report
authors:
- name: "BarisSozen"
date-released: "2026-07-05"
url: "https://skillstore.io/skills/barissozen-pitfalls-drizzle-orm/audits/8"
identifiers:
- type: other
value: "skillstore:barissozen-pitfalls-drizzle-orm:audit:8"
description: "Skillstore immutable audit report identifier"
Skillstore Score
Why this score Evidence Confidence: HighWhat You Can Build
Review a new Drizzle schema
Check schema definitions for primary key changes, array syntax, and exported inferred types before merging.
Prepare a migration safely
Evaluate whether a planned migration may cause data loss and confirm safer testing steps first.
Improve validation coverage
Add or review drizzle-zod validation patterns that align with Drizzle insert and select schemas.
Try These Prompts
Review this Drizzle ORM schema for common pitfalls. Check primary keys, array column syntax, inferred types, and validation gaps.
Assess this planned Drizzle migration. Identify data-loss risks, primary key changes, and steps I should test before applying it.
Update this Drizzle schema pattern to include select types, insert types, and drizzle-zod validation. Explain each change briefly.
Audit these Drizzle ORM schema changes as a release reviewer. Flag migration blockers, unsafe force-push risks, and missing validation contracts.
Best Practices
- Review primary key type changes as release blockers unless a planned migration path exists.
- Export inferred select and insert types beside each important Drizzle table definition.
- Test migrations in development and review data-loss warnings before production deployment.
Avoid
- Running forced schema pushes in production without a verified backup and rollback plan.
- Using custom array helpers when Drizzle table columns support the documented array method.
- Duplicating TypeScript model types by hand instead of inferring them from Drizzle schemas.
Frequently Asked Questions
What does this skill help with?
Does it run database commands automatically?
Can it make production migrations safe by itself?
Why does it warn about primary key type changes?
Which AI coding tools can use it?
Is this a full Drizzle ORM tutorial?
Developer Details
Author
BarisSozenLicense
MIT
Skillstore revision
r1
Version notice
The author did not declare a version.
Ref
5ab1d37e83436c6eef84de88573e142b94f2a4ad
Maintenance freshness
7/20/2026
Usage
5 downloads · 216 views
File structure
📄 SKILL.md