How does it manage D1 transactions in a serverless environment?

Since traditional SQL transactions are not supported in Workers, this skill provides the correct patterns for using the .batch() method to ensure atomic operations.

Does it support S3-compatible operations for R2?

Yes, it includes implementation details for both the native Workers R2 API and S3-compatible presigned URLs using aws4fetch.

Can this skill help prevent Worker memory crashes?

Yes, it includes 'Gotcha' documentation that demonstrates how to stream large R2 objects directly to the response instead of buffering them into memory.

How does this skill handle D1's 10GB size limit?

The skill provides specific strategies for horizontal sharding across multiple smaller databases (per-user or per-tenant) to scale beyond the single-database limit.

When should I use KV instead of D1 according to this skill?

It provides a clear decision tree: use KV for high-read/low-write configuration and session data, and use D1 for relational workloads requiring SQL queries.

Cloudflare R2 & D1 Storage Mastery

Name: Cloudflare R2 & D1 Storage Mastery
Author: SecurityRonin

bySecurityRonin

Database Management

Optimizes development with Cloudflare's edge storage products including R2 object storage, D1 SQL databases, and KV namespaces through battle-tested patterns.

About

This skill empowers Claude to architect and implement high-performance edge storage solutions using the Cloudflare ecosystem. It provides immediate access to critical platform constraints—such as D1's 10GB database limit and KV's write-per-second cap—while offering production-ready patterns for SQL migrations, S3-compatible object handling, and multi-tenant database sharding. Whether building serverless APIs or media-heavy applications, this skill ensures your implementation follows the latest best practices for data consistency, cost-optimization, and edge performance.

Key Features

Automated resource provisioning templates for wrangler.toml configurations
Decision logic for choosing the right storage medium based on workload requirements
Production-ready patterns for D1 SQL migrations and atomic batch operations
Optimized R2 streaming implementations to prevent Worker memory exhaustion
Comprehensive guidance for R2, D1, KV, and Durable Objects integration
0 GitHub stars

Use Cases

Architecting multi-tenant SaaS applications using sharded D1 databases
Building egress-free media storage and delivery systems with R2 and Workers
Implementing high-performance global caching layers for serverless APIs using KV

About

Key Features

Automated resource provisioning templates for wrangler.toml configurations
Decision logic for choosing the right storage medium based on workload requirements
Production-ready patterns for D1 SQL migrations and atomic batch operations
Optimized R2 streaming implementations to prevent Worker memory exhaustion
Comprehensive guidance for R2, D1, KV, and Durable Objects integration
0 GitHub stars

Use Cases

Architecting multi-tenant SaaS applications using sharded D1 databases
Building egress-free media storage and delivery systems with R2 and Workers
Implementing high-performance global caching layers for serverless APIs using KV