Batch Drizzle ORM SQL queries to stay within D1's 100 parameter limit.
npx skills add https://github.com/wodsmith/thewodapp --skill sql-batching
Please help me install this Agent Skill. Skill: sql-batching Source: https://github.com/wodsmith/thewodapp/tree/main/.claude/skills/sql-batching Command: npx skills add https://github.com/wodsmith/thewodapp --skill sql-batching
Prevents D1 "too many SQL variables" errors when using Drizzle ORM by batching queries with autochunk utilities and chunking for parallel execution.
Use autochunk to process large lists of IDs, or autochunkFirst for a first-match query across batches.
High-intent search queries and answers about installing and using this skill.
Batching SQL queries prevents 'too many SQL variables' errors by chunking operations into smaller batches that respect D1's 100 bound parameter limit. Use autochunk to automatically split large inArray() queries and bulk inserts into safe-sized batches executed in parallel.
D1 accepts a maximum of 100 bound parameters per query. When using Drizzle's inArray() or bulk insert operations with dynamic arrays, parameter counts can exceed this limit, causing query failures. Batching divides the operation to stay within bounds.
Use autochunk or autochunkFirst utilities with SQL_BATCH_SIZE to automatically divide large operations into batches. autochunk executes all batches in parallel with Promise.all, while autochunkFirst returns the first result across batches.
Yes. Batching dynamically computes safe batch sizes based on total columns and existing parameters in your query, then chunks the array accordingly, ensuring total bound parameters never exceed D1's 100-parameter limit.
Use autochunk when you need all results from all batches executed in parallel. Use autochunkFirst when searching across batches and only the first matching result is needed, reducing unnecessary batch executions.
lobehubDefine TypeScript database schemas and generate migrations with Drizzle ORM.
AlexiosBluffMaraIdentify subdomains, SSL data, WHOIS, DNS records, and domain availability for domains.
NevaberryUpdate Drizzle ORM code for v1 beta imports, drivers, relations, and migrations.
HouseGarofaloManage type-safe database access for Node.js and TypeScript with Prisma ORM.
