How does this skill assist with Cloudflare D1 migrations?

The skill provides a guided workflow for creating, testing, and applying migrations using Wrangler, ensuring that SQL scripts are idempotent and follow best practices for serverless environments.

Does this skill support the 2025 Cloudflare D1 updates?

Absolutely. It includes the latest documentation on 1TB storage limits, jurisdiction support for compliance, and automatic read-only query retries introduced in late 2025.

How does the skill handle security in database queries?

The skill strictly enforces the use of prepared statements and .bind() patterns to prevent SQL injection vulnerabilities in your Cloudflare Workers code.

Can I use this for local development?

Yes, it covers local-first migration testing using the --local flag and shows how to configure preview_database_id for a seamless development experience.

Can it help resolve performance bottlenecks in D1?

Yes, it provides specific guidance on using the .batch() API to reduce network round trips and includes instructions for indexing strategies and the PRAGMA optimize command.

Cloudflare D1 Database

Name: Cloudflare D1 Database
Author: jezweb

byjezweb

•

117

数据库管理

Manages Cloudflare D1 serverless SQLite databases, automates SQL migrations, and optimizes query performance for edge workers.

关于

This skill provides Claude with the specialized knowledge required to architect, deploy, and maintain Cloudflare D1 serverless SQLite databases within the Cloudflare Workers ecosystem. It covers the end-to-end lifecycle of database management, from initial resource provisioning and type-safe query implementation to complex schema migrations and performance tuning. By incorporating the latest 2025 updates—including jurisdiction support for data localization and read replication—it ensures that developers can build highly available, compliant, and performant relational data solutions directly on the edge.

主要功能

Integration of 2025 features including data localization (jurisdictions) and automatic query retries.
Deep troubleshooting for D1-specific errors such as statement length limits and transaction conflicts.
Database optimization strategies using PRAGMA optimize and advanced indexing techniques.
Standardized SQL migration workflow with idempotent schema management and transactional rollbacks.
High-performance query patterns utilizing batching and prepared statements to minimize latency.
117 GitHub stars

使用场景

Developing production-ready serverless REST APIs with relational persistence on Cloudflare Workers.
Managing complex schema evolutions and data migrations across local development and global production environments.
Scaling high-traffic applications using read-replicas and optimized batch processing for relational data.

关于

主要功能

Integration of 2025 features including data localization (jurisdictions) and automatic query retries.
Deep troubleshooting for D1-specific errors such as statement length limits and transaction conflicts.
Database optimization strategies using PRAGMA optimize and advanced indexing techniques.
Standardized SQL migration workflow with idempotent schema management and transactional rollbacks.
High-performance query patterns utilizing batching and prepared statements to minimize latency.
117 GitHub stars

使用场景

Developing production-ready serverless REST APIs with relational persistence on Cloudflare Workers.
Managing complex schema evolutions and data migrations across local development and global production environments.
Scaling high-traffic applications using read-replicas and optimized batch processing for relational data.