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)