Design type-safe database schemas, execute optimized relational queries, and manage migrations across SQLite, Postgres, and D1.
Andromity loads skills from folders you trust. Install with andromity skill install drizzle-orm — autonomy and approval limits stay configurable per session.
AgenticMarket# Install the "Drizzle ORM Specialist" skill
You are installing an AgenticMarket skill into this workspace. Follow these steps exactly.
## 1. Detect your environment and choose the destination file
- Andromity: `.andromity/skills/drizzle-orm/SKILL.md` (or user scope `~/.andromity/skills/drizzle-orm/SKILL.md`)
- Antigravity / Gemini CLI: `.agent/skills/drizzle-orm/SKILL.md`
- Cursor: `.cursor/rules/drizzle-orm.mdc`
- Claude Code: append to `CLAUDE.md` (or `.claude/skills/drizzle-orm.md`)
- Windsurf: append to `.windsurfrules`
- Cline / Roo Code: `.clinerules/drizzle-orm.md`
- GitHub Copilot: append to `.github/copilot-instructions.md`
- ChatGPT / web only: paste the content into Custom Instructions
- Any other agent: save to `.agent/skills/drizzle-orm/SKILL.md`
## 2. Create the destination file
- Preserve every existing file and configuration entry.
- Create parent folders as needed.
- Never overwrite unrelated content.
## 3. Write exactly this content
```markdown
---
name: drizzle-orm
description: "Design type-safe database schemas, execute optimized relational queries, and manage migrations across SQLite, Postgres, and D1."
author: community
license: mit
version: 1.0.0
---
# Drizzle ORM Specialist
Design type-safe database schemas and zero-overhead queries:
1. Define schema in `db/schema.ts` using native dialect types (`sqliteTable`, `pgTable`).
2. Define relations explicitly via `relations(table, ({ one, many }) => ...)`.
3. Use `db.query.<table>.findMany` for nested joins without manual join queries.
4. Generate migrations with `drizzle-kit generate` and review generated SQL diffs.
```
## 4. Verify
- Confirm the file exists and is readable.
- Report the destination path and confirm the "Drizzle ORM Specialist" skill is installed and active.
Skill metadata:
- Slug: drizzle-orm
- Category: development
- License: mit
- Source: AgenticMarketDesign type-safe database schemas and zero-overhead queries:
db/schema.ts using native dialect types (sqliteTable, pgTable).relations(table, ({ one, many }) => ...).db.query.<table>.findMany for nested joins without manual join queries.drizzle-kit generate and review generated SQL diffs.Master React Server Components, Server Actions, parallel routes, streaming, ISR, and cache revalidation.
Implement Stripe Checkout sessions, webhook verification, customer portals, idempotency keys, and subscription billing.
Architect blazingly fast, memory-safe web services using Rust, Axum, Tokio async runtime, and Tower middleware.