Skills
.Work. You
Rest

sql-batching

Official

Batch SQL queries to respect D1's limit.

Software Engineering#drizzle#sql#batching#d1#bulk-insert#inArray
Authorwodsmith
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Prevents D1 "too many SQL variables" errors when using Drizzle ORM by batching queries with autochunk utilities and chunking for parallel execution.

Core Features & Use Cases

  • 100 parameter limit awareness: D1's actual limit is 100 bound parameters per query
  • Batch utilities: autochunk, autochunkFirst, and chunk with SQL_BATCH_SIZE
  • Bulk inserts & inArray: handle dynamic arrays and parameter counts

Quick Start

Use autochunk to process large lists of IDs, or autochunkFirst for a first-match query across batches.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: sql-batching
Download link: https://github.com/wodsmith/thewodapp/archive/main.zip#sql-batching

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.