How does this skill handle optimistic updates?

The skill provides patterns for optimistic mutations that update the local UI instantly while handling background persistence and server confirmation.

Which sync engines does this skill support?

It provides guidance for several major sync engines, including ElectricSQL (Postgres sync), RxDB (offline-first), and PowerSync.

TanStack DB is a reactive client-side database designed for building local-first applications with sub-millisecond queries and integrated background synchronization.

Is TanStack DB ready for production?

TanStack DB is currently in BETA. This skill helps navigate its current API and best practices while accounting for its evolving nature.

Can I use TanStack DB with existing REST APIs?

Yes, the skill includes specific implementations for using @tanstack/query-db-collection to bridge standard REST APIs with reactive client-side collections.

TanStack DB Local-First Development

Name: TanStack DB Local-First Development
Author: olegakbarov

byolegakbarov

•

Database Management

Builds reactive, local-first applications with sub-millisecond live queries and seamless background data synchronization.

The TanStack DB skill provides expert guidance for implementing reactive client-side databases using the TanStack DB ecosystem. It helps developers architect local-first applications that support sub-millisecond queries, optimistic UI updates, and robust background synchronization with engines like ElectricSQL, RxDB, and PowerSync. By leveraging this skill, developers can efficiently manage typed collections, implement complex filtering and joins, and handle offline-first data persistence without the overhead of manual state management, specifically during its beta phase.

Key Features

01Multi-engine sync support (ElectricSQL, RxDB, PowerSync)

02Reactive live queries with incremental updates

03Advanced query capabilities including joins, aggregations, and pagination

04Optimistic mutations for instant UI feedback

05Type-safe collection definitions and schema management

062 GitHub stars

Use Cases

01Optimizing data-heavy dashboards with sub-millisecond live query performance

02Implementing complex client-side state management using a database-first approach

03Building offline-capable web applications with real-time backend synchronization

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add olegakbarov/ispo-code tanstack-db

For use in Claude.ai and ChatGPT

Download Skill