drizzle-patterns
Build Drizzle PostgreSQL Patterns
Teams need consistent Drizzle ORM patterns for PostgreSQL projects. This skill provides schema, relation, query, mutation, transaction, and migration examples.
Install with my Agent
Copy this request to your Agent. It includes the canonical Skill page and manifest.
Review the Skillstore skill "drizzle-patterns" from https://skillstore.io/skills/barnhardt-enterprises-inc-drizzle-patterns.md and its manifest at https://skillstore.io/api/skills/barnhardt-enterprises-inc-drizzle-patterns/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 "drizzle-patterns". Create a Drizzle user schema for a PostgreSQL app.
Expected outcome:
A users table plan with UUID primary keys, unique email, profile fields, timestamps, and inferred TypeScript model guidance.
Using "drizzle-patterns". Show how to query verified users with posts.
Expected outcome:
A query approach using relation loading, a verified-email filter, newest-first sorting, and a small result limit.
Using "drizzle-patterns". Plan a migration for a new profiles table.
Expected outcome:
- Define the profiles table and relation.
- Generate a migration with Drizzle Kit.
- Review database changes before applying them.
Security Audit
SafeThe static command findings are Markdown code fence matches or sample Drizzle Kit CLI commands, not embedded execution logic. Environment findings only show standard process.env.DATABASE_URL use in examples with no secret disclosure, file access, network exfiltration, or prompt injection evidence.
Risk Factors
⚙️ External commands (15)
🔑 Env variables (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/barnhardt-enterprises-inc-drizzle-patterns/audits/8?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_reportMarkdown badge
[](https://skillstore.io/skills/barnhardt-enterprises-inc-drizzle-patterns?utm_source=security_passport_badge)HTML badge
<a href="https://skillstore.io/skills/barnhardt-enterprises-inc-drizzle-patterns?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/barnhardt-enterprises-inc-drizzle-patterns/security.svg" alt="Skillstore security assessment" loading="lazy"></a>Embed card
<iframe src="https://skillstore.io/embed/skills/barnhardt-enterprises-inc-drizzle-patterns.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
Barnhardt-Enterprises-Inc. (2026). drizzle-patterns security audit report (audit version 8) [Author version unspecified]. Skillstore. https://skillstore.io/skills/barnhardt-enterprises-inc-drizzle-patterns/audits/8BibTeX citation
@techreport{barnhardt-enterprises-inc-barnhardt-enterprises-inc-drizzle-patterns-2026,
author = {Barnhardt-Enterprises-Inc},
title = {drizzle-patterns security audit report (audit version 8)},
institution = {Skillstore},
year = {2026},
number = {8},
url = {https://skillstore.io/skills/barnhardt-enterprises-inc-drizzle-patterns/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: "drizzle-patterns security audit report (audit version 8)"
version: "unspecified"
type: report
authors:
- name: "Barnhardt-Enterprises-Inc"
date-released: "2026-07-06"
url: "https://skillstore.io/skills/barnhardt-enterprises-inc-drizzle-patterns/audits/8"
identifiers:
- type: other
value: "skillstore:barnhardt-enterprises-inc-drizzle-patterns:audit:8"
description: "Skillstore immutable audit report identifier"
Skillstore Score
Why this score Evidence Confidence: HighWhat You Can Build
Scaffold a Database Layer
Create consistent schema, relation, and client patterns for a new TypeScript application.
Review Query Style
Compare project queries against simple Drizzle patterns for filters, sorting, and relation loading.
Standardize Migrations
Document common Drizzle Kit commands for generating, applying, and inspecting database migrations.
Try These Prompts
Use drizzle-patterns to outline a PostgreSQL user schema with inferred types. Explain each field choice in plain language.
Use drizzle-patterns to design relations between users and posts. Include the purpose of each relation and reference field.
Use drizzle-patterns to review these Drizzle queries for filtering, sorting, relation loading, and return shape consistency.
Use drizzle-patterns to plan a safe migration workflow for a new table. Include generation, review, application, and rollback considerations.
Best Practices
- Keep credentials in environment variables and never hardcode database URLs.
- Review generated migrations before applying them to shared databases.
- Reuse inferred insert and select types across service code.
Avoid
- Do not run schema push against production without review.
- Do not paste real connection strings into prompts, examples, or commits.
- Do not copy sample table names without matching business requirements.
Frequently Asked Questions
What database does this skill target?
Does it generate complete applications?
Can Claude or Codex use this skill?
Does it store database credentials?
Does it cover migrations?
What should users customize first?
Developer Details
Author
Barnhardt-Enterprises-IncLicense
MIT
Skillstore revision
r1
Version notice
The author did not declare a version.
Repository
https://github.com/Barnhardt-Enterprises-Inc/quetrex-claude/tree/main/skills/drizzle-patternsRef
c4231f0153ccd2a2ed62274c5a372bf8f2386d3f
Maintenance freshness
7/21/2026
Usage
7 downloads · 246 views
File structure
📄 SKILL.md