Cloudflare Deploy

JetBrainsOfficialCreated by OpenAIDistributed by JetBrains

Skill
Tool integration
Cloud and DevOps
Apache-2.0
Medium risk

From the author

Deploy applications and infrastructure to Cloudflare using Workers, Pages, and related platform services. Use when the user asks to deploy, host, publish, or set up a project on Cloudflare.

— the description by OpenAI

AutoGineer summary

Written by AutoGineer from the skill’s own files, not by the author

The Cloudflare Deploy skill serves as a centralized hub for developers working within the Cloudflare ecosystem. It provides structured decision trees to help users select the appropriate Cloudflare product—ranging from compute and storage to AI and security—and offers guidance on authentication, deployment, and troubleshooting. The skill includes specific references for building stateful, distributed AI agents using the Cloudflare Agents SDK, covering lifecycle hooks, state management, and SQL integration.

What it does

Provides decision trees to select the right Cloudflare product for compute, storage, AI, or networking needs.
Offers guidance on authentication using Wrangler for local and CI/CD environments.
Includes detailed documentation for building stateful AI agents with the Cloudflare Agents SDK.
Supports infrastructure-as-code integration via Pulumi and Terraform.
Provides troubleshooting steps for network-related deployment failures.
Maps specific use cases to relevant product references and technical documentation.

When to use it

When you need to deploy, host, or publish a project on Cloudflare.
When you are unsure which Cloudflare product best fits your compute, storage, or AI requirements.
When building stateful AI agents that require persistent memory and real-time connections.
When you need to configure security, networking, or media optimization services on Cloudflare.
When troubleshooting deployment timeouts or network connectivity issues.

Advantages

Consolidates fragmented documentation into a single, navigable resource.
Simplifies product selection through clear, logic-based decision trees.
Provides ready-to-use code patterns for complex tasks like AI agent development.
Addresses common operational hurdles like authentication and network sandboxing.

Usage examples

“I need to deploy a full-stack web application to Cloudflare. Which product should I use?”: The agent will guide you to use Cloudflare Pages for Git-based deployments and provide the necessary steps to get started.
“How do I build a stateful AI chat agent on Cloudflare?”: The agent will provide the AIChatAgent class structure, explain how to manage message history, and show how to integrate with Workers AI.
“My deployment is failing with a network timeout. What should I do?”: The agent will recommend rerunning the deployment with escalated permissions using the sandbox_permissions=require_escalated flag.

Install

Download the skill as a ZIP:
https://autogineer.com/agent-skills/jetbrains/cloudflare-deploy/download

Unzip it into the cross-client skills folder of your project:

mkdir -p .agents/skills && unzip cloudflare-deploy.zip -d .agents/skills

Documentation by OpenAI

Cloudflare Deploy

Consolidated skill for building on the Cloudflare platform. Use decision trees below to find the right product, then load detailed references.

Prerequisites

When sandboxing blocks the deployment network calls, rerun with sandbox_permissions=require_escalated.
The deployment might take a few minutes. Use appropriate timeout values.

Authentication (Required Before Deploy)

Verify auth before wrangler deploy, wrangler pages deploy, or npm run deploy:

npx wrangler whoami    # Shows account if authenticated

Not authenticated? → references/wrangler/auth.md

Interactive/local: wrangler login (one-time OAuth)
CI/CD: Set CLOUDFLARE_API_TOKEN env var

Quick Decision Trees

"I need to run code"

Need to run code?
├─ Serverless functions at the edge → workers/
├─ Full-stack web app with Git deploys → pages/
├─ Stateful coordination/real-time → durable-objects/
├─ Long-running multi-step jobs → workflows/
├─ Run containers → containers/
├─ Multi-tenant (customers deploy code) → workers-for-platforms/
├─ Scheduled tasks (cron) → cron-triggers/
├─ Lightweight edge logic (modify HTTP) → snippets/
├─ Process Worker execution events (logs/observability) → tail-workers/
└─ Optimize latency to backend infrastructure → smart-placement/

