OpenParable
Skip to content
← Back to skills

DB Core

Development
db-core

DB Core is an Agent Skill for development published in the TanStack/db repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

TanStack DB core concepts: createCollection with queryCollectionOptions, electricCollectionOptions, powerSyncCollectionOptions, rxdbCollectionOptions, trailbaseCollectionOptions, localOnlyCollectionOptions. Live queries via query builder (from, where, join, select, groupBy, orderBy, limit). Optimistic mutations with draft proxy (collection.insert, collection.update, collection.delete). createOptimisticAction, createTransaction, createPacedMutations. Entry point for all TanStack DB skills.

View on GitHub ↗
QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

  1. Open your project in Codex.
  2. Copy and paste the prompt below.
  3. Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/TanStack/db/blob/HEAD/packages/db/skills/db-core/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/db-core, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

TanStack DB — Core Concepts

TanStack DB is a reactive client-side data store. It loads data into typed collections from any backend (REST APIs, sync engines, local storage), provides sub-millisecond live queries via differential dataflow, and supports instant optimistic mutations with automatic rollback.

Framework packages (@tanstack/react-db, @tanstack/vue-db, @tanstack/svelte-db, @tanstack/solid-db) re-export everything from @tanstack/db plus framework-specific hooks. In framework projects, import from the framework package directly. @tanstack/angular-db is the exception -- import operators from @tanstack/db separately.

Sub-Skills

Need to...Read
Create a collection, pick an adapter, add schemadb-core/collection-setup/SKILL.md
Query data with where, join, groupBy, selectdb-core/live-queries/SKILL.md
Insert, update, delete with optimistic UIdb-core/mutations-optimistic/SKILL.md
Build a custom sync adapterdb-core/custom-adapter/SKILL.md
Persist collections to SQLite (offline cache)db-core/persistence/SKILL.md
Preload collections in route loadersmeta-framework/SKILL.md
Add offline transaction queueingoffline/SKILL.md (in @tanstack/offline-transactions)

For framework-specific hooks:

FrameworkRead
Reactreact-db/SKILL.md
Vuevue-db/SKILL.md
Sveltesvelte-db/SKILL.md
Solidsolid-db/SKILL.md
Angularangular-db/SKILL.md

Quick Decision Tree

  • Setting up for the first time? → db-core/collection-setup
  • Building queries on collection data? → db-core/live-queries
  • Writing data / handling optimistic state? → db-core/mutations-optimistic
  • Using React hooks? → react-db
  • Preloading in route loaders (Start, Next, Remix)? → meta-framework
  • Building an adapter for a new backend? → db-core/custom-adapter
  • Persisting collections to SQLite? → db-core/persistence
  • Need offline transaction persistence? → offline

Version

Targets @tanstack/db v0.6.0.