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

ai-persistence/build-prisma-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-prisma-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-prisma-adapter/SKILL.md
Versions recorded
7
Latest version
git:20261027.669fd31, committed Oct 27, 2026
First version recorded
Jul 27, 2026
Size
21,455 bytes
Repository stars
3,337
License
MIT

Use when an app already runs Prisma and needs TanStack AI chat persistence — writes a chat-persistence.ts into the app against its existing PrismaClient and schema.prisma. Covers the four models, BigInt timestamps, JSON-as-string columns, upsert-with-empty-update idempotency, and model renaming.

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

# Prisma Chat Persistence

The deliverable is **one file in the app** — `src/lib/chat-persistence.ts` —
exporting a `ChatPersistence` built from the app's existing `PrismaClient`. Plus
four models added to the app's existing `schema.prisma` and a migration created
with the app's own `prisma migrate`.

Do not create a package, a second client, a datasource block, a generator, or a
hand-written SQL migration. The app has those.

**Always write all four models 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.

Read the **Store Reference**
(`docs/persistence/store-reference.md`) for the store contracts and
invariants, and **ai-persistence/stores** for the shape rules. Every
store below mirrors the reference in-memory backend in
`@tanstack/ai-persistence` (`memory.ts`); the shared conformance testkit is the
proof.

## 1. Read the app before writing anything
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add tanstack/ai/ai-persistence/build-prisma-adapter@sha256:afdd7d41d98cd5fa

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_l7v6cr6pk5djolpl.svg)](https://markdownregistry.com/a/art_l7v6cr6pk5djolpl)

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

Versions

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

versioncommittedcommitsizeaudit
git:20261027.669fd31 latest2026-10-27 669fd31 21,455 BA view · diff
git:20261027.2f868412026-10-27 2f86841 21,421 BA view · diff
git:20260924.9ab4f762026-09-24 9ab4f76 21,012 BA view · diff
git:20260909.53e2ec02026-09-09 53e2ec0 19,795 BA view · diff
git:20260804.d9d1e1f2026-08-04 d9d1e1f 19,802 BA view · diff
git:20260731.996a9802026-07-31 996a980 16,380 BA view · diff
git:20260727.4ab149f2026-07-27 4ab149f 16,258 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 (21455 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_l7v6cr6pk5djolpl
GET https://markdownregistry.com/api/v1/resolve?ref=tanstack/ai/ai-persistence/build-prisma-adapter
GET https://markdownregistry.com/api/v1/blob/afdd7d41d98cd5fa5f2d64297dfd048be963439330a023c90b0e0a40959ec06b

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.