Pgmicro Postgres Sqlite

This is a pretty clever piece of engineering: it takes PostgreSQL SQL, parses it with the actual libpg_query parser, then compiles it straight to SQLite VDBE bytecode executed by Turso's engine. The result is a single-file or in-memory database that speaks PostgreSQL syntax without running a server. You get SERIAL columns, dollar-quoted strings, PostgreSQL cast syntax, and even system catalog tables so psql works. The JavaScript SDK runs in Node or browsers via WASM, and there's a wire protocol server mode if you want to point an ORM at it. This makes sense for embedding Postgres-flavored SQL in apps, testing against Postgres schemas without Docker, or giving each AI agent session its own throwaway database. The SQLite file it writes is readable by any SQLite tool, which is a nice bonus.

skills.sh installs: 764
GitHub stars: 61
last updated: Jul 14, 2026

View on GitHub

Install

$ npx -y skills add aradotso/trending-skills --skill pgmicro-postgres-sqlite --agent claude-code

Installs into .claude/skills of the current project.

Files

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)

# Run without installing
npx pg-micro

# Install globally
npm install -g pg-micro
pg-micro myapp.db

JavaScript/TypeScript SDK

npm install pg-micro

From source (Rust)

SKILL.md on GitHub

Details

Repository: github.com/aradotso/trending-skills
Category: Databases
First seen: May 16, 2026