"I need to store data"

Need storage?
├─ Key-value (config, sessions, cache) → kv/
├─ Relational SQL → d1/ (SQLite) or hyperdrive/ (existing Postgres/MySQL)
├─ Object/file storage (S3-compatible) → r2/
├─ Message queue (async processing) → queues/
├─ Vector embeddings (AI/semantic search) → vectorize/
├─ Strongly-consistent per-entity state → durable-objects/ (DO storage)
├─ Secrets management → secrets-store/
├─ Streaming ETL to R2 → pipelines/
└─ Persistent cache (long-term retention) → cache-reserve/

"I need AI/ML"

Need AI?
├─ Run inference (LLMs, embeddings, images) → workers-ai/
├─ Vector database for RAG/search → vectorize/
├─ Build stateful AI agents → agents-sdk/
├─ Gateway for any AI provider (caching, routing) → ai-gateway/
└─ AI-powered search widget → ai-search/

"I need networking/connectivity"

Need networking?
├─ Expose local service to internet → tunnel/
├─ TCP/UDP proxy (non-HTTP) → spectrum/
├─ WebRTC TURN server → turn/
├─ Private network connectivity → network-interconnect/
├─ Optimize routing → argo-smart-routing/
├─ Optimize latency to backend (not user) → smart-placement/
└─ Real-time video/audio → realtimekit/ or realtime-sfu/

"I need security"

Need security?
├─ Web Application Firewall → waf/
├─ DDoS protection → ddos/
├─ Bot detection/management → bot-management/
├─ API protection → api-shield/
├─ CAPTCHA alternative → turnstile/
└─ Credential leak detection → waf/ (managed ruleset)

"I need media/content"

Need media?
├─ Image optimization/transformation → images/
├─ Video streaming/encoding → stream/
├─ Browser automation/screenshots → browser-rendering/
└─ Third-party script management → zaraz/

"I need infrastructure-as-code"

Need IaC? → pulumi/ (Pulumi), terraform/ (Terraform), or api/ (REST API)

Product Index

Compute & Runtime

Product	Reference
Workers	`references/workers/`
Pages	`references/pages/`
Pages Functions	`references/pages-functions/`
Durable Objects	`references/durable-objects/`
Workflows	`references/workflows/`
Containers	`references/containers/`
Workers for Platforms	`references/workers-for-platforms/`
Cron Triggers	`references/cron-triggers/`
Tail Workers	`references/tail-workers/`
Snippets	`references/snippets/`
Smart Placement	`references/smart-placement/`

Storage & Data

Product	Reference
KV	`references/kv/`
D1	`references/d1/`
R2	`references/r2/`
Queues	`references/queues/`
Hyperdrive	`references/hyperdrive/`
DO Storage	`references/do-storage/`
Secrets Store	`references/secrets-store/`
Pipelines	`references/pipelines/`
R2 Data Catalog	`references/r2-data-catalog/`
R2 SQL	`references/r2-sql/`

AI & Machine Learning

Product	Reference
Workers AI	`references/workers-ai/`
Vectorize	`references/vectorize/`
Agents SDK	`references/agents-sdk/`
AI Gateway	`references/ai-gateway/`
AI Search	`references/ai-search/`

Networking & Connectivity

Product	Reference
Tunnel	`references/tunnel/`
Spectrum	`references/spectrum/`
TURN	`references/turn/`
Network Interconnect	`references/network-interconnect/`
Argo Smart Routing	`references/argo-smart-routing/`
Workers VPC	`references/workers-vpc/`

Security

Product	Reference
WAF	`references/waf/`
DDoS Protection	`references/ddos/`
Bot Management	`references/bot-management/`
API Shield	`references/api-shield/`
Turnstile	`references/turnstile/`

Media & Content

Product	Reference
Images	`references/images/`
Stream	`references/stream/`
Browser Rendering	`references/browser-rendering/`
Zaraz	`references/zaraz/`

