d1-patterns

What problem does it solve?

D1 stores encrypted records, and applications often need a robust pattern to model secure storage, indexing, migration, and access control across agents. This Skill provides a reusable schema and operational practices for encrypted record storage on D1, including handling of ciphertext, per-record keys, and shared access metadata.

Core Features & Use Cases

• Core schema: defines a core encrypted records table with per-record keys, nonces, and optional encrypted keys for recipients.
• Indexing & access: supports queries on did, collection, and rkey for fast lookup while keeping content encrypted.
• Operational patterns: TID generation, CRUD and batch operations, and agent registry for multi-agent coordination.
• Use Case: model agent memories or logs where metadata is searchable but content remains encrypted, and provide secure key sharing for collaborators.

Quick Start

Create and manage encrypted records in your D1 database to enable secure storage and querying.