Skill

powersync

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.

Install

npx claudepluginhub guillempuche/ai-standards --plugin ai-standards

Tool Access

This skill is limited to using the following tools:

Read Write Edit Bash Grep Glob

Preview

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

Supporting Assets

references/examples.mdreferences/sync-rules.md

SKILL.md

Similar Skills

skill-lookup

Searches, retrieves, and installs Agent Skills from prompts.chat registry using MCP tools like search_skills and get_skill. Activates for finding skills, browsing catalogs, or extending Claude.

prompts.chat

159.9k

prompt-lookup

Searches prompts.chat for AI prompt templates by keyword or category, retrieves by ID with variable handling, and improves prompts via AI. Use for discovering or enhancing prompts.

prompts.chat

159.9k

next-compile

1 file

Checks Next.js compilation errors using a running Turbopack dev server after code edits. Fixes actionable issues before reporting complete. Replaces `next build`.

vercel-next-js-2

139.2k

Stats

Stars0

Forks0

Last CommitFeb 15, 2026

Used By2 plugins

Actions

View Source View Plugin View on GitHub View README

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

Platform	Package
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

Schema → docs · example
Database → docs · example
Connector → docs · example

API Quick Reference

Operation	Method
Get one	`db.get(sql, params)` / `db.getOptional(sql, params)`
Get all	`db.getAll(sql, params)`
Execute	`db.execute(sql, params)`
Transaction	`db.writeTransaction(async (tx) => { ... })`
Watch	`db.query({sql, parameters}).watch()`
Diff watch	`db.query({sql, parameters}).differentialWatch()`

Full CRUD: docs

React Hooks

Hook	Purpose
`useQuery`	Query with loading/error states
`useSuspenseQuery`	Query with Suspense
`useStatus`	Connection status
`usePowerSync`	Database instance

Docs: React · Vue

ORM Integration

ORM	Docs	Example
Kysely	docs	source
Drizzle	docs	source
TanStack DB	docs	demo

Documentation

Topic	URL
Overview	https://docs.powersync.com/intro/powersync-overview.md
Web SDK	https://docs.powersync.com/client-sdk-references/javascript-web.md
React Native SDK	https://docs.powersync.com/client-sdk-references/react-native-and-expo.md
Sync Rules	https://docs.powersync.com/usage/sync-rules.md
Watch Queries	https://docs.powersync.com/usage/use-case-examples/watch-queries.md
API Reference	https://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

Package	Description
common	Shared core (schema, sync, types)
web	Web SDK
react-native	React Native SDK
node	Node.js SDK
capacitor	Capacitor SDK
react	React hooks
vue	Vue composables
tanstack-react-query	TanStack Query integration
kysely-driver	Kysely ORM driver
drizzle-driver	Drizzle ORM driver
attachments	File attachments helper
powersync-op-sqlite	OP-SQLite adapter
adapter-sql-js	SQL.js adapter (Expo Go)