Libraries
Framework
Start
Router
Data & State
Query
DB
Store
AI
UI & UX
Table
Charts
Form
Hotkeys
Markdown
Highlight
Performance
Virtual
Pacer
Tooling
Devtools
Config
CLI
Intent
Browse all libraries
Blog
Blog & Release Notes
About
YouTube
The official TanStack channel.
Workshops
Live sessions from the maintainers.
Release Notes
The latest releases and changelog.
Community
Channels
Discord
Real-time community support.
GitHub
Source, issues, discussions, and releases.
People & Work
Maintainers
Meet the people maintaining the stack.
Contributors
Core, library, and community contributors.
Showcase
Teams building with TanStack.
Tools
Tools
Builder
Alpha
Generate TanStack app starters.
Stats
NPM and ecosystem usage data.
Merch
View all
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 approach open source.
Tenets
The values that shape TanStack libraries.
Design System
Logos, tokens, and UI components.
Search
AI
Ask AI
Log In
Log In
Libraries
Blog
Blog & Release Notes
About
YouTube
The official TanStack channel.
Workshops
Live sessions from the maintainers.
Release Notes
The latest releases and changelog.
Community
Channels
Discord
Real-time community support.
GitHub
Source, issues, discussions, and releases.
People & Work
Maintainers
Meet the people maintaining the stack.
Contributors
Core, library, and community contributors.
Showcase
Teams building with TanStack.
Tools
Tools
Builder
Alpha
Generate TanStack app starters.
Stats
NPM and ecosystem usage data.
Merch
View all
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 approach open source.
Tenets
The values that shape TanStack libraries.
Design System
Logos, tokens, and UI components.
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
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
Ethos
Tenets
Privacy Policy
Terms of Service
© 2026 TanStack LLC
Partners
Become a Partner
Gold
Silver
Bronze
Latest Posts