Electricsql
ElectricSQL streams partial replicas of Postgres data to client apps in real time using Shapes, handling the read path with logical replication while writes flow through your existing API. Set up Shape requests with filtering and column selection, implement auth proxies to control access per user, and choose write patterns ranging from online-only to through-the-database strategies.
ElectricSQL syncs Postgres data to local clients in real time using Shapes for partial replication.
AI-generated summary based on this skill's SKILL.md
Decision gist · record as of 2026-03-02
ElectricSQL syncs Postgres data to local clients in real time using Shapes for partial replication. ElectricSQL streams partial replicas of Postgres data to client apps in real time using Shapes, handling the read path with logical replication while writes flow through your existing API. Set up Shape requests with filtering and column selection, implement auth proxies to control access per user, and choose write patterns ranging from online-only to through-the-database strategies.
Use it when
- ElectricSQL supports offline-first architecture by maintaining local SQL replicas on clients that sync automatically when connectivity.
- ElectricSQL's local-first approach stores data locally on each client device using SQL, syncing changes bidirectionally with Postgres.
Install
oakoss/agent-skills/electricsql · repository language: Python
generated, unverified - the skill's exact subdirectory could not be determined; check the repository on GitHub
Open directory. Skills are indexed for reading, not audited. Review a skill's body before installing it.
Frequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
What does ElectricSQL sync database do?
ElectricSQL streams partial replicas of Postgres data to client apps in real time using Shapes. It handles the read path with logical replication while writes flow through your existing API, enabling offline-first applications with automatic synchronization between local SQL databases and your cloud backend.
How does ElectricSQL enable offline-first applications?
ElectricSQL supports offline-first architecture by maintaining local SQL replicas on clients that sync automatically when connectivity returns. The system includes automatic conflict resolution, allowing apps to work seamlessly offline and then reconcile changes with the server without manual intervention.
What is local first SQL database architecture in ElectricSQL?
ElectricSQL's local-first approach stores data locally on each client device using SQL, syncing changes bidirectionally with Postgres. You manage schema changes through your database, set up Shape requests with filtering and column selection, and implement auth proxies to control per-user access to replicated data.
How does ElectricSQL handle real time database synchronization?
ElectricSQL uses logical replication from Postgres to stream data changes to clients in real time. Shapes define which data each client receives, writes return through your existing API, and the system automatically handles consistency across distributed edge and server environments.
Can ElectricSQL replicate data across edge and server environments?
Yes, ElectricSQL replicates data across distributed edge and server environments by streaming Postgres partial replicas to client apps. You choose write patterns ranging from online-only to through-the-database strategies, enabling flexible deployment across edge nodes and central servers.
How do you set up ElectricSQL for local SQL with cloud sync?
ElectricSQL setup involves configuring Shape requests to specify which Postgres data syncs to clients, implementing auth proxies for access control, and choosing your write pattern. The system handles real-time synchronization automatically, managing schema changes and conflict resolution without manual intervention.
Let your AI agent find skills like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 56,283 agent skills by what they can do, searchable in plain language.
wish › “Synchronize local SQL databases with cloud in real time”
Give your agent the search over MCP, or paste the wish link into any chat. No install? Search from any chat →
Related skills
TanStack DB is a reactive client store that extends TanStack Query with typed collections, live queries, and optimistic mutations. It normalizes data for sub-millisecond cross-collection queries and delivers instant optimistic updates with automatic rollback. Use it for apps needing local-first data, real-time sync via ElectricSQL, or complex joins that outgrow per-query caching.
This framework guides you through adopting local-first architecture for web applications, from deciding whether it fits your use case to selecting sync engines, client-side storage solutions, and conflict resolution approaches. It covers when local-first makes sense—collaborative apps, latency-sensitive UIs, unreliable networks—and when simpler server-based patterns are better.
PGlite brings a full PostgreSQL query engine to the browser and Node.js as a lightweight WASM build, weighing under 3MB gzipped. It supports transactions, extensions like pgvector and full-text search, live reactive queries, and multi-tab worker coordination. Ideal for offline-capable apps, local-first architectures, and embedded testing without server infrastructure.
Tanstack Start combines React with TanStack Router to build full-stack applications featuring type-safe RPC server functions, server-side rendering with streaming, and middleware composition. Deploy to Cloudflare Workers, Vercel, Netlify, AWS Lambda, and other platforms with built-in support for authentication, API routes, and session management.
Drizzle ORM is a lightweight TypeScript ORM that delivers compile-time type safety while mapping directly to SQL across PostgreSQL, MySQL, and SQLite. It combines a SQL-like query builder with a relational queries API, serverless compatibility, and zero dependencies for full control over your database layer.
TanStack Query is an async state manager that handles server data fetching, caching, and synchronization in React applications. It automates cache invalidation, deduplication, background updates, and stale data management—you supply a queryFn that returns a Promise, and the library handles the rest. Use it for infinite scrolling, offline-first apps, complex cache strategies, and hybrid server/client architectures.
More skills Realtime Sync (unlicensed)