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

0•

Database Management

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

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

01Automated resource provisioning templates for wrangler.toml configurations

02Decision logic for choosing the right storage medium based on workload requirements

03Production-ready patterns for D1 SQL migrations and atomic batch operations

04Optimized R2 streaming implementations to prevent Worker memory exhaustion

05Comprehensive guidance for R2, D1, KV, and Durable Objects integration

060 GitHub stars

Use Cases

01Architecting multi-tenant SaaS applications using sharded D1 databases

02Building egress-free media storage and delivery systems with R2 and Workers

03Implementing high-performance global caching layers for serverless APIs using KV

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add securityronin/ronin-marketplace cloudflare-r2-d1

For use in Claude.ai and ChatGPT

Download Skill