# PowerSync

> PowerSync keeps a client-side SQLite database in sync with your backend database. Changes appear across users and devices in real time, user interactions feel instant, and your app continues to work even when offline.

## Docs

- [PowerSync Docs](https://powersync-sync-streams-nav.mintlify.site/intro/powersync-overview.md): PowerSync keeps in-app SQLite synced with your backend so apps update across users and devices in real time, respond instantly, and continue working offline.
- [PowerSync Setup Guide](https://powersync-sync-streams-nav.mintlify.site/intro/setup-guide.md): Step-by-step guide to adding PowerSync to your app, from connecting your source database to integrating the client SDK.
- [PowerSync Philosophy](https://powersync-sync-streams-nav.mintlify.site/intro/powersync-philosophy.md): PowerSync's vision is that local-first architecture should be easier to implement than cloud-first and deliver a better end-user experience.
- [Architecture Overview](https://powersync-sync-streams-nav.mintlify.site/architecture/architecture-overview.md): Overview of how PowerSync works: a sync service, client SDKs, and a backend integration layer that keeps local SQLite in sync with your database.
- [PowerSync Service](https://powersync-sync-streams-nav.mintlify.site/architecture/powersync-service.md): Understand the PowerSync Service architecture and how it replicates data and delivers real-time sync.
- [Client Architecture](https://powersync-sync-streams-nav.mintlify.site/architecture/client-architecture.md): How the PowerSync Client SDK manages connections, local SQLite storage, and the upload queue.
- [PowerSync Protocol](https://powersync-sync-streams-nav.mintlify.site/architecture/powersync-protocol.md): Technical overview of the sync protocol between PowerSync clients and the Service.
- [Consistency](https://powersync-sync-streams-nav.mintlify.site/architecture/consistency.md): How PowerSync uses checkpoints and causal+ consistency to keep client data consistent with the backend.
- [Demo Apps & Example Projects](https://powersync-sync-streams-nav.mintlify.site/intro/examples.md): Demo apps and example projects showcasing PowerSync across all supported platforms and backends.
- [Self-Hosting](https://powersync-sync-streams-nav.mintlify.site/intro/self-hosting.md): Get started self-hosting the PowerSync Service with Docker, including local dev setup via the PowerSync CLI.
- [MongoDB Atlas Device Sync Migration Guide](https://powersync-sync-streams-nav.mintlify.site/migration-guides/atlas-device-sync.md): Migrate from MongoDB Atlas Device Sync to PowerSync with step-by-step instructions.
- [Electric Cloud Migration Guide](https://powersync-sync-streams-nav.mintlify.site/migration-guides/electric.md): Migrate from Electric Cloud to PowerSync Cloud with step-by-step instructions.
- [Source Database Setup](https://powersync-sync-streams-nav.mintlify.site/configuration/source-db/setup.md): Prepare your Postgres, MongoDB, MySQL, SQL Server or Convex database for PowerSync replication.
- [Source Database Connection](https://powersync-sync-streams-nav.mintlify.site/configuration/source-db/connection.md): Connect a PowerSync Cloud instance to your Postgres, MongoDB, MySQL, SQL Server or Convex source database.
- [Security & IP Filtering](https://powersync-sync-streams-nav.mintlify.site/configuration/source-db/security-and-ip-filtering.md): Restrict database access to PowerSync Cloud using static IP allowlisting by deployment region.
- [Private Endpoints](https://powersync-sync-streams-nav.mintlify.site/configuration/source-db/private-endpoints.md): Connect PowerSync Cloud to your database over AWS PrivateLink without public internet exposure.
- [Postgres Maintenance](https://powersync-sync-streams-nav.mintlify.site/configuration/source-db/postgres-maintenance.md): Manage Postgres replication slots and WAL lag for reliable PowerSync replication.
- [Advanced SQL Server Configuration](https://powersync-sync-streams-nav.mintlify.site/configuration/source-db/sql-server-additional-configuration.md): Configure advanced SQL Server adapter options for self-hosted PowerSync.
- [PowerSync Cloud Instances](https://powersync-sync-streams-nav.mintlify.site/configuration/powersync-service/cloud-instances.md): Create and configure PowerSync Cloud instances with a database connection.
- [Self-Hosted Instance Configuration](https://powersync-sync-streams-nav.mintlify.site/configuration/powersync-service/self-hosted-instances.md): How to configure a self-hosted PowerSync Service instance with a config file, and a reference of all available options.
- [App Backend Setup](https://powersync-sync-streams-nav.mintlify.site/configuration/app-backend/setup.md): Configure your app backend to process client-side mutations from the PowerSync upload queue.
- [Client-Side Integration With Your Backend](https://powersync-sync-streams-nav.mintlify.site/configuration/app-backend/client-side-integration.md): Connect your client app to a PowerSync-compatible backend using the connector interface and upload queue.
- [CloudCode for MongoDB Backends](https://powersync-sync-streams-nav.mintlify.site/configuration/app-backend/cloudcode.md): Use JourneyApps CloudCode as a managed backend for PowerSync with MongoDB.
- [Authentication Setup](https://powersync-sync-streams-nav.mintlify.site/configuration/auth/overview.md): Set up JWT-based client authentication for PowerSync using development tokens, supported auth providers like Auth0 and Firebase, or custom JWTs.
- [Development Tokens](https://powersync-sync-streams-nav.mintlify.site/configuration/auth/development-tokens.md): Generate temporary development tokens for testing PowerSync authentication without a full auth provider.
- [Custom Authentication](https://powersync-sync-streams-nav.mintlify.site/configuration/auth/custom.md): Implement custom JWT-based authentication for PowerSync using any auth provider.
- [Supabase Auth](https://powersync-sync-streams-nav.mintlify.site/configuration/auth/supabase-auth.md): Use Supabase Auth with PowerSync by verifying Supabase JWTs directly.
- [Stytch + Supabase](https://powersync-sync-streams-nav.mintlify.site/configuration/auth/supabase-auth/stytch.md): Set up Stytch authentication with Supabase for PowerSync.
- [Firebase Auth](https://powersync-sync-streams-nav.mintlify.site/configuration/auth/firebase-auth.md): Configure Firebase Authentication for PowerSync.
- [Auth0](https://powersync-sync-streams-nav.mintlify.site/configuration/auth/auth0.md): Configure Auth0 as your authentication provider for PowerSync.
- [Sync Streams](https://powersync-sync-streams-nav.mintlify.site/sync/streams/overview.md): Sync Streams define which data syncs to each client. Learn what a stream is and how PowerSync replicates and streams the data.
- [Sync Streams Quickstart](https://powersync-sync-streams-nav.mintlify.site/sync/streams/quickstart.md): Define your first Sync Streams and subscribe to them from your client app.
- [Using Parameters](https://powersync-sync-streams-nav.mintlify.site/sync/streams/parameters.md): Filter synced data dynamically using subscription, auth, and connection parameters in Sync Streams queries.
- [Writing Queries](https://powersync-sync-streams-nav.mintlify.site/sync/streams/queries.md): Learn Sync Streams query syntax for filtering, column selection, and type transformations.
- [Common Table Expressions (CTEs)](https://powersync-sync-streams-nav.mintlify.site/sync/streams/ctes.md): Reuse common query patterns across Sync Streams using Common Table Expressions (CTEs) to simplify configurations and reduce duplication.
- [Bucket Count and Limits](https://powersync-sync-streams-nav.mintlify.site/sync/streams/bucket-count.md): How your Sync Stream queries determine each user's bucket count, and the two per-user limits that cap it.
- [Client-Side Usage](https://powersync-sync-streams-nav.mintlify.site/sync/streams/client-usage.md): Subscribe to Sync Streams from your client app and manage subscriptions dynamically.
- [Types](https://powersync-sync-streams-nav.mintlify.site/sync/types.md): How Postgres, MongoDB, MySQL, SQL Server and Convex types map to PowerSync's SQLite-based sync column definitions.
- [Examples, Patterns & Demos](https://powersync-sync-streams-nav.mintlify.site/sync/streams/examples.md): Common Sync Streams patterns and real-world examples for different sync configurations.
- [Supported SQL](https://powersync-sync-streams-nav.mintlify.site/sync/supported-sql.md): Reference for SQL syntax, operators, built-in functions, and type casting supported in Sync Streams/Sync Rules queries.
- [Grammar Reference](https://powersync-sync-streams-nav.mintlify.site/sync/grammar/sync-streams/index.md): Railroad diagram reference for the SQL grammar supported in Sync Streams queries.
- [Advanced Topics](https://powersync-sync-streams-nav.mintlify.site/sync/advanced/overview.md): Advanced Sync Streams topics.
- [Reducing Bucket Count](https://powersync-sync-streams-nav.mintlify.site/sync/advanced/reducing-bucket-count.md): Diagnose a high bucket count, reduce the number of buckets a user syncs, and raise the per-user limits when needed.
- [Prioritized Sync](https://powersync-sync-streams-nav.mintlify.site/sync/advanced/prioritized-sync.md): Prioritize which tables sync first so users can start working immediately while remaining data continues loading in the background.
- [Client ID](https://powersync-sync-streams-nav.mintlify.site/sync/advanced/client-id.md): Understand PowerSync's requirement for a single text-type primary key column called id.
- [Case Sensitivity](https://powersync-sync-streams-nav.mintlify.site/sync/advanced/case-sensitivity.md): Handle case-sensitive table and column names in PowerSync Sync Streams/Rules, with best practices for lowercase identifiers and quoting strategies.
- [Compatibility](https://powersync-sync-streams-nav.mintlify.site/sync/advanced/compatibility.md): Configure compatibility editions and bucket storage format version in PowerSync's Sync Config.
- [Storage Version 4](https://powersync-sync-streams-nav.mintlify.site/sync/advanced/storage-version-4.md): Opt in to storage version 4 for faster sync, incremental reprocessing of Sync Streams changes, and S3 object storage.
- [Sync Data by Time with Sync Streams](https://powersync-sync-streams-nav.mintlify.site/sync/advanced/sync-data-by-time.md): Filter and sync data based on time ranges using Sync Streams/Sync Rules, with patterns for recent-only and sliding-window queries.
- [Schemas and Connections](https://powersync-sync-streams-nav.mintlify.site/sync/advanced/schemas-and-connections.md): Configure Postgres schema usage in Sync Streams/Rules queries, including wildcard schemas for schema-per-tenant setups, and connect to high-availability replicas.
- [Multiple Client Versions](https://powersync-sync-streams-nav.mintlify.site/sync/advanced/multiple-client-versions.md): Handle multiple client app versions that require different output schemas from Sync Streams.
- [Partitioned Tables (Postgres)](https://powersync-sync-streams-nav.mintlify.site/sync/advanced/partitioned-tables.md): Sync data from Postgres partitioned tables using wildcard table name matching.
- [Sharded Databases](https://powersync-sync-streams-nav.mintlify.site/sync/advanced/sharded-databases.md): Sync data from sharded Postgres databases with per-shard PowerSync connection configuration.
- [Migrate to Sync Streams](https://powersync-sync-streams-nav.mintlify.site/sync/rules/migrate-to-sync-streams.md): Migrate an existing project from legacy Sync Rules to Sync Streams.
- [Sync Rules (Legacy)](https://powersync-sync-streams-nav.mintlify.site/sync/rules/overview.md): Understand legacy Sync Rules for controlling which data syncs to each client.
- [Organize Data Into Buckets](https://powersync-sync-streams-nav.mintlify.site/sync/rules/organize-data-into-buckets.md): Design Sync Rules to organize data into global and user-filtered buckets.
- [Global Buckets](https://powersync-sync-streams-nav.mintlify.site/sync/rules/global-buckets.md): Set up global buckets in Sync Rules to sync shared reference data to all connected users without per-user filtering or parameter queries.
- [Parameter Queries](https://powersync-sync-streams-nav.mintlify.site/sync/rules/parameter-queries.md): Define bucket parameters in Sync Rules using Parameter Queries with JWT claims and client parameters.
- [Data Queries](https://powersync-sync-streams-nav.mintlify.site/sync/rules/data-queries.md): Write Data Queries in Sync Rules to select and filter data for buckets using bucket parameters.
- [Many-to-Many Relationships and Join Tables in Sync Rules](https://powersync-sync-streams-nav.mintlify.site/sync/rules/many-to-many-join-tables.md): Handle many-to-many relationships in Sync Rules using join table strategies.
- [Client Parameters](https://powersync-sync-streams-nav.mintlify.site/sync/rules/client-parameters.md): Pass dynamic parameters from the client SDK directly into Sync Rules queries to filter data per user, device, or application context.
- [Grammar Reference (Sync Rules)](https://powersync-sync-streams-nav.mintlify.site/sync/grammar/sync-rules/index.md): Railroad diagram reference for the SQL grammar supported in legacy Sync Rules queries.
- [Client SDKs Overview](https://powersync-sync-streams-nav.mintlify.site/client-sdks/overview.md): Choose a PowerSync SDK for web, mobile, desktop, headless, or embedded apps.
- [JavaScript Web SDK](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/javascript-web.md): Build JavaScript web apps that use client-side SQLite for real-time updates across users and devices, instant interactions and continued functionality when offline.
- [JavaScript Web SDK API Reference](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/javascript-web-api.md): Full API reference for the PowerSync JavaScript Web SDK.
- [React Native & Expo SDK](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/react-native-and-expo.md): Use PowerSync in React Native (& Expo) apps.
- [React Native Web Support](https://powersync-sync-streams-nav.mintlify.site/client-sdks/frameworks/react-native-web-support.md): Configure PowerSync for React Native Web projects.
- [React Native SDK API Reference](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/react-native-api.md): Full API reference for the PowerSync React Native SDK.
- [Capacitor SDK (beta)](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/capacitor.md): Use PowerSync in Capacitor apps.
- [Capacitor SDK API Reference](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/capacitor-api.md): Full API reference for the PowerSync Capacitor SDK.
- [Node.js Client SDK](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/node.md): Use PowerSync in Node.js apps.
- [Node.js SDK API Reference](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/node-api.md): Full API reference for the PowerSync Node.js SDK.
- [Tauri SDK (alpha)](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/tauri.md): Use PowerSync in Tauri apps.
- [React Hooks](https://powersync-sync-streams-nav.mintlify.site/client-sdks/frameworks/react.md): Use PowerSync React hooks including useQuery, useStatus, and useSuspenseQuery to build reactive components with live query results.
- [Next.js + PowerSync](https://powersync-sync-streams-nav.mintlify.site/client-sdks/frameworks/next-js.md): Learn how to build highly responsive Next.js applications with PowerSync.
- [Vue Composables](https://powersync-sync-streams-nav.mintlify.site/client-sdks/frameworks/vue.md): Use PowerSync Vue composables including useQuery and useStatus to build reactive components with live query results.
- [Nuxt Integration](https://powersync-sync-streams-nav.mintlify.site/client-sdks/frameworks/nuxt.md): Build Nuxt apps that use client-side SQLite for real-time updates across users and devices, instant interactions and continued functionality when offline.
- [TanStack Query & TanStack DB](https://powersync-sync-streams-nav.mintlify.site/client-sdks/frameworks/tanstack.md): Use PowerSync with TanStack Query for server state caching and TanStack DB for optimistic local-first mutations in JavaScript apps.
- [Expo Go Support](https://powersync-sync-streams-nav.mintlify.site/client-sdks/frameworks/expo-go-support.md): Run PowerSync in Expo Go without native modules using @powersync/adapter-sql-js.
- [JavaScript ORMs Overview](https://powersync-sync-streams-nav.mintlify.site/client-sdks/orms/js/overview.md): Overview of ORM and query builder integrations for PowerSync JavaScript SDKs, including Drizzle, Kysely, and TanStack DB.
- [Kysely](https://powersync-sync-streams-nav.mintlify.site/client-sdks/orms/js/kysely.md): Use the Kysely query builder with PowerSync's JavaScript and React Native SDKs.
- [Drizzle](https://powersync-sync-streams-nav.mintlify.site/client-sdks/orms/js/drizzle.md): Use the Drizzle ORM with PowerSync's JavaScript and React Native SDKs.
- [TanStack DB](https://powersync-sync-streams-nav.mintlify.site/client-sdks/orms/js/tanstack-db.md): Use PowerSync with TanStack DB for optimistic mutations and live queries in JavaScript apps.
- [Dart/Flutter SDK](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/flutter.md): Use PowerSync in Dart and Flutter apps.
- [Dart/Flutter Web Support (Beta)](https://powersync-sync-streams-nav.mintlify.site/client-sdks/frameworks/flutter-web-support.md): Set up the PowerSync Flutter SDK for web with Chrome and WASM support.
- [Dart/Flutter ORM Support](https://powersync-sync-streams-nav.mintlify.site/client-sdks/orms/flutter-orm-support.md): Use the Drift ORM with the PowerSync Flutter SDK via drift_sqlite_async.
- [Flutter SDK API Reference](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/flutter-api.md): Full API reference for the PowerSync Dart/Flutter SDK.
- [Kotlin SDK](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/kotlin.md): Use PowerSync in Kotlin Multiplatform apps.
- [Kotlin SQL Libraries](https://powersync-sync-streams-nav.mintlify.site/client-sdks/orms/kotlin/overview.md): Overview of SQL mapping library options for the PowerSync Kotlin SDK, including Room and SQLDelight.
- [SQLDelight (Beta)](https://powersync-sync-streams-nav.mintlify.site/client-sdks/orms/kotlin/sqldelight.md): Use SQLDelight with PowerSync's Kotlin SDK.
- [Room (Beta)](https://powersync-sync-streams-nav.mintlify.site/client-sdks/orms/kotlin/room.md): Use Android Room with PowerSync's Kotlin SDK.
- [Kotlin SDK API Reference](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/kotlin-api.md): Full API reference for the PowerSync Kotlin Multiplatform SDK.
- [Swift SDK](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/swift.md): Use PowerSync in Swift apps.
- [GRDB (Alpha)](https://powersync-sync-streams-nav.mintlify.site/client-sdks/orms/swift/grdb.md): Use the GRDB SQLite library with PowerSync's Swift SDK.
- [Swift SDK API Reference](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/swift-api.md): Full API reference for the PowerSync Swift SDK.
- [.NET SDK (beta)](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/dotnet.md): Use PowerSync in .NET apps (beta).
- [.NET SDK API Reference](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/dotnet-api.md): Full API reference for the PowerSync .NET SDK.
- [Rust SDK (alpha)](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reference/rust.md): Use PowerSync in Rust apps.
- [ORM Support Overview](https://powersync-sync-streams-nav.mintlify.site/client-sdks/orms/overview.md): Choose a type-safe ORM or query builder for PowerSync instead of writing raw SQL queries.
- [Reading Data](https://powersync-sync-streams-nav.mintlify.site/client-sdks/reading-data.md): Use SQL, watch queries, and supported ORMs to read data from local SQLite with the PowerSync SDK.
- [Live Queries / Watch Queries](https://powersync-sync-streams-nav.mintlify.site/client-sdks/watch-queries.md): Keep your UI current with basic, incremental, and differential watch queries over client-side SQLite.
- [Experimental: High Performance Diffs](https://powersync-sync-streams-nav.mintlify.site/client-sdks/high-performance-diffs.md): Get row-level change notifications using trigger-based table diffs in JavaScript SDKs.
- [Full-Text Search](https://powersync-sync-streams-nav.mintlify.site/client-sdks/full-text-search.md): Implement client-side full-text search using SQLite's FTS5 extension with PowerSync.
- [Infinite Scrolling](https://powersync-sync-streams-nav.mintlify.site/client-sdks/infinite-scrolling.md): Implement infinite scrolling with PowerSync using paginated SQL queries against the local SQLite database.
- [Writing Data](https://powersync-sync-streams-nav.mintlify.site/client-sdks/writing-data.md): Use SQL to update client-side SQLite and send queued changes to your application backend.
- [Cascading Delete](https://powersync-sync-streams-nav.mintlify.site/client-sdks/cascading-delete.md): Implement cascading deletes in client-side SQLite using triggers and upload queue handlers.
- [Usage Examples](https://powersync-sync-streams-nav.mintlify.site/client-sdks/usage-examples.md): Code examples and common patterns for the PowerSync Client SDKs.
- [Attachments / Files](https://powersync-sync-streams-nav.mintlify.site/client-sdks/advanced/attachments.md): Sync file attachments like images and PDFs without storing them in the database, using a local queue that uploads and downloads files in the background.
- [JSON, Arrays and Custom Types](https://powersync-sync-streams-nav.mintlify.site/client-sdks/advanced/custom-types-arrays-and-json.md): Sync JSON, JSONB, arrays, and other custom Postgres types through PowerSync by serializing them to text.
- [Querying JSON Data in SQLite](https://powersync-sync-streams-nav.mintlify.site/client-sdks/advanced/query-json-in-sqlite.md): How to query JSON data synced from your backend and stored as strings in SQLite using `json_extract` and JSON operators.
- [Sequential ID Mapping](https://powersync-sync-streams-nav.mintlify.site/client-sdks/advanced/sequential-id-mapping.md): Map local UUIDs to server-assigned sequential IDs when your backend requires integer primary keys.
- [Raw SQLite Tables to Bypass JSON View Limitations](https://powersync-sync-streams-nav.mintlify.site/client-sdks/advanced/raw-tables.md): Access raw SQLite tables to bypass JSON view limitations for native SQLite functionality and better query performance.
- [Pre-Seeding SQLite Databases](https://powersync-sync-streams-nav.mintlify.site/client-sdks/advanced/pre-seeded-sqlite.md): Speed up initial sync by pre-seeding SQLite databases with baseline data so users can start working immediately after app installation.
- [State Management Libraries](https://powersync-sync-streams-nav.mintlify.site/client-sdks/advanced/state-management.md): Use PowerSync with state management libraries like Riverpod in Dart/Flutter apps.
- [CRDT Data Structures](https://powersync-sync-streams-nav.mintlify.site/client-sdks/advanced/crdts.md): Use CRDT data structures from libraries like Yjs alongside PowerSync for conflict-free collaborative editing with offline sync support.
- [GIS Data: PostGIS](https://powersync-sync-streams-nav.mintlify.site/client-sdks/advanced/gis-data-postgis.md): Sync PostGIS geographic data through PowerSync and query it on the client using SQLite spatial tools.
- [Unit Testing](https://powersync-sync-streams-nav.mintlify.site/client-sdks/advanced/unit-testing.md): Set up unit tests for PowerSync in Dart and Flutter using mock databases and isolated sync configurations.
- [Local-Only Usage](https://powersync-sync-streams-nav.mintlify.site/client-sdks/advanced/local-only-usage.md): Use PowerSync for local-only data persistence without backend sync or authentication.
- [Background Syncing](https://powersync-sync-streams-nav.mintlify.site/client-sdks/advanced/background-syncing.md): Run PowerSync sync operations while your app is in the background to keep local data up to date.
- [Sync Catch-Up (Checkpoint Requests)](https://powersync-sync-streams-nav.mintlify.site/client-sdks/advanced/checkpoint-requests.md): Wait for the local database to catch up with the latest server state.
- [Data Encryption](https://powersync-sync-streams-nav.mintlify.site/client-sdks/advanced/data-encryption.md): Secure client-side data with encryption in transit via TLS and at rest for SQLite databases.
- [Using SQLite Extensions](https://powersync-sync-streams-nav.mintlify.site/client-sdks/advanced/sqlite-extensions.md): Extend capabilities in client-side databases with custom SQLite extensions
- [SQLite Performance Optimization](https://powersync-sync-streams-nav.mintlify.site/client-sdks/advanced/performance-optimization.md): Optimize query performance in PowerSync client SDKs
- [Writing Client Changes](https://powersync-sync-streams-nav.mintlify.site/handling-writes/writing-client-changes.md): Build a backend API endpoint to apply client-side writes from the PowerSync upload queue to your source database.
- [Handling Write / Validation Errors](https://powersync-sync-streams-nav.mintlify.site/handling-writes/handling-write-validation-errors.md): Handle transient and permanent write errors in the PowerSync upload queue.
- [Handling Update Conflicts](https://powersync-sync-streams-nav.mintlify.site/handling-writes/handling-update-conflicts.md): Understand what happens when multiple users update the same records while offline.
- [Custom Conflict Resolution](https://powersync-sync-streams-nav.mintlify.site/handling-writes/custom-conflict-resolution.md): Implement custom conflict resolution in PowerSync for concurrent updates from multiple offline clients.
- [Data Pipelines](https://powersync-sync-streams-nav.mintlify.site/handling-writes/custom-write-checkpoints.md): Use custom checkpoints to keep client data stable when your backend applies uploads to the source database asynchronously.
- [Troubleshooting](https://powersync-sync-streams-nav.mintlify.site/debugging/troubleshooting.md): Diagnose and fix common PowerSync issues using logs, diagnostics, and troubleshooting tools.
- [Error Codes Reference](https://powersync-sync-streams-nav.mintlify.site/debugging/error-codes.md): Reference of PowerSync error codes with explanations and troubleshooting guidance.
- [Log Reference](https://powersync-sync-streams-nav.mintlify.site/debugging/log-reference.md): Understand common PowerSync Service log messages and recognize replication progress, sync activity, and errors.
- [Sync Diagnostics Client](https://powersync-sync-streams-nav.mintlify.site/tools/diagnostics-client.md): Inspect and debug PowerSync sync behavior with the Sync Diagnostics Client app, a standalone tool for testing Sync Streams.
- [Understanding the SQLite Database](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/client-database-diagnostics.md): Analyze and debug the local PowerSync SQLite database on the client.
- [Monitoring and Alerting](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/monitoring-and-alerting.md): Set up monitoring and alerting for PowerSync Cloud instances to track replication and sync health, connection status, and common errors.
- [Replication Lag](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/replication-lag.md): Understand, monitor, and reduce replication lag between your source database and the PowerSync Service.
- [Production Readiness Best Practices Guide](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/production-readiness-guide.md): Best practices for running PowerSync reliably in production.
- [Compacting Buckets](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/compacting-buckets.md): Reduce storage and sync overhead by compacting and defragmenting data.
- [Implementing Schema Changes](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/implementing-schema-changes.md): How PowerSync handles schema changes across Postgres, MongoDB, MySQL, SQL Server, and Convex during replication.
- [Deploying Schema Changes](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/deploying-schema-changes.md): Procedures for deploying schema changes in PowerSync.
- [Self-Hosting Maintenance & Ops](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/self-hosting/overview.md): Production and operations guides for self-hosted PowerSync deployments.
- [Deployment Architecture](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/self-hosting/deployment-architecture.md): Infrastructure and sizing recommendations for self-hosted PowerSync in staging and production.
- [Railway + PowerSync](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/self-hosting/railway.md): Deploy the PowerSync Service with a custom backend on Railway.
- [Deploy PowerSync Service on Coolify](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/self-hosting/coolify.md): Deploy the self-hosted PowerSync Service on Coolify with Docker Compose.
- [Deploy PowerSync on AWS ECS](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/self-hosting/aws-ecs.md): Deploy the self-hosted PowerSync Service on AWS ECS with Fargate.
- [Deploy PowerSync on AWS EKS](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/self-hosting/aws-eks.md): Deploy the self-hosted PowerSync Service on Kubernetes using the community Helm charts.
- [Update Sync Streams (Sync Config)](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/self-hosting/update-sync-rules.md): Update Sync Streams/Sync Rules in a self-hosted PowerSync deployment.
- [Health Checks](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/self-hosting/healthchecks.md): Configure health check endpoints for self-hosted PowerSync Service deployments.
- [Securing Your Deployment](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/self-hosting/securing-your-deployment.md): Network architecture and security guidance for self-hosted PowerSync deployments.
- [Monitoring](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/self-hosting/monitoring.md): Monitor a self-hosted PowerSync Service by scraping metrics from a Prometheus-compatible endpoint.
- [Usage Reporting](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/self-hosting/usage-reporting.md): How self-hosted PowerSync collects anonymous usage metrics, and how to opt out.
- [Diagnostics](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/self-hosting/diagnostics.md): How to use the PowerSync Service Diagnostics API to inspect replication status, errors, and slot health.
- [Multiple PowerSync Instances](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/self-hosting/multiple-instances.md): Run multiple self-hosted PowerSync instances for load distribution and high availability.
- [Migrating Between Instances](https://powersync-sync-streams-nav.mintlify.site/maintenance-ops/self-hosting/migrating-instances.md): Migrate users between self-hosted PowerSync instances with minimal downtime.
- [Integrations Overview](https://powersync-sync-streams-nav.mintlify.site/integrations/overview.md): Browse PowerSync integrations with backend services including Supabase, Neon, and Serverpod.
- [Supabase + PowerSync](https://powersync-sync-streams-nav.mintlify.site/integrations/supabase/guide.md): Build Supabase apps with PowerSync that use client-side SQLite for real-time updates across users and devices, instant interactions and continued functionality when offline.
- [PowerSync and Supabase Realtime](https://powersync-sync-streams-nav.mintlify.site/integrations/supabase/realtime-streaming.md): Understand how PowerSync's local database sync differs from subscribing to Postgres changes with Supabase Realtime.
- [RLS and Sync Streams](https://powersync-sync-streams-nav.mintlify.site/integrations/supabase/rls-and-sync-streams.md): How PowerSync Sync Streams work alongside Supabase Row Level Security.
- [Local Development with Supabase and PowerSync](https://powersync-sync-streams-nav.mintlify.site/integrations/supabase/local-development.md): Set up local development with Supabase and PowerSync.
- [Improve Supabase Connector](https://powersync-sync-streams-nav.mintlify.site/integrations/supabase/connector-performance.md): Optimize Supabase connector performance in PowerSync apps.
- [Neon + PowerSync](https://powersync-sync-streams-nav.mintlify.site/integrations/neon.md): Build apps on Neon with PowerSync that use client-side SQLite for real-time updates across users and devices, instant interactions and continued functionality when offline.
- [Serverpod + PowerSync](https://powersync-sync-streams-nav.mintlify.site/integrations/serverpod.md): Add offline-capable data sync to Serverpod projects using PowerSync.
- [Tools](https://powersync-sync-streams-nav.mintlify.site/tools/overview.md): Overview of PowerSync developer tools: Dashboard, CLI, Diagnostics Client, DevTools integrations, and AI coding tools.
- [CLI](https://powersync-sync-streams-nav.mintlify.site/tools/cli.md): Manage PowerSync Cloud and self-hosted instances from the command line.
- [PowerSync Dashboard](https://powersync-sync-streams-nav.mintlify.site/tools/powersync-dashboard.md): Use the PowerSync Dashboard to manage instances, configure Sync Streams, and monitor usage.
- [Run PowerSync Locally with Docker and the CLI](https://powersync-sync-streams-nav.mintlify.site/tools/local-development.md): Set up PowerSync locally for development using Docker and the CLI.
- [Terraform Provider](https://powersync-sync-streams-nav.mintlify.site/tools/terraform.md): Manage PowerSync Cloud projects and instances as infrastructure-as-code.
- [AI Tools](https://powersync-sync-streams-nav.mintlify.site/tools/ai-tools.md): Set up AI coding tools for PowerSync, including installing agent skills and accessing context files.
- [DevTools Integrations](https://powersync-sync-streams-nav.mintlify.site/tools/devtools-overview.md): IDE and framework DevTools integrations for inspecting PowerSync client-side databases and sync state during development.
- [Dart & Flutter DevTools Extension](https://powersync-sync-streams-nav.mintlify.site/tools/dart-devtools-extension.md): A Dart & Flutter DevTools extension for inspecting PowerSync databases, running SQL queries, and viewing sync status during development.
- [Nuxt DevTools Integration](https://powersync-sync-streams-nav.mintlify.site/tools/nuxt-inspector.md): A Nuxt DevTools integration for inspecting PowerSync sync status, local data, config, and logs during development.
- [Usage & Billing](https://powersync-sync-streams-nav.mintlify.site/resources/usage-and-billing.md): Understand PowerSync Cloud usage-based billing.
- [Pricing Example](https://powersync-sync-streams-nav.mintlify.site/resources/usage-and-billing/pricing-example.md): Example showing how PowerSync Cloud plan costs are calculated based on synced operations and active users.
- [Reducing Usage](https://powersync-sync-streams-nav.mintlify.site/resources/usage-and-billing/reducing-usage.md): Practical ways to lower data synced and data hosted usage on PowerSync Cloud.
- [FAQ & Troubleshooting](https://powersync-sync-streams-nav.mintlify.site/resources/usage-and-billing/usage-and-billing-faq.md): Find answers to common questions about PowerSync Cloud usage and diagnose unexpected usage.
- [Performance and Limits](https://powersync-sync-streams-nav.mintlify.site/resources/performance-and-limits.md): Performance benchmarks and Service limits for PowerSync Cloud.
- [Supported Platforms](https://powersync-sync-streams-nav.mintlify.site/resources/supported-platforms.md): Supported platforms and feature availability for each PowerSync Client SDK across mobile, web, desktop, headless/server and embedded.
- [Feature Status](https://powersync-sync-streams-nav.mintlify.site/resources/feature-status.md): Current status of PowerSync features, including alpha and beta labels with API stability and SLA implications.
- [FAQ](https://powersync-sync-streams-nav.mintlify.site/resources/faq.md): Frequently asked questions about PowerSync.
- [Local-First Software](https://powersync-sync-streams-nav.mintlify.site/resources/local-first-software.md): Understand the local-first software architecture pattern and how PowerSync enables it.
- [Security & HIPAA](https://powersync-sync-streams-nav.mintlify.site/resources/security.md): PowerSync Cloud's security posture, data protection practices, and encryption standards.
- [HIPAA Compliance](https://powersync-sync-streams-nav.mintlify.site/resources/hipaa.md): HIPAA compliance for PowerSync Cloud, including BAA availability and deployment requirements.
- [Contact Us](https://powersync-sync-streams-nav.mintlify.site/resources/contact-us.md): Contact the PowerSync team via Discord, GitHub, email, or paid support.

## Optional

- [GitHub](https://github.com/powersync-ja)
- [Community Discord](https://discord.com/invite/powersync)
- [PowerSync Website](https://www.powersync.com/)