TanStack DB

TanStack DB

TanStack DB is a reactive client store for APIs that provides normalized collections, sub-millisecond live queries, and instant optimistic writes. It solves endpoint sprawl and network waterfalls through type-safe data management with automatic updates when underlying data changes.

Core Functionality

TanStack DB enables building reactive data layers through:

• Normalized Collections: Centralized data management with schema validation and type safety
• Live Queries: SQL-like queries that automatically update when data changes
• Optimistic Mutations: Instant UI updates with automatic rollback on errors
• Storage Integrations: Built-in support for LocalStorage, ElectricSQL, and custom backends

When to Use

Use this skill when working with TanStack DB for building reactive data layers in applications. It provides comprehensive guidance on collections, live queries, mutations, schema validation, error handling, and various integrations including LocalStorage and ElectricSQL.

Module Overview

Core Concepts Module

• Functionality: TanStack DB provides a reactive client store for APIs with normalized collections, live queries, and optimistic mutations
• Key APIs: createCollection, useLiveQuery, useLiveSuspenseQuery, queryCollectionOptions, electricCollectionOptions, localStorageCollectionOptions
• Detailed Documentation: references/TanStack DB Overview.md

Live Queries Module

• Functionality: Build type-safe, SQL-like queries with automatic updates when underlying data changes
• Key APIs: liveQueryCollectionOptions, from, where, select, join, groupBy, findOne, orderBy, limit
• Detailed Documentation: references/TanStack DB Live Queries.md

Mutations Module

• Functionality: Implement optimistic updates with automatic state management and error recovery
• Key APIs: collection.insert, collection.update, collection.delete, createOptimisticAction, createTransaction
• Detailed Documentation: references/TanStack DB Mutations.md

Schema Validation Module

• Functionality: Validate data and implement type-safe transformations using TInput/TOutput type system
• Key APIs: Schema validation with Zod, z.transform(), z.default(), SchemaValidationError
• Detailed Documentation: references/Schema Validation and Type Transformations.md

Error Handling Module

• Functionality: Handle errors through named error classes, collection status tracking, and transaction recovery patterns