Can I use this skill with the Hono framework?

Yes, it includes specific implementation patterns for Hono, including binding D1 to the Hono environment for easy database access.

What is Cloudflare D1?

Cloudflare D1 is a serverless relational database built on SQLite, designed to be globally distributed and natively integrated with Cloudflare Workers.

How does this skill handle D1 migrations?

The skill provides standardized workflows for creating versioned SQL files, testing them on a local environment, and safely applying them to production using Wrangler.

Does D1 support transactions?

While D1 doesn't support traditional multi-statement transactions, it uses batch() operations to execute multiple statements sequentially in a single network round-trip with transactional-like behavior.

How do I fix 'Statement too long' errors in D1?

This skill helps you refactor large queries into batches of 100-250 rows using the batch() API to stay within Cloudflare's operational limits.

Cloudflare D1 Database Manager

Name: Cloudflare D1 Database Manager
Author: jezweb

byjezweb

•

数据库管理

Manages serverless SQLite databases on Cloudflare's edge with automated migrations, optimized queries, and full Worker integration.

This skill empowers Claude to architect, deploy, and optimize Cloudflare D1 serverless databases. It provides comprehensive guidance on writing type-safe SQL migrations, implementing efficient batch processing for performance, and navigating the nuances of the D1 Worker API. Whether you are setting up a new project with Wrangler or troubleshooting complex query plans and migration failures, this skill ensures best practices for relational data at the edge, including support for read replication and data localization compliance.

主要功能

01Comprehensive troubleshooting for D1 errors and statement limits

02Optimized SQL query patterns using type-safe prepared statements

03Seamless integration with Hono and Cloudflare Workers Bindings

04High-performance batch operation implementation for bulk data

0591 GitHub stars

06Automated D1 migration workflow for local and production environments

使用场景

01Managing database schema evolution through versioned SQL migrations

02Optimizing edge database performance using PRAGMA and indexing

03Building serverless REST APIs with global relational data storage

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jezweb/claude-skills cloudflare-d1

For use in Claude.ai and ChatGPT

Download Skill