Real-Time Communication

Product	Reference
RealtimeKit	`references/realtimekit/`
Realtime SFU	`references/realtime-sfu/`

Developer Tools

Product	Reference
Wrangler	`references/wrangler/`
Miniflare	`references/miniflare/`
C3	`references/c3/`
Observability	`references/observability/`
Analytics Engine	`references/analytics-engine/`
Web Analytics	`references/web-analytics/`
Sandbox	`references/sandbox/`
Workerd	`references/workerd/`
Workers Playground	`references/workers-playground/`

Infrastructure as Code

Product	Reference
Pulumi	`references/pulumi/`
Terraform	`references/terraform/`
API	`references/api/`

Other Services

Product	Reference
Email Routing	`references/email-routing/`
Email Workers	`references/email-workers/`
Static Assets	`references/static-assets/`
Bindings	`references/bindings/`
Cache Reserve	`references/cache-reserve/`

Troubleshooting

Escalated Network Access

If deployment fails due to network issues (timeouts, DNS errors, connection resets), rerun the deploy with escalated permissions (use sandbox_permissions=require_escalated). The deploy requires escalated network access when sandbox networking blocks outbound requests.

Example guidance to the user:

The deploy needs escalated network access to deploy to Cloudflare. I can rerun the command with escalated permissions—want me to proceed?

Files

