secondsky/claude-skills / plugins/drizzle-orm-d1/skills/drizzle-orm-d1
drizzle-orm-d1
Verified| Type-safe ORM for Cloudflare D1 databases using Drizzle. Use when: building D1 database schemas, writing type-safe SQL queries, managing migrations with Drizzle Kit, defining table relations, implementing prepared statements, using D1 batch API, or encountering D1_ERROR, transaction errors, foreign key constraint failures, or schema inference issues.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 9.2 KB |
| references/common-errors.md | markdown | 5.3 KB |
| references/error-catalog.md | markdown | 7.9 KB |
| references/links-to-official-docs.md | markdown | 1.8 KB |
| references/migration-workflow.md | markdown | 2.7 KB |
| references/query-builder-api.md | markdown | 3.9 KB |
| references/schema-patterns.md | markdown | 3.4 KB |
| references/wrangler-setup.md | markdown | 2.7 KB |
| scripts/check-versions.shexecutable | script | 1017 B |
| templates/basic-queries.ts | script | 7.5 KB |
| templates/basic-schema.ts | script | 2.9 KB |
| templates/client.ts | script | 2.2 KB |
| templates/cloudflare-worker-integration.ts | script | 7.7 KB |
| templates/drizzle.config.ts | script | 2.2 KB |
| templates/migrations/0001_example.sql | other | 2.1 KB |
| templates/package.json | manifest | 1.1 KB |
| templates/prepared-statements.ts | script | 7.3 KB |
| templates/relations-queries.ts | script | 6.8 KB |
| templates/schema.ts | script | 6.5 KB |
| templates/transactions.ts | script | 6.8 KB |
templates/drizzle.config.ts
View on GitHubimport { defineConfig } from 'drizzle-kit';
/**
* Drizzle Kit Configuration for Cloudflare D1
*
* This configuration uses the D1 HTTP driver to connect to your Cloudflare D1
* database for running migrations, introspection, and Drizzle Studio.
*
* IMPORTANT: Never commit credentials to version control!
* Use environment variables for all sensitive data.
*/
export default defineConfig({
// Schema location (can be a single file or directory)
schema: './src/db/schema.ts',
// Output directory for generated migrations
// This should match the migrations_dir in wrangler.jsonc
out: './migrations',
// Database dialect (D1 is SQLite-based)
dialect: 'sqlite',
// Driver for connecting to D1 via HTTP API
driver: 'd1-http',
// Cloudflare credentials (from environment variables)
dbCredentials: {
accountId: process.env.CLOUDFLARE_ACCOUNT_ID!,
databaseId: process.env.CLOUDFLARE_DATABASE_ID!,
token: process.env.CLOUDFLARE_D1_TOKEN!,
},
// Enable verbose output for debugging
verbose: true,
// Enable strict mode (recommended)
strict: true,
});
/**
* How to get credentials:
*
* 1. CLOUDFLARE_ACCOUNT_ID
* - Go to Cloudflare Dashboard
* - Click on your account
* - Account ID is shown in the right sidebar
*
* 2. CLOUDFLARE_DATABASE_ID
* - Run: wrangler d1 list
* - Find your database and copy the Database ID
* - Or create a new database: wrangler d1 create my-database
*
* 3. CLOUDFLARE_D1_TOKEN
* - Go to Cloudflare Dashboard → My Profile → API Tokens
* - Click "Create Token"
* - Use template "Edit Cloudflare Workers" or create custom token
* - Make sure it has D1 permissions
*/
/**
* Create a .env file in your project root:
*
* CLOUDFLARE_ACCOUNT_ID=your-account-id-here
* CLOUDFLARE_DATABASE_ID=your-database-id-here
* CLOUDFLARE_D1_TOKEN=your-api-token-here
*
* Never commit .env to Git! Add it to .gitignore.
*/
/**
* Usage:
*
* # Generate migration from schema changes
* npx drizzle-kit generate
*
* # Push schema directly to database (dev only, not recommended for prod)
* npx drizzle-kit push
*
* # Open Drizzle Studio to browse your database
* npx drizzle-kit studio
*
* # Introspect existing database
* npx drizzle-kit introspect
*/
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |