smithery.ai

powersync

Build local-first, offline-capable TypeScript apps with PowerSync.

First seen Apr 11, 2026

Installation

$ npx skills add https://smithery.ai

Summary

  • 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.

Similar popular skills

Related neighbors and high-traction skills in the same topics — useful to compare before installing.

Also in this package

Other skills from smithery.ai · top by installs.

npx skills add https://smithery.ai

Browse all from smithery.ai

More details

Agent compatibility

Declared targets from SKILL.md / docs. Unmarked agents are not listed — the skill may still install via the CLI.

Claude Code Not declared
Cursor Not declared
Codex Not declared
GitHub Copilot Not declared
Windsurf Not declared
Gemini CLI Not declared
Cline Not declared
OpenCode Not declared

Skill metadata

Parsed from SKILL.md frontmatter.

Version1.0.1
LicenseApache-2.0
CompatibilityNode.js 18+, TypeScript 4.7+
Allowed toolsRead Write Edit Bash Grep Glob
More metadata
version
1.0.1
author
ai-standards
language
typescript
frameworks
react, react-native, vue, node

Package contents

Files included with this skill beyond the listing page.

  • skill md SKILL.md 8,046 B
  • docs SUMMARY.md 324 B

History

  1. First seen on skills.sh
  2. First recorded snapshot · 1 installs

SKILL.md

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

  1. Schemadocs · example
  2. Databasedocs · example
  3. Connectordocs · 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

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)