Build local-first, offline-capable TypeScript apps with PowerSync. Use when implementing real-time sync between SQLite and backend databases (Postgres, MongoDB, MySQL, SQL Server). Covers schema definition, database setup, CRUD operations, React/Vue hooks, watch queries, and Kysely/Drizzle ORM integration.
/plugin marketplace add guillempuche/ai-skill-powersync/plugin install guillempuche-ai-skill-powersync@guillempuche/ai-skill-powersyncPayload Development plugin - covers collections, fields, hooks, access control, plugins, and database adapters.
Database query optimization, cloud cost optimization, and scalability improvements
Database architecture, schema design, and SQL optimization for production systems
Business metrics analysis, KPI tracking, financial reporting, and data-driven decision making