ai-persistence/build-custom-adapter SKILL.md skillA

ai-persistence/build-custom-adapter from tanstack/ai is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add tanstack/ai/ai-persistence/build-custom-adapter@git:20261027.669fd31

Pins git:20261027.669fd31 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
tanstack/ai
Path
packages/ai-persistence/skills/ai-persistence/build-custom-adapter/SKILL.md
Versions recorded
8
Latest version
git:20261027.669fd31, committed Oct 27, 2026
First version recorded
Jul 27, 2026
Size
29,424 bytes
Repository stars
3,337
License
MIT

Use when an app needs TanStack AI chat persistence on a database with no dedicated recipe — raw Postgres (pg/postgres.js), Kysely, node:sqlite, MongoDB, Supabase, Redis. Writes a chat-persistence.ts against the app's existing client, covering the four stores, the idempotency invariants, and the conformance gate. Route to the Drizzle, Prisma, or Cloudflare skills instead when one of those matches.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Custom Chat Persistence

The deliverable is **one file in the app** — `src/lib/chat-persistence.ts` —
exporting a `ChatPersistence` built from the database client the app already
has. Plus whatever DDL that database needs, added through the app's existing
migration flow.

Do not create a package, a second client, or a migration runner.

**Always write all four tables (or collections) and all four stores: thread, run, interrupt,
metadata.** The docs call `interrupts` and `metadata` optional for a
hand-rolled adapter; this recipe is not that case. `withPersistence` needs
all four to type-check as `ChatPersistence`, and the conformance suite fails
without them. Do not stop at a thread table and a run table.

**Route first.** If the app already runs one of these, stop and use that skill —
it has the driver-specific code:

| App runs                  | Use                                     |
| ------------------------- | --------------------------------------- |
| Drizzle ORM (any dialect) | ai-persistence/build-drizzle-adapter    |
| Prisma                    | ai-persistence/build-prisma-adapter     |
| Cloudflare Workers + D1   | ai-persistence/build-cloudflare-adapter |
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add tanstack/ai/ai-persistence/build-custom-adapter@sha256:9156ca712ab077c7

The line at the top of this page pins the label git:20261027.669fd31, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_izatd4xb437olgi4.svg)](https://markdownregistry.com/a/art_izatd4xb437olgi4)

4 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 8 versions of this file, between Jul 27, 2026 and Oct 27, 2026, about one every 13 days.

versioncommittedcommitsizeaudit
git:20261027.669fd31 latest2026-10-27 669fd31 29,424 BA view · diff
git:20261027.2f868412026-10-27 2f86841 19,390 BA view · diff
git:20261002.0d5b2ea2026-10-02 0d5b2ea 19,017 BA view · diff
git:20260924.9ab4f762026-09-24 9ab4f76 17,858 BA view · diff
git:20260909.53e2ec02026-09-09 53e2ec0 16,457 BA view · diff
git:20260804.d9d1e1f2026-08-04 d9d1e1f 16,471 BA view · diff
git:20260731.996a9802026-07-31 996a980 12,627 BA view · diff
git:20260727.4ab149f2026-07-27 4ab149f 12,516 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (29424 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

tanstack/ai · 3,337 stars · license MIT · pushed 2026-11-06 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_izatd4xb437olgi4
GET https://markdownregistry.com/api/v1/resolve?ref=tanstack/ai/ai-persistence/build-custom-adapter
GET https://markdownregistry.com/api/v1/blob/9156ca712ab077c7c3219a4236ac664c129aebcbf2f3deb39c6543cafb113d82

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from tanstack/ai

add-example-tutorial SKILL.md skill
tanstack/ai · .agents/skills/add-example-tutorial/SKILL.md · Use when adding a public teaching example or a docs tutorial. Don't use for an internal Nx playground (that is…
git:20261022.f1b3f65 · audit A · 3,337 stars
bugfix-pr SKILL.md skill
tanstack/ai · .agents/skills/bugfix-pr/SKILL.md · Treats bug-fix pull requests as invasive and untrusted. The agent must security-scan the PR first, must not run any…
git:20260831.cdefc64 · audit A · 3,337 stars
docs SKILL.md skill
tanstack/ai · .agents/skills/docs/SKILL.md · Use when writing, editing, or organizing documentation, when planning what docs a feature needs, and whenever planning…
git:20261022.f1b3f65 · audit A · 3,337 stars
gap-analysis SKILL.md skill
tanstack/ai · .agents/skills/gap-analysis/SKILL.md · Audit TanStack AI provider adapters for feature parity gaps and outdated model lists. Triggered as /gap-analysis…
git:20260824.c1c0dc0 · audit A · 3,337 stars
i-have-adhd SKILL.md skill
tanstack/ai · .agents/skills/i-have-adhd/SKILL.md · Use when the user invokes /i-have-adhd, says they have ADHD, or asks for ADHD-friendly output. Also used as a required…
git:20260824.c1c0dc0 · audit A · 3,337 stars
new-react-playground SKILL.md skill
tanstack/ai · .agents/skills/new-react-playground/SKILL.md · Use when an agent in this TanStack AI monorepo needs a playground app to try a new feature. Trigger: new feature to try…
git:20260917.62ba217 · audit A · 3,337 stars
ponytail SKILL.md skill
tanstack/ai · .agents/skills/ponytail/SKILL.md · Forces the laziest solution that actually works, simplest, shortest, most minimal. Channels a senior dev who has seen…
git:20260820.9ac4a38 · audit A · 3,337 stars
pr-description SKILL.md skill
tanstack/ai · .agents/skills/pr-description/SKILL.md · Use when writing a pull request title or body, when about to run gh pr create, when about to git push on a branch that…
git:20260824.81c40c1 · audit A · 3,337 stars
pr-sweep SKILL.md skill
tanstack/ai · .agents/skills/pr-sweep/SKILL.md · Sweep open (or listed) PRs with up to 100 parallel agents: security-scan outside contributors, rebase onto main when…
git:20260831.cdefc64 · audit A · 3,337 stars
simple-english SKILL.md skill
tanstack/ai · .agents/skills/simple-english/SKILL.md · Write or rewrite technical text with the rules of ASD-STE100 Simplified Technical English so it is clear, unambiguous…
v1.0.0 · audit A · 3,337 stars
triage-github SKILL.md skill
tanstack/ai · .agents/skills/triage-github/SKILL.md · Triage all open GitHub issues, PRs, and discussions in the current repository by fanning out up to 100 parallel…
git:20260824.c1c0dc0 · audit A · 3,337 stars
add-example-tutorial SKILL.md skill
tanstack/ai · .claude/skills/add-example-tutorial/SKILL.md · Use when adding a public teaching example or a docs tutorial. Don't use for an internal Nx playground (that is…
git:20261022.f1b3f65 · audit A · 3,337 stars

Every file in tanstack/ai

Browse by kind, by grade A, or by owner.