TanStack
DB
v0
v0
Libraries
Framework
Start
RC
Docs
Router
Docs
Data & State Management
Query
Docs
DB
beta
Docs
Store
alpha
Docs
AI
beta
Docs
UI & UX
Table
Docs
Form
new
Docs
Hotkeys
alpha
Docs
Performance
Virtual
Docs
Pacer
beta
Docs
Tooling
Devtools
alpha
Docs
Config
Docs
CLI
alpha
Docs
Intent
alpha
Docs
Learn
Resources
Blog
Release notes, architecture notes, and essays.
YouTube
The official TanStack channel.
Community
Channels
Discord
Community support and real-time discussion.
GitHub
Source, issues, discussions, and releases.
People & Work
Maintainers
Meet the people maintaining the stack.
Contributors
Core, library, and community contributors.
Showcase
Products and teams building with TanStack.
Tools
Tools
Builder
Alpha
Generate TanStack app starters.
Stats
NPM and ecosystem usage data.
Merch
Recent Products
All Merch
Browse all TanStack apparel, accessories, and stickers.
Support
Support
Support Overview
Find the right support path.
Partners
Companies supporting TanStack.
OSS Sponsors
Sponsors keeping TanStack open source.
Enterprise Support
Private consulting and expert support.
Contact
Get in touch with the TanStack team.
About
Ethos
How we think about open source and products.
Tenets
The values that shape TanStack libraries.
Brand Guide
Logos, colors, and brand usage.
Search
AI
Ask AI
Log In
Log In
Libraries
All Libraries
Browse the full set of public packages.
Framework
Start
RC
Docs
Router
Docs
Data & State Management
Query
Docs
DB
beta
Docs
Store
alpha
Docs
AI
beta
Docs
UI & UX
Table
Docs
Form
new
Docs
Hotkeys
alpha
Docs
Performance
Virtual
Docs
Pacer
beta
Docs
Tooling
Devtools
alpha
Docs
Config
Docs
CLI
alpha
Docs
Intent
alpha
Docs
Learn
Resources
Blog
Release notes, architecture notes, and essays.
YouTube
The official TanStack channel.
Professional Workshops
Community
Channels
Discord
Community support and real-time discussion.
GitHub
Source, issues, discussions, and releases.
People & Work
Maintainers
Meet the people maintaining the stack.
Contributors
Core, library, and community contributors.
Showcase
Products and teams building with TanStack.
Tools
Tools
Builder
Alpha
Generate TanStack app starters.
Stats
NPM and ecosystem usage data.
Merch
Recent Products
All Merch
Browse all TanStack apparel, accessories, and stickers.
Support
Support
Support Overview
Find the right support path.
Partners
Companies supporting TanStack.
OSS Sponsors
Sponsors keeping TanStack open source.
Enterprise Support
Private consulting and expert support.
Contact
Get in touch with the TanStack team.
About
Ethos
How we think about open source and products.
Tenets
The values that shape TanStack libraries.
Brand Guide
Logos, colors, and brand usage.
Partnership Inquiry
Docs
React
Latest
Search...
K
API Reference
Core API Reference
Collection
createCollection
liveQueryCollectionOptions
createLiveQueryCollection
createOptimisticAction
createTransaction
Electric DB Collection
electricCollectionOptions
Query DB Collection
queryCollectionOptions
RxDB DB Collection
rxdbCollectionOptions
PowerSync Collection
powerSyncCollectionOptions
React Hooks
useLiveQuery
Menu
Menu
Home
Get Started
Guides
API
Community
React
Latest
API Reference
Core API Reference
Collection
createCollection
liveQueryCollectionOptions
createLiveQueryCollection
createOptimisticAction
createTransaction
Electric DB Collection
electricCollectionOptions
Query DB Collection
queryCollectionOptions
RxDB DB Collection
rxdbCollectionOptions
PowerSync Collection
powerSyncCollectionOptions
React Hooks
useLiveQuery
AI/LLM: This documentation page is available in plain markdown format at/db/latest/docs/reference/index.md
API Reference
On this page
@tanstack/db
Copy page
@tanstack/db
#
Namespaces
#
IR
Classes
#
AggregateFunctionNotInSelectError
AggregateNotSupportedError
BaseIndex
BaseQueryBuilder
BasicIndex
BTreeIndex
CannotCombineEmptyExpressionListError
CollectionConfigurationError
CollectionImpl
CollectionInErrorStateError
CollectionInputNotFoundError
CollectionIsInErrorStateError
CollectionOperationError
CollectionRequiresConfigError
CollectionRequiresSyncConfigError
CollectionStateError
DeduplicatedLoadSubset
DeleteKeyNotFoundError
DistinctRequiresSelectError
DuplicateAliasInSubqueryError
DuplicateDbInstanceError
DuplicateKeyError
DuplicateKeySyncError
EmptyReferencePathError
FnSelectWithGroupByError
GroupByError
HavingRequiresGroupByError
InvalidCollectionStatusTransitionError
InvalidJoinCondition
InvalidJoinConditionLeftSourceError
InvalidJoinConditionRightSourceError
InvalidJoinConditionSameSourceError
InvalidJoinConditionSourceMismatchError
InvalidKeyError
InvalidSchemaError
InvalidSourceError
InvalidSourceTypeError
InvalidStorageDataFormatError
InvalidStorageObjectFormatError
InvalidWhereExpressionError
JoinCollectionNotFoundError
JoinConditionMustBeEqualityError
JoinError
KeyUpdateNotAllowedError
LimitOffsetRequireOrderByError
LocalStorageCollectionError
MissingAliasInputsError
MissingDeleteHandlerError
MissingHandlerError
MissingInsertHandlerError
MissingMutationFunctionError
MissingUpdateArgumentError
MissingUpdateHandlerError
NegativeActiveSubscribersError
NoKeysPassedToDeleteError
NoKeysPassedToUpdateError
NonAggregateExpressionNotInGroupByError
NonRetriableError
NoPendingSyncTransactionCommitError
NoPendingSyncTransactionWriteError
OnlyOneSourceAllowedError
OnMutateMustBeSynchronousError
QueryBuilderError
QueryCompilationError
QueryMustHaveFromClauseError
QueryOptimizerError
ReverseIndex
SchemaMustBeSynchronousError
SchemaValidationError
SerializationError
SetWindowRequiresOrderByError
SortedMap
StorageError
StorageKeyRequiredError
SubQueryMustHaveFromClauseError
SubscriptionNotFoundError
SyncCleanupError
SyncTransactionAlreadyCommittedError
SyncTransactionAlreadyCommittedWriteError
TanStackDBError
TransactionAlreadyCompletedRollbackError
TransactionError
TransactionNotPendingCommitError
TransactionNotPendingMutateError
UndefinedKeyError
UnknownExpressionTypeError
UnknownFunctionError
UnknownHavingExpressionTypeError
UnsafeAliasPathError
UnsupportedAggregateFunctionError
UnsupportedFromTypeError
UnsupportedJoinSourceTypeError
UnsupportedJoinTypeError
UnsupportedRootScalarSelectError
UpdateKeyNotFoundError
WhereClauseConversionError
Interfaces
#
BaseCollectionConfig
BaseStrategy
BasicIndexOptions
BTreeRangeQueryOptions
ChangeMessage
Collection
CollectionConfig
CollectionIndexMetadata
CollectionLike
Context
CreateOptimisticActionsOptions
CurrentStateAsChangesOptions
DebounceStrategy
DebounceStrategyOptions
Effect
EffectConfig
EffectContext
IndexDevModeConfig
IndexInterface
IndexOptions
IndexStats
IndexSuggestion
InsertConfig
LiveQueryCollectionConfig
LiveQueryStatusFlags
LocalOnlyCollectionConfig
LocalOnlyCollectionUtils
LocalStorageCollectionConfig
LocalStorageCollectionUtils
OperationConfig
PacedMutationsConfig
ParsedOrderBy
Parser
ParseWhereOptions
PendingMutation
QueryOnceConfig
QueueStrategy
QueueStrategyOptions
RangeQueryOptions
SimpleComparison
SubscribeChangesOptions
SubscribeChangesSnapshotOptions
Subscription
SubscriptionStatusChangeEvent
SubscriptionStatusEvent
SubscriptionUnsubscribedEvent
SyncConfig
SyncMetadataApi
ThrottleStrategy
ThrottleStrategyOptions
Transaction
TransactionConfig
VirtualRowProps
Type Aliases
#
ApplyJoinOptionalityToMergedSchema
ChangeListener
ChangeMessageOrDeleteKeyMessage
ChangesPayload
CleanupFn
ClearStorageFn
CollectionConfigSingleRowOption
CollectionStatus
ContextFromSource
ContextFromUnionBranches
ContextFromUnionSource
ContextSchema
CursorExpressions
DeleteKeyMessage
DeleteMutationFn
DeleteMutationFnParams
DeltaEvent
DeltaType
EffectQueryInput
ExtractContext
FieldPath
Fn
FunctionalHavingRow
GetResult
GetStorageSizeFn
GroupByCallback
IndexConstructor
IndexOperation
IndexOperation
InferCollectionType
InferResultType
InferSchemaInput
InferSchemaOutput
InitialQueryBuilder
InputRow
InsertMutationFn
InsertMutationFnParams
JoinOnCallback
KeyedNamespacedRow
KeyedStream
LiveQueryCollectionUtils
LoadSubsetFn
LoadSubsetOptions
MakeOptional
MaybeSingleResult
MergeContextForJoinCallback
MergeContextWithJoinType
MutationFn
MutationFnParams
NamespacedAndKeyedStream
NamespacedRow
NonEmptyArray
NonSingleResult
OperationType
OperatorName
OptimisticChangeMessage
OrderByCallback
Prettify
QueryBuilder
QueryResult
Ref
RefsForContext
ResolveTransactionChanges
ResultStream
ResultTypeFromSelect
Row
SchemaFromSource
SelectObject
SingleResult
SingleSource
Source
SourceClauseContext
StandardSchema
StandardSchemaAlias
StorageApi
StorageEventApi
Strategy
StrategyOptions
StringCollationConfig
SubscriptionEvents
SubscriptionStatus
SyncConfigRes
SyncMode
TransactionState
TransactionWithMutations
UnloadSubsetFn
UpdateMutationFn
UpdateMutationFnParams
UtilsRecord
VirtualOrigin
WhereCallback
WithoutVirtualProps
WithResult
WithVirtualProps
WritableDeep
Variables
#
operators
Query
Functions
#
add
and
avg
caseWhen
clearQueryPatterns
coalesce
compileExpression
compileQuery
compileSingleRowExpression
concat
configureIndexDevMode
count
createArrayChangeProxy
createChangeProxy
createCollection
createEffect
createLiveQueryCollection
createOptimisticAction
createPacedMutations
createTransaction
debounceStrategy
deepEquals
divide
eq
extractFieldPath
extractSimpleComparisons
extractValue
findIndexForField
getActiveTransaction
getIndexDevModeConfig
getLiveQueryStatusFlags
getQueryPatterns
gt
gte
hasVirtualProps
ilike
inArray
isCollection
isDevModeEnabled
isLimitSubset
isNull
isOffsetLimitSubset
isOrderBySubset
isPredicateSubset
isSingleResultCollection
isUndefined
isWhereSubset
length
like
liveQueryCollectionOptions
localOnlyCollectionOptions
localStorageCollectionOptions
lower
lt
lte
materialize
max
min
minusWherePredicates
multiply
not
optimizeExpressionWithIndexes
or
parseLoadSubsetOptions
parseOrderByExpression
parseWhereExpression
queryOnce
queueStrategy
safeRandomUUID
subtract
sum
throttleStrategy
toArray
toBooleanPredicate
trackQuery
unionWherePredicates
upper
walkExpression
withArrayChangeTracking
withChangeTracking
Edit on GitHub
Next
Collection
On this page
@tanstack/db
Namespaces
Classes
Interfaces
Type Aliases
Variables
Functions
Blog
@Tan_Stack on X.com
@TannerLinsley on X.com
GitHub
YouTube
Nozzle.io - Keyword Rank Tracker
Ethos
Tenets
Privacy Policy
Terms of Service
© 2026 TanStack LLC
Partners
Become a Partner
Gold
Silver
Bronze