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.

Install to Claude Code

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