lb-drizzle-skill（LB Drizzle 技能）

Drizzle ORM Documentation

Complete Drizzle ORM documentation embedded in markdown. Read from references/ to answer questions about schema design, querying, migrations, and database integrations.

Documentation Structure

All documentation is in references/ organized by topic:

Getting Started (references/get-started/)

• Installation and setup
• Schema definition basics
• Database connections
• First queries

Database Connections (references/connect-*.mdx)

Connect to various databases and platforms:

• PostgreSQL: connect-neon.mdx, connect-supabase.mdx, connect-effect-postgres.mdx, connect-pglite.mdx
• MySQL: connect-planetscale.mdx, connect-tidb.mdx
• SQLite: connect-cloudflare-d1.mdx, connect-turso.mdx, connect-bun-sqlite.mdx, connect-expo-sqlite.mdx, connect-op-sqlite.mdx
• Serverless: connect-drizzle-proxy.mdx, connect-cloudflare-do.mdx
• Edge: connect-nile.mdx, connect-sqlite-cloud.mdx

Column Types (references/column-types/)

All database column types and modifiers:

• PostgreSQL, MySQL, SQLite types
• Custom types and validators
• Type safety and inference

Queries & Operations

Core query builder features:

• select.mdx - Select queries
• insert.mdx - Insert operations
• update.mdx - Update operations
• delete.mdx - Delete operations
• joins.mdx - Join queries
• indexes.mdx - Index management
• views.mdx - Database views
• batch-api.mdx - Batch operations
• transactions.mdx - Transaction handling

Relations & Schema (references/relations/)

• One-to-one, one-to-many, many-to-many
• Foreign keys and constraints
• Cascading operations

Migrations (references/migrate/)

Schema migration tools:

• drizzle-kit usage
• Migration generation
• Push vs generate modes
• Migration deployment

Integrations & Extensions (references/extensions/)

• Validation (Zod, Valibot, Arktype, Effect)
• Type safety enhancements
• Caching strategies

Guides (references/guides/)

Best practices and how-tos:

• Performance optimization
• Type-safe queries
• Testing strategies
• Production patterns

Tutorials (references/tutorials/)

Step-by-step walkthroughs for common use cases.

Latest Releases (references/latest-releases/)

Version-specific features and updates.

Quick Reference

Common Tasks

When to Use This Skill

• Setting up Drizzle ORM in a TypeScript project
• Defining database schemas with type safety
• Connecting to PostgreSQL, MySQL, or SQLite databases
• Working with serverless/edge databases (Neon, Supabase, D1, Turso)
• Writing type-safe queries
• Managing database migrations
• Adding validation with Zod/Valibot
• Questions about Drizzle ORM patterns and best practices

How to Navigate

1. Start with references/get-started/ for installation and basics
2. For database setup: Find relevant connect-*.mdx file
3. For schema design: Check references/column-types/ and references/relations/
4. For queries: Use query-specific files (select, insert, update, delete, joins)
5. For migrations: See references/migrate/
6. For validation: Check references/zod.mdx or other validator files
7. For best practices: Browse references/guides/

All files are .mdx (Markdown + JSX) but readable as plain markdown.