ATTRIBUTION.mdAdded by AutoGineer930 B
LICENSE.txt10.5 KiB
SKILL.md7.4 KiB
agents/openai.yaml331 B
assets/cloudflare-small.svg1.2 KiB
assets/cloudflare.png1.2 KiB
references/agents-sdk/README.md2.7 KiB
references/agents-sdk/api.md5.7 KiB
references/agents-sdk/configuration.md3.5 KiB
references/agents-sdk/gotchas.md5.0 KiB
references/agents-sdk/patterns.md5.5 KiB
references/ai-gateway/README.md6.2 KiB
references/ai-gateway/configuration.md2.9 KiB
references/ai-gateway/dynamic-routing.md1.8 KiB
references/ai-gateway/features.md2.7 KiB
references/ai-gateway/sdk-integration.md2.6 KiB
references/ai-gateway/troubleshooting.md2.4 KiB
references/ai-search/README.md4.4 KiB
references/ai-search/api.md2.5 KiB
references/ai-search/configuration.md1.7 KiB
references/ai-search/gotchas.md2.1 KiB
references/ai-search/patterns.md2.0 KiB
references/analytics-engine/README.md3.1 KiB
references/analytics-engine/api.md3.1 KiB
references/analytics-engine/configuration.md2.3 KiB
references/analytics-engine/gotchas.md2.0 KiB
references/analytics-engine/patterns.md2.3 KiB
references/api-shield/README.md1.8 KiB
references/api-shield/api.md3.8 KiB
references/api-shield/configuration.md4.9 KiB
references/api-shield/gotchas.md4.8 KiB
references/api-shield/patterns.md5.7 KiB
references/api/README.md2.3 KiB
references/api/api.md4.2 KiB
references/api/configuration.md3.7 KiB
references/api/gotchas.md5.3 KiB
references/api/patterns.md4.5 KiB
references/argo-smart-routing/README.md4.0 KiB
references/argo-smart-routing/api.md6.4 KiB
references/argo-smart-routing/configuration.md4.4 KiB
references/argo-smart-routing/gotchas.md4.2 KiB
references/argo-smart-routing/patterns.md3.0 KiB
references/bindings/README.md3.9 KiB
references/bindings/api.md5.1 KiB
references/bindings/configuration.md4.4 KiB
references/bindings/gotchas.md6.0 KiB
references/bindings/patterns.md4.9 KiB
references/bot-management/README.md3.7 KiB
references/bot-management/api.md5.7 KiB
references/bot-management/configuration.md5.6 KiB
references/bot-management/gotchas.md5.5 KiB
references/bot-management/patterns.md4.9 KiB
references/browser-rendering/README.md3.0 KiB
references/browser-rendering/api.md2.9 KiB
references/browser-rendering/configuration.md1.8 KiB
references/browser-rendering/gotchas.md2.5 KiB
references/browser-rendering/patterns.md2.6 KiB
references/c3/README.md3.3 KiB
references/c3/api.md2.2 KiB
references/c3/configuration.md1.6 KiB
references/c3/gotchas.md2.3 KiB
references/c3/patterns.md2.2 KiB
references/cache-reserve/README.md5.5 KiB
references/cache-reserve/api.md5.9 KiB
references/cache-reserve/configuration.md3.6 KiB
references/cache-reserve/gotchas.md5.7 KiB
references/cache-reserve/patterns.md6.1 KiB
references/containers/README.md3.4 KiB
references/containers/api.md4.2 KiB
references/containers/configuration.md5.3 KiB
references/containers/gotchas.md4.4 KiB
references/containers/patterns.md4.8 KiB
references/cron-triggers/README.md2.9 KiB
references/cron-triggers/api.md5.7 KiB
references/cron-triggers/configuration.md4.2 KiB
references/cron-triggers/gotchas.md6.2 KiB
references/cron-triggers/patterns.md6.8 KiB
references/d1/README.md4.6 KiB
references/d1/api.md6.6 KiB
references/d1/configuration.md5.3 KiB
references/d1/gotchas.md4.2 KiB
references/d1/patterns.md7.1 KiB
references/ddos/README.md2.0 KiB
references/ddos/api.md4.1 KiB
references/ddos/configuration.md2.9 KiB
references/ddos/gotchas.md3.8 KiB
references/ddos/patterns.md5.5 KiB
references/do-storage/README.md2.7 KiB
references/do-storage/api.md3.5 KiB
references/do-storage/configuration.md2.2 KiB
references/do-storage/gotchas.md5.1 KiB
references/do-storage/patterns.md5.2 KiB
references/do-storage/testing.md4.8 KiB
references/durable-objects/README.md6.5 KiB
references/durable-objects/api.md6.0 KiB
references/durable-objects/configuration.md4.2 KiB
references/durable-objects/gotchas.md7.1 KiB
references/durable-objects/patterns.md6.5 KiB
references/email-routing/README.md3.4 KiB
references/email-routing/api.md5.2 KiB
references/email-routing/configuration.md3.5 KiB
references/email-routing/gotchas.md4.0 KiB
references/email-routing/patterns.md5.4 KiB
references/email-workers/README.md5.2 KiB
references/email-workers/api.md5.9 KiB
references/email-workers/configuration.md2.7 KiB
references/email-workers/gotchas.md3.0 KiB
references/email-workers/patterns.md2.7 KiB
references/hyperdrive/README.md2.8 KiB
references/hyperdrive/api.md3.8 KiB
references/hyperdrive/configuration.md3.8 KiB
references/hyperdrive/gotchas.md3.8 KiB
references/hyperdrive/patterns.md5.8 KiB
references/images/README.md2.8 KiB
references/images/api.md2.5 KiB
references/images/configuration.md4.0 KiB
references/images/gotchas.md2.4 KiB
references/images/patterns.md3.5 KiB
references/kv/README.md2.8 KiB
references/kv/api.md4.2 KiB
references/kv/configuration.md3.0 KiB
references/kv/gotchas.md4.4 KiB
references/kv/patterns.md4.6 KiB
references/miniflare/README.md2.9 KiB
references/miniflare/api.md4.5 KiB
references/miniflare/configuration.md3.4 KiB
references/miniflare/gotchas.md3.6 KiB
references/miniflare/patterns.md4.2 KiB
references/network-interconnect/README.md3.2 KiB
references/network-interconnect/api.md5.5 KiB
references/network-interconnect/configuration.md4.2 KiB
references/network-interconnect/gotchas.md5.4 KiB
references/network-interconnect/patterns.md3.9 KiB
references/observability/README.md3.8 KiB
references/observability/api.md3.4 KiB
references/observability/configuration.md3.5 KiB
references/observability/gotchas.md3.7 KiB
references/observability/patterns.md2.4 KiB
references/pages-functions/README.md3.2 KiB
references/pages-functions/api.md4.6 KiB
references/pages-functions/configuration.md2.9 KiB
references/pages-functions/gotchas.md3.8 KiB
references/pages-functions/patterns.md4.1 KiB
references/pages/README.md2.8 KiB
references/pages/api.md5.8 KiB
references/pages/configuration.md5.7 KiB
references/pages/gotchas.md7.8 KiB
references/pages/patterns.md5.9 KiB
references/pipelines/README.md3.3 KiB
references/pipelines/api.md5.0 KiB
references/pipelines/configuration.md2.7 KiB
references/pipelines/gotchas.md2.4 KiB
references/pipelines/patterns.md2.0 KiB
references/pulumi/README.md3.2 KiB
references/pulumi/api.md5.6 KiB
references/pulumi/configuration.md5.5 KiB
references/pulumi/gotchas.md6.4 KiB
references/pulumi/patterns.md6.8 KiB
references/queues/README.md3.0 KiB
references/queues/api.md5.4 KiB
references/queues/configuration.md3.7 KiB
references/queues/gotchas.md7.1 KiB
references/queues/patterns.md5.4 KiB
references/r2-data-catalog/README.md6.9 KiB
references/r2-data-catalog/api.md5.9 KiB
references/r2-data-catalog/configuration.md5.2 KiB
references/r2-data-catalog/gotchas.md6.0 KiB
references/r2-data-catalog/patterns.md5.7 KiB
references/r2-sql/README.md5.1 KiB
references/r2-sql/api.md3.9 KiB
references/r2-sql/configuration.md3.7 KiB
references/r2-sql/gotchas.md6.1 KiB
references/r2-sql/patterns.md6.6 KiB
references/r2/README.md2.8 KiB
references/r2/api.md5.5 KiB
references/r2/configuration.md3.6 KiB
references/r2/gotchas.md4.9 KiB
references/r2/patterns.md5.7 KiB
references/realtime-sfu/README.md3.0 KiB
references/realtime-sfu/api.md3.7 KiB
references/realtime-sfu/configuration.md3.4 KiB
references/realtime-sfu/gotchas.md4.8 KiB
references/realtime-sfu/patterns.md5.3 KiB
references/realtimekit/README.md4.0 KiB
references/realtimekit/api.md8.2 KiB
references/realtimekit/configuration.md5.1 KiB
references/realtimekit/gotchas.md6.7 KiB
references/realtimekit/patterns.md7.5 KiB
references/sandbox/README.md3.0 KiB
references/sandbox/api.md4.9 KiB
references/sandbox/configuration.md3.3 KiB
references/sandbox/gotchas.md5.3 KiB
references/sandbox/patterns.md5.1 KiB
references/secrets-store/README.md2.2 KiB
references/secrets-store/api.md4.3 KiB
references/secrets-store/configuration.md3.8 KiB
references/secrets-store/gotchas.md3.7 KiB
references/secrets-store/patterns.md5.5 KiB
references/smart-placement/README.md4.9 KiB
references/smart-placement/api.md5.4 KiB
references/smart-placement/configuration.md6.0 KiB
references/smart-placement/gotchas.md5.5 KiB
references/smart-placement/patterns.md5.6 KiB
references/snippets/README.md3.1 KiB
references/snippets/api.md5.0 KiB
references/snippets/configuration.md6.2 KiB
references/snippets/gotchas.md2.2 KiB
references/snippets/patterns.md3.3 KiB
references/spectrum/README.md2.3 KiB
references/spectrum/api.md4.8 KiB
references/spectrum/configuration.md4.2 KiB
references/spectrum/gotchas.md3.7 KiB
references/spectrum/patterns.md4.7 KiB
references/static-assets/README.md2.1 KiB
references/static-assets/api.md4.3 KiB
references/static-assets/configuration.md4.7 KiB
references/static-assets/gotchas.md4.0 KiB
references/static-assets/patterns.md4.8 KiB
references/stream/README.md3.8 KiB
references/stream/api-live.md5.1 KiB
references/stream/api.md5.1 KiB
references/stream/configuration.md3.1 KiB
references/stream/gotchas.md4.2 KiB
references/stream/patterns.md6.2 KiB
references/tail-workers/README.md2.9 KiB
references/tail-workers/api.md5.0 KiB
references/tail-workers/configuration.md3.4 KiB
references/tail-workers/gotchas.md4.5 KiB
references/tail-workers/patterns.md3.9 KiB
references/terraform/README.md3.6 KiB
references/terraform/api.md3.9 KiB
references/terraform/configuration.md7.4 KiB
references/terraform/gotchas.md5.1 KiB
references/terraform/patterns.md6.5 KiB
references/tunnel/README.md3.7 KiB
references/tunnel/api.md4.3 KiB
references/tunnel/configuration.md3.6 KiB
references/tunnel/gotchas.md3.8 KiB
references/tunnel/networking.md3.9 KiB
references/tunnel/patterns.md3.8 KiB
references/turn/README.md3.6 KiB
references/turn/api.md5.1 KiB
references/turn/configuration.md4.1 KiB
references/turn/gotchas.md6.9 KiB
references/turn/patterns.md6.0 KiB
references/turnstile/README.md3.5 KiB
references/turnstile/api.md6.3 KiB
references/turnstile/configuration.md6.6 KiB
references/turnstile/gotchas.md6.1 KiB
references/turnstile/patterns.md4.6 KiB
references/vectorize/README.md4.2 KiB
references/vectorize/api.md2.3 KiB
references/vectorize/configuration.md1.9 KiB
references/vectorize/gotchas.md2.1 KiB
references/vectorize/patterns.md2.5 KiB
references/waf/README.md3.4 KiB
references/waf/api.md5.7 KiB
references/waf/configuration.md4.7 KiB
references/waf/gotchas.md6.1 KiB
references/waf/patterns.md5.2 KiB
references/web-analytics/README.md5.1 KiB
references/web-analytics/configuration.md2.0 KiB
references/web-analytics/gotchas.md2.0 KiB
references/web-analytics/integration.md1.7 KiB
references/web-analytics/patterns.md2.2 KiB
references/workerd/README.md2.7 KiB
references/workerd/api.md4.8 KiB
references/workerd/configuration.md5.1 KiB
references/workerd/gotchas.md4.7 KiB
references/workerd/patterns.md4.8 KiB
references/workers-ai/README.md5.9 KiB
references/workers-ai/api.md2.7 KiB
references/workers-ai/configuration.md1.9 KiB
references/workers-ai/gotchas.md2.6 KiB
references/workers-ai/patterns.md3.0 KiB
references/workers-for-platforms/README.md3.8 KiB
references/workers-for-platforms/api.md5.4 KiB
references/workers-for-platforms/configuration.md3.8 KiB
references/workers-for-platforms/gotchas.md5.3 KiB
references/workers-for-platforms/patterns.md5.5 KiB
references/workers-playground/README.md3.9 KiB
references/workers-playground/api.md2.2 KiB
references/workers-playground/configuration.md4.4 KiB
references/workers-playground/gotchas.md2.0 KiB
references/workers-playground/patterns.md3.2 KiB
references/workers-vpc/README.md5.4 KiB
references/workers-vpc/api.md5.2 KiB
references/workers-vpc/configuration.md3.8 KiB
references/workers-vpc/gotchas.md4.4 KiB
references/workers-vpc/patterns.md5.9 KiB
references/workers/README.md3.4 KiB
references/workers/api.md5.0 KiB
references/workers/configuration.md4.3 KiB
references/workers/frameworks.md4.2 KiB
references/workers/gotchas.md4.6 KiB
references/workers/patterns.md5.3 KiB
references/workflows/README.md2.4 KiB
references/workflows/api.md6.3 KiB
references/workflows/configuration.md3.6 KiB
references/workflows/gotchas.md4.5 KiB
references/workflows/patterns.md6.5 KiB
references/wrangler/README.md4.6 KiB
references/wrangler/api.md4.5 KiB
references/wrangler/auth.md2.1 KiB
references/wrangler/configuration.md4.6 KiB
references/wrangler/gotchas.md5.7 KiB
references/wrangler/patterns.md4.8 KiB
references/zaraz/IMPLEMENTATION_SUMMARY.md3.4 KiB
references/zaraz/README.md3.8 KiB
references/zaraz/api.md3.1 KiB
references/zaraz/configuration.md1.8 KiB
references/zaraz/gotchas.md2.0 KiB
references/zaraz/patterns.md2.1 KiB

