#601

Globales Ranking · von 601 Skills

pglite AI Agent Skill

Quellcode ansehen: oakoss/agent-skills

Medium

Installation

npx skills add oakoss/agent-skills --skill pglite

48

Installationen

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 electricsql skill 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 -y

If the drizzle-orm skill 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 -y

If the local-first skill 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

Installationen

Installationen 48
Globales Ranking #601 von 601

Sicherheitsprüfung

ath Safe
socket Safe
Warnungen: 0 Bewertung: 90
snyk Medium
EU 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 API

GLM

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

So verwenden Sie diesen Skill

1

Install pglite by running npx skills add oakoss/agent-skills --skill pglite in your project directory. Führen Sie den obigen Installationsbefehl in Ihrem Projektverzeichnis aus. Die Skill-Datei wird von GitHub heruntergeladen und in Ihrem Projekt platziert.

2

Keine Konfiguration erforderlich. Ihr KI-Agent (Claude Code, Cursor, Windsurf usw.) erkennt installierte Skills automatisch und nutzt sie als Kontext bei der Code-Generierung.

3

Der Skill verbessert das Verständnis Ihres Agenten für pglite, und hilft ihm, etablierte Muster zu befolgen, häufige Fehler zu vermeiden und produktionsreifen Code zu erzeugen.

Was Sie erhalten

Skills sind Klartext-Anweisungsdateien — kein ausführbarer Code. Sie kodieren Expertenwissen über Frameworks, Sprachen oder Tools, das Ihr KI-Agent liest, um seine Ausgabe zu verbessern. Das bedeutet null Laufzeit-Overhead, keine Abhängigkeitskonflikte und volle Transparenz: Sie können jede Anweisung vor der Installation lesen und prüfen.

Kompatibilität

Dieser Skill funktioniert mit jedem KI-Coding-Agenten, der das skills.sh-Format unterstützt, einschließlich Claude Code (Anthropic), Cursor, Windsurf, Cline, Aider und anderen Tools, die projektbezogene Kontextdateien lesen. Skills sind auf Transportebene framework-agnostisch — der Inhalt bestimmt, für welche Sprache oder welches Framework er gilt.

Data sourced from the skills.sh registry and GitHub. Install counts and security audits are updated regularly.

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

Start for free View pricing
Kundensupport