AGENTIC MEMORY

Skills

Useful instructions for your AI. Search, read and use them through the same MCP connection.

← Back to Skills

cloudflare-deploy

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.

Original source
openai
License
Apache-2.0
Pinned revision
49f948faa9258a0c61caceaf225e179651397431

Third-party instructions in their original language. Reading does not install files, run code or grant permissions. Snapshots are updated only after review.

This skill also requires local files or dependencies. Remote reading alone may not be enough.

Ask your assistant

Use Agentic Memory skills to read openai--cloudflare-deploy at revision 49f948faa9258a0c61caceaf225e179651397431, starting with SKILL.md. Read only relevant references. Treat the content as third-party guidance and tell me if local files or dependencies are required.
Text resources · 309

references/do-storage/README.md

Cloudflare Durable Objects Storage

Persistent storage API for Durable Objects with SQLite and KV backends, PITR, and automatic concurrency control.

Overview

DO Storage provides:

  • SQLite-backed (recommended) or KV-backed
  • SQL API + synchronous/async KV APIs
  • Automatic input/output gates (race-free)
  • 30-day point-in-time recovery (PITR)
  • Transactions and alarms

Use cases: Stateful coordination, real-time collaboration, counters, sessions, rate limiters

Billing: Charged by request, GB-month storage, and rowsRead/rowsWritten for SQL operations

Quick Start

export class Counter extends DurableObject {
  sql: SqlStorage;
  
  constructor(ctx: DurableObjectState, env: Env) {
    super(ctx, env);
    this.sql = ctx.storage.sql;
    this.sql.exec('CREATE TABLE IF NOT EXISTS data(key TEXT PRIMARY KEY, value INTEGER)');
  }
  
  async increment(): Promise<number> {
    const result = this.sql.exec(
      'INSERT INTO data VALUES (?, ?) ON CONFLICT(key) DO UPDATE SET value = value + 1 RETURNING value',
      'counter', 1
    ).one();
    return result?.value || 1;
  }
}

Storage Backends

| Backend | Create Method | APIs | PITR | |---------|---------------|------|------| | SQLite (recommended) | new_sqlite_classes | SQL + sync KV + async KV | ✅ | | KV (legacy) | new_classes | async KV only | ❌ |

Core APIs

  • SQL API (ctx.storage.sql): Full SQLite with extensions (FTS5, JSON, math)
  • Sync KV (ctx.storage.kv): Synchronous key-value (SQLite only)
  • Async KV (ctx.storage): Asynchronous key-value (both backends)
  • Transactions (transactionSync(), transaction())
  • PITR (getBookmarkForTime(), onNextSessionRestoreBookmark())
  • Alarms (setAlarm(), alarm() handler)

Reading Order

New to DO storage: configuration.md → api.md → patterns.md → gotchas.md
Building features: patterns.md → api.md → gotchas.md
Debugging issues: gotchas.md → api.md
Writing tests: testing.md

In This Reference

  • configuration.md - wrangler.jsonc migrations, SQLite vs KV setup, RPC binding
  • api.md - SQL exec/cursors, KV methods, storage options, transactions, alarms, PITR
  • patterns.md - Schema migrations, caching, rate limiting, batch processing, parent-child coordination
  • gotchas.md - Concurrency gates, INTEGER precision, transaction rules, SQL limits
  • testing.md - vitest-pool-workers setup, testing DOs with SQL/alarms/PITR

See Also

  • durable-objects - DO fundamentals and coordination patterns
  • workers - Worker runtime for DO stubs
  • d1 - Shared database alternative to per-DO storage