references/r2-sql/README.md

Cloudflare R2 SQL Skill Reference

Expert guidance for Cloudflare R2 SQL - serverless distributed query engine for Apache Iceberg tables.

Reading Order

New to R2 SQL? Start here:

Read "What is R2 SQL?" and "When to Use" below
configuration.md - Enable catalog, create tokens
patterns.md - Wrangler CLI and integration examples
api.md - SQL syntax and query reference
gotchas.md - Limitations and troubleshooting

Quick reference? Jump to:

What is R2 SQL?

R2 SQL is Cloudflare's serverless distributed analytics query engine for querying Apache Iceberg tables in R2 Data Catalog. Features:

Serverless - No clusters to manage, no infrastructure
Distributed - Leverages Cloudflare's global network for parallel execution
SQL interface - Familiar SQL syntax for analytics queries
Zero egress fees - Query from any cloud/region without data transfer costs
Open beta - Free during beta (standard R2 storage costs apply)

What is Apache Iceberg?

Open table format for large-scale analytics datasets in object storage:

ACID transactions - Safe concurrent reads/writes
Metadata optimization - Fast queries without full table scans
Schema evolution - Add/rename/drop columns without rewrites
Partitioning - Organize data for efficient pruning

When to Use

Use R2 SQL for:

Log analytics - Query application/system logs with WHERE filters and aggregations
BI dashboards - Generate reports from large analytical datasets
Fraud detection - Analyze transaction patterns with GROUP BY/HAVING
Multi-cloud analytics - Query data from any cloud without egress fees
Ad-hoc exploration - Run SQL queries on Iceberg tables via Wrangler CLI

