# PowerSync

## Docs

- [Architecture Overview](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/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.
- [Client Architecture](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/architecture/client-architecture.md): How the PowerSync Client SDK manages connections, local SQLite storage, and the upload queue.
- [Consistency](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/architecture/consistency.md): How PowerSync uses checkpoints and causal consistency to keep client data consistent with the backend.
- [PowerSync Protocol](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/architecture/powersync-protocol.md): Technical overview of the sync protocol between PowerSync clients and the Service.
- [PowerSync Service](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/architecture/powersync-service.md): Understand the PowerSync Service architecture and how it replicates data and delivers real-time sync.
- [Attachments / Files](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/advanced/attachments.md): Sync file attachments like images and PDFs without storing them in the database, using an offline-first queue for uploads and downloads.
- [Background Syncing](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/advanced/background-syncing.md): Run PowerSync sync operations while your app is in the background to keep local data up to date.
- [CRDT Data Structures](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/advanced/crdts.md): Use CRDT data structures from libraries like Yjs alongside PowerSync for conflict-free collaborative editing with offline sync support.
- [JSON, Arrays and Custom Types](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/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.
- [Data Encryption](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/advanced/data-encryption.md): Secure client-side data with encryption in transit via TLS and at rest for SQLite databases.
- [GIS Data: PostGIS](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/advanced/gis-data-postgis.md): Sync PostGIS geographic data through PowerSync and query it on the client using SQLite spatial tools.
- [Local-Only Usage](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/advanced/local-only-usage.md): Use PowerSync for local-only data persistence without backend sync or authentication.
- [Pre-Seeding SQLite Databases](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/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.
- [Querying JSON Data in SQLite](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/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.
- [Raw SQLite Tables to Bypass JSON View Limitations](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/advanced/raw-tables.md): Access raw SQLite tables to bypass JSON view limitations for native SQLite functionality and better query performance.
- [Sequential ID Mapping](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/advanced/sequential-id-mapping.md): Map local UUIDs to server-assigned sequential IDs when your backend requires integer primary keys.
- [State Management Libraries](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/advanced/state-management.md): Use PowerSync with state management libraries like Riverpod in Dart/Flutter apps.
- [Unit Testing](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/advanced/unit-testing.md): Set up unit tests for PowerSync in Dart and Flutter using mock databases and isolated sync configurations.
- [Cascading Delete](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/cascading-delete.md): Implement cascading deletes in client-side SQLite using triggers and upload queue handlers.
- [Expo Go Support](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/frameworks/expo-go-support.md): Run PowerSync in Expo Go without native modules using @powersync/adapter-sql-js.
- [Dart/Flutter Web Support (Beta)](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/frameworks/flutter-web-support.md): Set up the PowerSync Flutter SDK for web with Chrome and WASM support.
- [Next.js + PowerSync](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/frameworks/next-js.md): Learn how to build highly responsive Next.js applications with PowerSync.
- [Nuxt Integration](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/frameworks/nuxt.md): Integrate PowerSync with Nuxt for offline-first Vue applications.
- [React Hooks](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/frameworks/react.md): Use PowerSync React hooks including useQuery, useStatus, and useSuspenseQuery to build reactive components with live query results.
- [React Native Web Support](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/frameworks/react-native-web-support.md): Configure PowerSync for React Native Web projects.
- [TanStack Query & TanStack DB](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/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.
- [Vue Composables](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/frameworks/vue.md): Use PowerSync Vue composables including useQuery and useStatus to build reactive components with live query results.
- [Full-Text Search](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/full-text-search.md): Implement client-side full-text search using SQLite's FTS5 extension with PowerSync.
- [Experimental: High Performance Diffs](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/high-performance-diffs.md): Get row-level change notifications using trigger-based table diffs in JavaScript SDKs.
- [Infinite Scrolling](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/infinite-scrolling.md): Implement infinite scrolling with PowerSync using paginated SQL queries against the local SQLite database.
- [Dart/Flutter ORM Support](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/orms/flutter-orm-support.md): Use the Drift ORM with the PowerSync Flutter SDK via drift_sqlite_async.
- [Drizzle](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/orms/js/drizzle.md): Use the Drizzle ORM with PowerSync's JavaScript and React Native SDKs.
- [Kysely](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/orms/js/kysely.md): Use the Kysely query builder with PowerSync's JavaScript and React Native SDKs.
- [JavaScript ORMs Overview](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/orms/js/overview.md): Overview of ORM and query builder integrations for PowerSync JavaScript SDKs, including Drizzle, Kysely, and TanStack DB.
- [TanStack DB](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/orms/js/tanstack-db.md): Use PowerSync with TanStack DB for optimistic mutations and live queries in JavaScript apps.
- [Kotlin SQL Libraries](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/orms/kotlin/overview.md): Overview of SQL mapping library options for the PowerSync Kotlin SDK, including Room and SQLDelight.
- [Room (Alpha)](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/orms/kotlin/room.md): Use Android Room with PowerSync's Kotlin SDK.
- [SQLDelight (Beta)](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/orms/kotlin/sqldelight.md): Use SQLDelight with PowerSync's Kotlin SDK.
- [ORM Support Overview](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/orms/overview.md): Choose a type-safe ORM or query builder for PowerSync instead of writing raw SQL queries.
- [GRDB (Alpha)](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/orms/swift/grdb.md): Use the GRDB SQLite library with PowerSync's Swift SDK.
- [Client SDKs Overview](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/overview.md): Overview of PowerSync's official client SDKs.
- [Reading Data](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reading-data.md): Query data from your local SQLite database using SQL with the PowerSync SDK.
- [Capacitor SDK (alpha)](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reference/capacitor.md): Use PowerSync in Capacitor apps.
- [Capacitor SDK API Reference](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reference/capacitor-api.md): Full API reference for the PowerSync Capacitor SDK.
- [.NET SDK (beta)](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reference/dotnet.md): Use PowerSync in .NET apps (beta).
- [Dart/Flutter SDK](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reference/flutter.md): Use PowerSync in Dart and Flutter apps.
- [Flutter SDK API Reference](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reference/flutter-api.md): Full API reference for the PowerSync Dart/Flutter SDK.
- [JavaScript Web SDK](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reference/javascript-web.md): Use PowerSync in JavaScript Web apps.
- [JavaScript Web SDK API Reference](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reference/javascript-web-api.md): Full API reference for the PowerSync JavaScript Web SDK.
- [Kotlin SDK](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reference/kotlin.md): Use PowerSync in Kotlin Multiplatform apps.
- [Kotlin SDK API Reference](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reference/kotlin-api.md): Full API reference for the PowerSync Kotlin Multiplatform SDK.
- [Node.js client SDK (Beta)](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reference/node.md): Use PowerSync in Node.js apps.
- [Node.js SDK API Reference](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reference/node-api.md): Full API reference for the PowerSync Node.js SDK.
- [React Native & Expo SDK](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reference/react-native-and-expo.md): Use PowerSync in React Native (& Expo) apps.
- [React Native SDK API Reference](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reference/react-native-api.md): Full API reference for the PowerSync React Native SDK.
- [Rust SDK (alpha)](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reference/rust.md): Use PowerSync in Rust apps.
- [Swift SDK](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reference/swift.md): Use PowerSync in Swift apps.
- [Swift SDK API Reference](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reference/swift-api.md): Full API reference for the PowerSync Swift SDK.
- [Tauri SDK (alpha)](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/reference/tauri.md): Use PowerSync in Tauri apps.
- [Usage Examples](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/usage-examples.md): Code examples and common patterns for the PowerSync Client SDKs.
- [Live Queries / Watch Queries](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/watch-queries.md): Subscribe to live queries that re-run automatically when local SQLite data changes.
- [Writing Data](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/client-sdks/writing-data.md): Write data to the local SQLite database and manage the upload queue with the PowerSync SDK.
- [Client-Side Integration With Your Backend](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/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-mintlify-style-consistency-1778162179.mintlify.app/configuration/app-backend/cloudcode.md): Use JourneyApps CloudCode as a managed backend for PowerSync with MongoDB.
- [App Backend Setup](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/configuration/app-backend/setup.md): Configure your app backend to process client-side mutations from the PowerSync upload queue.
- [Auth0](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/configuration/auth/auth0.md): Configure Auth0 as your authentication provider for PowerSync.
- [Custom Authentication](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/configuration/auth/custom.md): Implement custom JWT-based authentication for PowerSync using any auth provider.
- [Development Tokens](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/configuration/auth/development-tokens.md): Generate temporary development tokens for testing PowerSync authentication without a full auth provider.
- [Firebase Auth](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/configuration/auth/firebase-auth.md): Configure Firebase Authentication for PowerSync.
- [Authentication Setup](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/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.
- [Supabase Auth](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/configuration/auth/supabase-auth.md): Use Supabase Auth with PowerSync by verifying Supabase JWTs directly.
- [Stytch + Supabase](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/configuration/auth/supabase-auth/stytch.md): Set up Stytch authentication with Supabase for PowerSync.
- [PowerSync Cloud Instances](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/configuration/powersync-service/cloud-instances.md): Create and configure PowerSync Cloud instances with a database connection.
- [Self-Hosted Instance Configuration](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/configuration/powersync-service/self-hosted-instances.md): Configure self-hosted PowerSync Service deployments using YAML or environment variables.
- [Source Database Connection](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/configuration/source-db/connection.md): Connect a PowerSync Cloud instance to your Postgres, MongoDB, MySQL or SQL Server source database.
- [Postgres Maintenance](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/configuration/source-db/postgres-maintenance.md): Manage Postgres replication slots and WAL lag for reliable PowerSync replication.
- [Private Endpoints](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/configuration/source-db/private-endpoints.md): Connect PowerSync Cloud to your database over AWS PrivateLink without public internet exposure.
- [Security & IP Filtering](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/configuration/source-db/security-and-ip-filtering.md): Restrict database access to PowerSync Cloud using static IP allowlisting by deployment region.
- [Source Database Setup](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/configuration/source-db/setup.md): Prepare your Postgres, MongoDB, MySQL or SQL Server database for PowerSync replication.
- [Advanced SQL Server Configuration](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/configuration/source-db/sql-server-additional-configuration.md): Configure advanced SQL Server adapter options for self-hosted PowerSync.
- [Error Codes Reference](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/debugging/error-codes.md): Reference of PowerSync error codes with explanations and troubleshooting guidance.
- [Troubleshooting](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/debugging/troubleshooting.md): Diagnose and fix common PowerSync issues using logs, diagnostics, and troubleshooting tools.
- [Custom Conflict Resolution](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/handling-writes/custom-conflict-resolution.md): Implement custom conflict resolution in PowerSync for concurrent updates from multiple offline clients.
- [Data Pipelines](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/handling-writes/custom-write-checkpoints.md): Use Custom Write Checkpoints to track asynchronous data uploads through chained data pipelines and confirm write completion on the client.
- [Handling Update Conflicts](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/handling-writes/handling-update-conflicts.md): Understand how PowerSync resolves conflicts when multiple users update the same records while offline.
- [Handling Write / Validation Errors](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/handling-writes/handling-write-validation-errors.md): Handle transient and permanent write errors in the PowerSync upload queue.
- [Writing Client Changes](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/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.
- [Neon + PowerSync](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/integrations/neon.md): Build highly responsive, synced apps with Neon and PowerSync using a TypeScript demo app.
- [Integrations Overview](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/integrations/overview.md): Browse PowerSync integrations with backend services including Supabase, Neon, and Serverpod.
- [Serverpod + PowerSync](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/integrations/serverpod.md): Add offline-capable data sync to Serverpod projects using PowerSync.
- [Improve Supabase Connector](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/integrations/supabase/connector-performance.md): Optimize Supabase connector performance in PowerSync apps.
- [Supabase + PowerSync](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/integrations/supabase/guide.md): Build offline-first apps with Supabase and PowerSync across Flutter, React Native, Web, Kotlin, and Swift.
- [Local development with Supabase and PowerSync](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/integrations/supabase/local-development.md): Set up local development with Supabase and PowerSync.
- [Real-time Streaming](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/integrations/supabase/realtime-streaming.md): Replace Supabase Realtime with PowerSync streaming sync and the watch() API for efficient, offline-capable database change listeners.
- [RLS and Sync Streams](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/integrations/supabase/rls-and-sync-streams.md): How PowerSync Sync Streams work alongside Supabase Row Level Security.
- [Demo Apps & Example Projects](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/intro/examples.md): Demo apps and example projects showcasing PowerSync across all supported platforms and backends.
- [PowerSync Docs](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/intro/powersync-overview.md): PowerSync is a sync engine that keeps your backend database in sync with in-app SQLite.
- [PowerSync Philosophy](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/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.
- [Self-Hosting](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/intro/self-hosting.md): Get started self-hosting the PowerSync Service with Docker, including local dev setup via the PowerSync CLI.
- [PowerSync Setup Guide](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/intro/setup-guide.md): Step-by-step guide to adding PowerSync to your app, from connecting your source database to integrating the client SDK.
- [Understanding the SQLite Database](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/client-database-diagnostics.md): Analyze and debug the local PowerSync SQLite database on the client.
- [Compacting Buckets](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/compacting-buckets.md): Reduce storage and sync overhead by compacting and defragmenting data.
- [Deploying Schema Changes](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/deploying-schema-changes.md): Procedures for deploying schema changes in PowerSync.
- [Implementing Schema Changes](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/implementing-schema-changes.md): How PowerSync handles schema changes across Postgres, MongoDB, MySQL, and SQL Server during replication.
- [Monitoring and Alerting](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/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.
- [Production Readiness Best Practices Guide](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/production-readiness-guide.md): Best practices for running PowerSync reliably in production.
- [Replication Lag](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/replication-lag.md): Understand, monitor, and reduce replication lag between your source database and the PowerSync Service.
- [Deploy PowerSync on AWS ECS](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/self-hosting/aws-ecs.md): Deploy the self-hosted PowerSync Service on AWS ECS with Fargate.
- [Deploy PowerSync Service on Coolify](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/self-hosting/coolify.md): Deploy the self-hosted PowerSync Service on Coolify with Docker Compose.
- [Deployment Architecture](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/self-hosting/deployment-architecture.md): Infrastructure and sizing recommendations for self-hosted PowerSync in staging and production.
- [Diagnostics](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/self-hosting/diagnostics.md): Use the PowerSync Diagnostics API to inspect replication status and sync health.
- [Health Checks](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/self-hosting/healthchecks.md): Configure health check endpoints for self-hosted PowerSync Service deployments.
- [Metrics](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/self-hosting/metrics.md): Collect PowerSync Service metrics via Prometheus-compatible endpoints.
- [Migrating Between Instances](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/self-hosting/migrating-instances.md): Migrate users between self-hosted PowerSync instances with minimal downtime.
- [Multiple PowerSync Instances](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/self-hosting/multiple-instances.md): Run multiple self-hosted PowerSync instances for load distribution and high availability.
- [Self-Hosting Maintenance & Ops](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/self-hosting/overview.md): Production and operations guides for self-hosted PowerSync deployments.
- [Railway + PowerSync](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/self-hosting/railway.md): Deploy the PowerSync Service with a custom backend on Railway.
- [Securing Your Deployment](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/self-hosting/securing-your-deployment.md): Network architecture and security guidance for self-hosted PowerSync deployments.
- [Telemetry](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/self-hosting/telemetry.md): Integrate self-hosted PowerSync with OpenTelemetry for distributed observability.
- [Update Sync Streams (Sync Config)](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/maintenance-ops/self-hosting/update-sync-rules.md): Update Sync Streams/Sync Rules in a self-hosted PowerSync deployment.
- [MongoDB Atlas Device Sync Migration Guide](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/migration-guides/atlas-device-sync.md): Migrate from MongoDB Atlas Device Sync to PowerSync with step-by-step instructions.
- [Contact Us](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/resources/contact-us.md): Contact the PowerSync team via Discord, GitHub, email, or paid support.
- [FAQ](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/resources/faq.md): Frequently asked questions about PowerSync.
- [Feature Status](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/resources/feature-status.md): Current status of PowerSync features, including alpha and beta labels with API stability and SLA implications.
- [HIPAA Compliance](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/resources/hipaa.md): HIPAA compliance for PowerSync Cloud, including BAA availability and deployment requirements.
- [Local-First Software](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/resources/local-first-software.md): Understand the local-first software architecture pattern and how PowerSync enables it.
- [Performance and Limits](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/resources/performance-and-limits.md): Performance benchmarks and Service limits for PowerSync Cloud.
- [Security & HIPAA](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/resources/security.md): PowerSync Cloud's security posture, data protection practices, and encryption standards.
- [Supported Platforms](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/resources/supported-platforms.md): Supported platforms and feature availability for each PowerSync Client SDK across mobile, web, and desktop.
- [Usage & Billing](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/resources/usage-and-billing.md): Understand PowerSync Cloud usage-based billing.
- [Pricing Example](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/resources/usage-and-billing/pricing-example.md): Example showing how PowerSync Cloud plan costs are calculated based on synced operations and active users.
- [FAQ & Troubleshooting](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/resources/usage-and-billing/usage-and-billing-faq.md): Troubleshoot usage and billing issues and find answers to common questions about PowerSync Cloud usage metering and billing.
- [Case Sensitivity](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/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.
- [Client ID](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/advanced/client-id.md): Understand PowerSync's requirement for a single text-type primary key column called id.
- [Compatibility](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/advanced/compatibility.md): Configure compatibility editions and bucket storage format version in PowerSync's sync config.
- [Multiple Client Versions](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/advanced/multiple-client-versions.md): Handle multiple client app versions that require different output schemas from Sync Streams.
- [Advanced Topics](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/advanced/overview.md): Advanced Sync Streams and Sync Rules topics.
- [Partitioned Tables (Postgres)](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/advanced/partitioned-tables.md): Sync data from Postgres partitioned tables using wildcard table name matching.
- [Prioritized Sync](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/advanced/prioritized-sync.md): Prioritize which tables sync first so users can start working immediately while remaining data continues loading in the background.
- [Schemas and Connections](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/advanced/schemas-and-connections.md): Configure Postgres schema usage in Sync Streams/Rules queries, connect to high-availability replicas, and plan for multiple database connections.
- [Sharded Databases](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/advanced/sharded-databases.md): Sync data from sharded Postgres databases with per-shard PowerSync connection configuration.
- [Sync data by time with Sync Streams](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/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.
- [Grammar Reference (Sync Rules)](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/grammar/sync-rules/index.md): Railroad diagram reference for the SQL grammar supported in legacy Sync Rules queries.
- [Grammar Reference (Sync Streams)](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/grammar/sync-streams/index.md): Railroad diagram reference for the SQL grammar supported in Sync Streams queries.
- [Sync Streams and Sync Rules](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/overview.md): PowerSync Sync Streams and the legacy Sync Rules allow developers to control which data syncs to which clients/devices (i.e. they enable partial sync).
- [Client Parameters](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/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.
- [Data Queries](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/rules/data-queries.md): Write Data Queries in Sync Rules to select and filter data for buckets using bucket parameters.
- [Global Buckets](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/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.
- [Many-to-many relationships and join tables in Sync Rules](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/rules/many-to-many-join-tables.md): Handle many-to-many relationships in Sync Rules using join table strategies.
- [Organize Data Into Buckets](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/rules/organize-data-into-buckets.md): Design Sync Rules to organize data into global and user-filtered buckets.
- [Sync Rules (Legacy)](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/rules/overview.md): Understand legacy Sync Rules for controlling which data syncs to each client.
- [Parameter Queries](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/rules/parameter-queries.md): Define bucket parameters in Sync Rules using Parameter Queries with JWT claims and client parameters.
- [Client-Side Usage](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/streams/client-usage.md): Subscribe to Sync Streams from your client app and manage subscriptions dynamically.
- [Common Table Expressions (CTEs)](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/streams/ctes.md): Reuse common query patterns across Sync Streams using Common Table Expressions (CTEs) to simplify configurations and reduce duplication.
- [Examples, Patterns & Demos](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/streams/examples.md): Common Sync Streams patterns and real-world examples for different sync configurations.
- [Migrating from Sync Rules](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/streams/migration.md): Migrate existing projects from legacy Sync Rules to Sync Streams.
- [Sync Streams](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/streams/overview.md): Introduction to Sync Streams, the recommended way to define which data syncs to each client with SQL-based stream definitions.
- [Using Parameters](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/streams/parameters.md): Filter synced data dynamically using subscription, auth, and connection parameters in Sync Streams queries.
- [Writing Queries](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/streams/queries.md): Learn Sync Streams query syntax for filtering, column selection, and type transformations.
- [Supported SQL](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/supported-sql.md): Reference for SQL syntax, operators, built-in functions, and type casting supported in Sync Streams/Sync Rules queries.
- [Types](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/sync/types.md): How Postgres, MongoDB, MySQL and SQL Server types map to PowerSync's SQLite-based sync column definitions.
- [AI Tools](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/tools/ai-tools.md): Set up AI coding tools for PowerSync, including installing agent skills and accessing context files.
- [CLI](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/tools/cli.md): Manage PowerSync Cloud and self-hosted instances from the command line.
- [Dart & Flutter DevTools Extension](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/tools/dart-devtools-extension.md): A Dart & Flutter DevTools extension for inspecting PowerSync databases, running SQL queries, and viewing sync status during development.
- [DevTools Integrations](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/tools/devtools-overview.md): IDE and framework DevTools integrations for inspecting PowerSync client-side databases and sync state during development.
- [Sync Diagnostics Client](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/tools/diagnostics-client.md): Inspect and debug PowerSync sync behavior with the Sync Diagnostics Client app, a standalone tool for testing Sync Streams.
- [Run PowerSync locally with Docker and the CLI](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/tools/local-development.md): Set up PowerSync locally for development using Docker and the CLI.
- [Nuxt DevTools Integration](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/tools/nuxt-inspector.md): A Nuxt DevTools integration for inspecting PowerSync sync status, local data, config, and logs during development.
- [Tools](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/tools/overview.md): Overview of PowerSync developer tools: Dashboard, CLI, Diagnostics Client, DevTools integrations, and AI coding tools.
- [PowerSync Dashboard](https://powersync-mintlify-style-consistency-1778162179.mintlify.app/tools/powersync-dashboard.md): Use the PowerSync Dashboard to manage instances, configure Sync Streams, and monitor usage.

## Optional

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