Skill Gallery
← Back to list
guillempuche

powersync

by guillempuche

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 defin

⭐ 0🍴 0📅 Jan 16, 2026
ai-agentsai-skillsclaude-codecopilotcursorpowersync
View on GitHubRun in Manus

SKILL.md

name: powersync description: 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. license: Apache-2.0 metadata: author: ai-standards version: '1.0' language: typescript frameworks: react, react-native, vue, node compatibility: Node.js 18+, TypeScript 4.7+ allowed-tools: Read Write Edit Bash Grep Glob

PowerSync TypeScript Skill

Sync engine for local-first apps with real-time sync between client SQLite and backend databases.

When to Use

  • Offline-first/local-first applications
  • Real-time sync between client and server
  • Instant UI responsiveness with background sync

Installation

PlatformPackage
Web@powersync/web + @journeyapps/wa-sqlite
React Native@powersync/react-native + @powersync/op-sqlite
React hooks@powersync/react
Vue composables@powersync/vue
Node.js@powersync/node
Kysely ORM@powersync/kysely-driver
Drizzle ORM@powersync/drizzle-driver

Core Setup

  1. Schema → docs · example
  2. Database → docs · example
  3. Connector → docs · example

API Quick Reference

OperationMethod
Get onedb.get(sql, params) / db.getOptional(sql, params)
Get alldb.getAll(sql, params)
Executedb.execute(sql, params)
Transactiondb.writeTransaction(async (tx) => { ... })
Watchdb.query({sql, parameters}).watch()
Diff watchdb.query({sql, parameters}).differentialWatch()

Full CRUD: docs

React Hooks

HookPurpose
useQueryQuery with loading/error states
useSuspenseQueryQuery with Suspense
useStatusConnection status
usePowerSyncDatabase instance

Docs: React · Vue

ORM Integration

ORMDocsExample
Kyselydocssource
Drizzledocssource
TanStack DBdocsdemo

Documentation

TopicURL
Overviewhttps://docs.powersync.com/intro/powersync-overview.md
Web SDKhttps://docs.powersync.com/client-sdk-references/javascript-web.md
React Native SDKhttps://docs.powersync.com/client-sdk-references/react-native-and-expo.md
Sync Ruleshttps://docs.powersync.com/usage/sync-rules.md
Watch Querieshttps://docs.powersync.com/usage/use-case-examples/watch-queries.md
API Referencehttps://powersync-ja.github.io/powersync-js/web-sdk

Local References

  • references/sync-rules.md - Sync Rules configuration
  • references/examples.md - All official example projects

GitHub Source

powersync-ja/powersync-js

PackageDescription
commonShared core (schema, sync, types)
webWeb SDK
react-nativeReact Native SDK
nodeNode.js SDK
capacitorCapacitor SDK
reactReact hooks
vueVue composables
tanstack-react-queryTanStack Query integration
kysely-driverKysely ORM driver
drizzle-driverDrizzle ORM driver
attachmentsFile attachments helper
powersync-op-sqliteOP-SQLite adapter
adapter-sql-jsSQL.js adapter (Expo Go)

Score

Total Score

70/100

Based on repository quality metrics

✓SKILL.md

SKILL.mdファイルが含まれている

+20
✓LICENSE

ライセンスが設定されている

+10
✓説明文

100文字以上の説明がある

+10
○人気

GitHub Stars 100以上

0/15
✓最近の活動

1ヶ月以内に更新

+10
○フォーク

10回以上フォークされている

0/5
✓Issue管理

オープンIssueが50未満

+5
○言語

プログラミング言語が設定されている

0/5
✓タグ

1つ以上のタグが設定されている

+5

Reviews

💬

Reviews coming soon