Don't use R2 SQL for:

Workers/Pages runtime - R2 SQL has no Workers binding, use HTTP API from external systems
Real-time queries (<100ms) - Optimized for analytical batch queries, not OLTP
Complex joins/CTEs - Limited SQL feature set (no JOINs, subqueries, CTEs currently)
Small datasets (<1GB) - Setup overhead not justified

Decision Tree: Need to Query R2 Data?

Do you need to query structured data in R2?
├─ YES, data is in Iceberg tables
│  ├─ Need SQL interface? → Use R2 SQL (this reference)
│  ├─ Need Python API? → See r2-data-catalog reference (PyIceberg)
│  └─ Need other engine? → See r2-data-catalog reference (Spark, Trino, etc.)
│
├─ YES, but not in Iceberg format
│  ├─ Streaming data? → Use Pipelines to write to Data Catalog, then R2 SQL
│  └─ Static files? → Use PyIceberg to create Iceberg tables, then R2 SQL
│
└─ NO, just need object storage → Use R2 reference (not R2 SQL)

Architecture Overview

Query Planner:

Top-down metadata investigation with multi-layer pruning
Partition-level, column-level, and row-group pruning
Streaming pipeline - execution starts before planning completes
Early termination with LIMIT - stops when result complete

Query Execution:

