drizzle-orm-expert — Claude Code skill: what it does, how to install
Guides schema authoring, relational queries, and migrations in Drizzle ORM. Helpful when structuring type-safe database layers in TypeScript.
npx claude-code-templates@latest --skill web-development/drizzle-orm-expertWhat drizzle-orm-expert does
This skill assists Claude Code with setting up type-safe persistence using Drizzle ORM in TypeScript projects. It supplies patterns for table declarations via pgTable, entity associations with relations, and automatic type inference using InferSelectModel.
The guidelines cover SQL-style selects with joins, batch inserts, and nested relational reads without N+1 query pitfalls. It also details migration handling via drizzle-kit commands, transactional updates, and client connections for Neon, Turso, or PlanetScale.
Drizzle translates directly into SQL without relying on an external engine binary. Because of this architecture, your schemas require exact TypeScript type definitions upfront.
What it helps with
- define database tables and foreign keys in TypeScript
- execute nested relational queries without triggering N+1 issues
- generate and run schema migrations using
drizzle-kit - connect Drizzle to serverless drivers like Neon, LibSQL, or PlanetScale
Example prompts for the agent
- Generate a Drizzle schema for users and posts with a one-to-many relation
- Write a relational query fetching authors and their published posts
- Configure
drizzle.config.tsand generate a migration for PostgreSQL
How to install drizzle-orm-expert
1claude-code-templates
npx claude-code-templates@latest --skill web-development/drizzle-orm-expert2Skills CLI (Vercel)
npx skills add davila7/claude-code-templates --skill drizzle-orm-expert -a claude-code3Manually: put the files in place
~/.claude/skills/drizzle-orm-expert/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/drizzle-orm-expert/
Manually: put the files in place
.agents/skills/drizzle-orm-expert/SKILL.mdFor all projects use ~/.agents/skills/
Manually: put the files in place
.cursor/skills/drizzle-orm-expert/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install davila7/claude-code-templates drizzle-orm-expert2Manually: put the files in place
.github/skills/drizzle-orm-expert/SKILL.mdPlatform CLI
gemini skills install https://github.com/davila7/claude-code-templates --path cli-tool/components/skills/web-development/drizzle-orm-expertManually: put the files in place
.devin/skills/drizzle-orm-expert/SKILL.mdThe legacy .windsurf/skills/ path still works
Claude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about drizzle-orm-expert
How do I install drizzle-orm-expert in Claude Code?
Run npx claude-code-templates@latest --skill web-development/drizzle-orm-expert in your terminal.
What is the purpose of drizzle-orm-expert?
It guides Claude Code in writing TypeScript schemas, relational queries, migrations, and database clients using Drizzle ORM.
Which serverless databases are covered?
The skill includes setup patterns for Neon serverless PostgreSQL, Turso LibSQL, and PlanetScale MySQL.