Use pgmicro — an in-process PostgreSQL reimplementation backed by SQLite-compatible storage, embeddable as a library or CLI
pgmicro Skill by ara.so — Daily 2026 Skills collection. pgmicro is an in-process reimplementation of PostgreSQL backed by a SQLite-compatible storage engine. It parses PostgreSQL SQL using the real PostgreSQL parser (libpg_query) and compiles it directly to SQLite VDBE bytecode, executed by Turso. The result is a fast, embeddable, single-file (or in-memory) database that speaks PostgreSQL — no server process required. Key capabilities Full PostgreSQL SQL syntax (via the actual PG parser) SQLite-compatible .db file format (readable by any SQLite tool) JavaScript/TypeScript SDK (WASM-based, runs in Node.js and browsers) PostgreSQL wire protocol server mode (connect with psql, ORMs, etc.) Dialect switching: access the same database with PG or SQLite syntax PostgreSQL system catalog virtual tables (pg_class, pg_attribute, pg_type, etc.) Installation CLI (Node.js)
don't have the plugin yet? install it then click "run inline in claude" again.