Coordinator distributes work to workers across Cloudflare network
Workers run Apache DataFusion for parallel query execution
Parquet column pruning - reads only required columns
Ranged reads from R2 for efficiency

Aggregation Strategies:

Scatter-gather - simple aggregations (SUM, COUNT, AVG)
Shuffling - ORDER BY/HAVING on aggregates via hash partitioning

Quick Start

# 1. Enable R2 Data Catalog on bucket
npx wrangler r2 bucket catalog enable my-bucket

# 2. Create API token (Admin Read & Write)
# Dashboard: R2 → Manage API tokens → Create API token

# 3. Set environment variable
export WRANGLER_R2_SQL_AUTH_TOKEN=<your-token>

# 4. Run query
npx wrangler r2 sql query "my-bucket" "SELECT * FROM default.my_table LIMIT 10"

Important Limitations

CRITICAL: No Workers Binding

R2 SQL cannot be called directly from Workers/Pages code
For programmatic access, use HTTP API from external systems
Or query via PyIceberg, Spark, etc. (see r2-data-catalog reference)

SQL Feature Set:

No JOINs, CTEs, subqueries, window functions
ORDER BY supports aggregation columns (not just partition keys)
LIMIT max 10,000 (default 500)
See gotchas.md for complete limitations

In This Reference

