Synchronize PostgreSQL data with client applications via ElectricSQL Shapes.
npx skills add https://github.com/oakoss/agent-skills --skill electricsql
Please help me install this Agent Skill. Skill: electricsql Source: https://github.com/oakoss/agent-skills/tree/main/skills/electricsql Command: npx skills add https://github.com/oakoss/agent-skills --skill electricsql
This Skill addresses the challenge of keeping client-side data synchronized in real-time with a PostgreSQL database, enabling robust local-first application architectures.
Use the electricsql skill to set up real-time Postgres sync for your application.
High-intent search queries and answers about installing and using this skill.
PostgreSQL sync to clients is achieved by streaming partial replicas using ElectricSQL's Shape technology, ensuring data consistency across devices. This enables local-first application architectures with offline support and automatic conflict resolution.
Partial data replication uses Shapes to sync only the necessary subset of Postgres data to the client. This allows offline-first apps to maintain a local data replica, function seamlessly without connectivity, and sync changes bidirectionally once online.
Yes, local-first apps can handle offline writes and sync automatically using progressive write strategies. When connectivity is restored, bidirectional synchronization ensures all offline changes are persisted and reconciled with the PostgreSQL database.
Yes, this real-time sync approach works directly with PostgreSQL databases to facilitate bidirectional data synchronization. It manages partial replication via Shapes and supports production patterns like auth proxies and robust error handling.
Using partial replication shapes requires careful management of data consistency and robust error handling for production deployments. You must plan auth proxies and progressive write strategies to handle complex offline edge cases effectively.
ricardocidaleManages PostgreSQL environments for development and production with Drizzle ORM schema migrations and data syncing.
jamshuGenerate offline-first Odoo-backed PWAs with SvelteKit, React, or Vue scaffolding.
elab-developmentCreate Flux UI components in Laravel Blade and Livewire workflows.
claude-office-skillsAutomate database synchronization, replication, and migration between heterogeneous systems.
