Installation
npx skills add oakoss/agent-skills --skill pglite 48
Installs
PGlite
Overview
PGlite is a lightweight WASM build of PostgreSQL 17.4 that runs directly in the browser, Node.js, and Bun with no external dependencies. It provides a full Postgres query engine with extensions, transactions, COPY support, and listen/notify in under 3MB gzipped.
When to use: Local-first apps needing a real SQL engine, browser-based analytics, offline-capable PWAs, embedded Postgres for testing, prototyping without a server.
When NOT to use: High-concurrency server workloads (use native Postgres), apps requiring full Postgres replication, Safari OPFS storage (not supported), write-heavy multi-tab scenarios without leader election.
Quick Reference
| Pattern | API | Key Points |
|---|---|---|
| Create instance | PGlite.create(dataDir?, options?) |
Awaits ready internally |
| In-memory DB | PGlite.create() |
Default, ephemeral storage |
| IndexedDB storage | PGlite.create('idb://dbname') |
Persists in browser |
| OPFS storage | PGlite.create('opfs-ahp://dbname') |
Worker only, no Safari |
| Parameterized query | db.query<T>(sql, params) |
Returns QueryResult<T> |
| Tagged template | db.sql\SELECT ...`` |
Auto-parameterized |
| Multi-statement exec | db.exec(sqlString) |
No params, returns void |
| Transaction | db.transaction(async (tx) => {}) |
Full ACID, use tx.query |
| Load extension | extensions: { vector } in create |
Loaded at construction |
| Live query | db.live.query(sql, params, cb) |
Re-runs on data change |
| Incremental query | db.live.incrementalQuery(sql, params, key, cb) |
Diffs large result sets |
| Live changes | db.live.changes(sql, params, key, cb) |
Raw insert/update/delete ops |
| React hook | useLiveQuery(sql, params) |
Returns { rows } reactively |
| Multi-tab worker | PGliteWorker + leader election |
Single writer, multi reader |
| Electric sync | syncShapeToTable(db, shape, table) |
One-way read-only sync |
| Dump data | db.dumpDataDir('gzip') |
Returns File blob |
| Load data | PGlite.create({ loadDataDir: blob }) |
Restore from dump |
| Listen/notify | db.listen(channel, cb) |
Postgres LISTEN/NOTIFY |
| Relaxed durability | relaxedDurability: true |
Better browser write perf |
Common Mistakes
| Mistake | Correct Pattern |
|---|---|
Using new PGlite() without awaiting ready |
Use PGlite.create() which awaits internally |
| Using OPFS in main thread | OPFS-AHP requires a Web Worker context |
| Using OPFS on Safari | Safari lacks required OPFS APIs; use idb:// |
| Querying outside transaction callback | Pass tx from transaction callback, use tx.query() |
| Forgetting extension in create options | Extensions must be declared at PGlite.create({ extensions }) |
| Multiple tabs writing without leader election | Use PGliteWorker with leader election for multi-tab |
| Expecting Electric sync to be bidirectional | Electric sync is read-only, one-way from server |
Using live.query() for large datasets |
Use live.incrementalQuery() for large result sets |
Not providing key to incremental query |
Incremental and changes queries require a unique key column |
| Importing extensions without bundler support | Extensions are WASM; ensure bundler handles .wasm assets |
Delegation
If the
electricsqlskill is available, delegate Electric sync patterns, Shape configuration, and real-time replication to it.
Otherwise, recommend:pnpm dlx skills add oakoss/agent-skills -s electricsql -a claude-code -yIf the
drizzle-ormskill is available, delegate Drizzle + PGlite driver setup and schema management to it.
Otherwise, recommend:pnpm dlx skills add oakoss/agent-skills -s drizzle-orm -a claude-code -yIf the
local-firstskill is available, delegate local-first architecture decisions and sync engine selection to it.
Otherwise, recommend:pnpm dlx skills add oakoss/agent-skills -s local-first -a claude-code -y
References
- Installation, storage backends, and configuration
- Queries, transactions, COPY, listen/notify, and data import/export
- Extensions: pgvector, pg_trgm, pgcrypto, full-text search, and more
- Live queries: reactive, incremental, and change-tracking
- React integration: providers, hooks, and typed patterns
- Multi-tab worker architecture and leader election
- Electric sync: shapes, transactional sync, and persistence
Installs
Security Audit
View Source
oakoss/agent-skills
More from this source
EU-Hosted Inference API Power your AI Agents with
the best open-source models.
Drop-in OpenAI-compatible API. No data leaves Europe.
Explore Inference APIGLM
GLM 5
$1.00 / $3.20
per M tokens
Kimi
Kimi K2.5
$0.60 / $2.80
per M tokens
MiniMax
MiniMax M2.5
$0.30 / $1.20
per M tokens
Qwen
Qwen3.5 122B
$0.40 / $3.00
per M tokens
How to use this skill
Install pglite by running npx skills add oakoss/agent-skills --skill pglite in your project directory. Run the install command above in your project directory. The skill file will be downloaded from GitHub and placed in your project.
No configuration needed. Your AI agent (Claude Code, Cursor, Windsurf, etc.) automatically detects installed skills and uses them as context when generating code.
The skill enhances your agent's understanding of pglite, helping it follow established patterns, avoid common mistakes, and produce production-ready output.
What you get
Skills are plain-text instruction files — not executable code. They encode expert knowledge about frameworks, languages, or tools that your AI agent reads to improve its output. This means zero runtime overhead, no dependency conflicts, and full transparency: you can read and review every instruction before installing.
Compatibility
This skill works with any AI coding agent that supports the skills.sh format, including Claude Code (Anthropic), Cursor, Windsurf, Cline, Aider, and other tools that read project-level context files. Skills are framework-agnostic at the transport level — the content inside determines which language or framework it applies to.
Made in Europe Chat with 100+ AI Models in one App.
Use Claude, ChatGPT, Gemini alongside with EU-Hosted Models like Deepseek, GLM-5, Kimi K2.5 and many more.