configuration.md - Enable catalog, create API tokens
api.md - SQL syntax, functions, operators, data types
patterns.md - Wrangler CLI, HTTP API, Pipelines, PyIceberg
gotchas.md - Limitations, troubleshooting, performance tips

Requirements and compatibility

Works with: Claude Code, Claude apps, OpenAI Codex, GitHub Copilot, Cursor, Gemini CLI, Kiro, OpenCode, Goose, Amp, Roo Code, JetBrains Junie, Factory Droid, Devin (ex-Windsurf), Mistral Vibe, OpenHands, Letta

“Works with” means the tool reads the open Agent Skills format; a skill written for one tool may use features others lack.

Needs: Needs Node.js

Security

What our scanner noticed· Medium risk

Possible data-exfiltration endpoints
Instructions that use the network
Downloads piped into a shell

A static scan is not a guarantee. Skills are third-party content: review a skill before you let an agent use it.

Attribution and licence

Created by

OpenAI

Publisher

JetBrains (Official)

Distributed by

JetBrains

Source

JetBrains/skills · cloudflare-deploy · commit 3f53782

Licence

Apache License 2.0 (redistribution allowed)

ATTRIBUTION.md (written by AutoGineer)

Synced

2026-11-09

AutoGineer is not affiliated with or endorsed by OpenAI or JetBrains.

Download ZIP

The ZIP holds the skill’s files, its licence files and an ATTRIBUTION.md. Download cloudflare-deploy.zip

From the author

AutoGineer summary

What it does

When to use it

Advantages

Usage examples

Install

Documentation by OpenAI

Cloudflare Deploy

Prerequisites

Authentication (Required Before Deploy)

Quick Decision Trees

"I need to run code"

"I need to store data"

"I need AI/ML"

"I need networking/connectivity"

"I need security"

"I need media/content"

"I need infrastructure-as-code"

Product Index

Compute & Runtime

Storage & Data

AI & Machine Learning

Networking & Connectivity

Security

Media & Content

Real-Time Communication

Developer Tools

Infrastructure as Code

Other Services

Troubleshooting

Escalated Network Access

Files

references/r2-sql/README.md

Cloudflare R2 SQL Skill Reference

Reading Order

What is R2 SQL?

What is Apache Iceberg?

When to Use

Decision Tree: Need to Query R2 Data?

Architecture Overview

Quick Start

Important Limitations

In This Reference

See Also

Requirements and compatibility

Security

Attribution and licence

Related skills

Modal

Cloud Infrastructure Network Engineer

Deployment Validation Cloud Architect

Airflow Dag Patterns

Cost Optimization

Hybrid Cloud Networking

Download ZIP