pgmicro-postgres-sqlite

SKILL.md

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)