Skip to main content
affpapa.org
RU EN
skill CX Codex

pgmicro-postgres-sqlite — Claude Code skill: install & use

Teaches your coding assistant how to configure pgmicro, an engine translating PostgreSQL queries into SQLite bytecode for in-process execution.

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓ 
npx skills add reason-machines/trending-skills --skill pgmicro-postgres-sqlite -a claude-code
Open on GitHub

What pgmicro-postgres-sqlite does

This skill guides agents through embedding pgmicro into applications or using its standalone CLI. The software processes SQL queries with the libpg_query parser, converting statements into virtual database engine (VDBE) instructions handled by Turso. Data resides in an ordinary .db SQLite file or ephemeral memory, while exposing system catalogs such as pg_class.

Projects can consume pgmicro via a WASM-based TypeScript library, through an NPM command-line executable, or as a wire-compatible server on 127.0.0.1:5432. Compiling from source code demands an installed Rust toolchain, whereas Node.js suffices for running the CLI and web client.

What it helps with

  • Execute Postgres SQL queries directly inside an app without running a database daemon
  • Store PostgreSQL-compatible tables in standard portable SQLite .db files
  • Test database migrations locally using psql connected to an ephemeral memory process
  • Run in-browser SQL transactions using TypeScript and WebAssembly

Example prompts for the agent

  • Show me how to initialize an in-memory pgmicro instance using TypeScript
  • Configure a local pgmicro wire server on port 5432 for testing with node-postgres
  • Write a sample table schema with SERIAL primary keys for pgmicro

How to install pgmicro-postgres-sqlite

1Skills CLI (Vercel)

npx skills add reason-machines/trending-skills --skill pgmicro-postgres-sqlite -a claude-code

2Manually: put the files in place

~/.claude/skills/pgmicro-postgres-sqlite/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/pgmicro-postgres-sqlite/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about pgmicro-postgres-sqlite

How to install pgmicro-postgres-sqlite in Claude Code?

Run npx skills add reason-machines/trending-skills --skill pgmicro-postgres-sqlite -a claude-code. The tool adds database management instructions directly to your assistant context.

What is pgmicro?

It is an embeddable SQL engine that interprets PostgreSQL syntax and executes it on top of SQLite storage via Turso. It works without background database servers.

Can standard database tools inspect pgmicro databases?

Yes, created .db files follow normal SQLite format and open in standard SQLite viewers. You can also inspect data via psql when running in server mode.

Similar skills

All skills for Data and databases →
xlsx official anthropics Creates, reads, edits, and converts spreadsheet files. Use it when the requested deliverable is an Excel workbook or another tabular file. 187,223installs google-agents-cli-observability official Google This skill guides you through tracing and monitoring AI agents, including ADK agents. Use it when you need to inspect agent execution or monitor a deployed agent. CX Codex +1 511,300installs caveman-evidence-review JuliusBrussee A read-only skill reviews Caveman Cloud evidence on LLM spend, traces, and routing. Use it to see where a project’s model budget goes. CX Codex +1 104,500installs migration JuliusBrussee Enforces reversible, compatibility-safe transitions for schema, data, and API updates. Useful whenever data loss or rollout downtime is unacceptable. CX Codex +1 103,900installs performance-optimization addyosmani An agent skill that measures before it changes code: Core Web Vitals budgets, N+1 queries, missing indexes and slow endpoints. CX Codex +1 65,200installs supabase official supabase Guides the agent through database configuration and strict RLS policies in Supabase. CX Codex GP ChatGPT 8installs

From the same set186

codex-plugin-cc Runs OpenAI Codex reviews and delegates background fixes directly from Claude Code. Good for getting an outside critique on diffs. CX Codex +1 838installs pump-analyzer-solana A static front end for watching Pump.fun token launches on Solana: a WebSocket feed, price and volume charts, and alerts on your own criteria. CX Codex +1 837installs app-store-screenshots-generator Builds ad-style iOS app screenshots in Next.js and exports PNG files for App Store device sizes. It also handles localized sets. CX Codex +1 818installs turboquant-pytorch Implements two-stage vector quantization in PyTorch to compress LLM KV cache down to 2–4 bits. Preserves attention scores while cutting memory consumption. CX Codex +1 817installs tribev2-brain-encoding A skill that wires the TRIBE v2 model into your agent so it can predict brain responses to video, audio and text. Built for research work. CX Codex +1 810installs open-pencil-design-editor Teaches your coding agent to inspect, modify, and export local .fig design files using OpenPencil CLI commands or an MCP server. Useful for automated layout generation. CX Codex +1 810installs polymarket-copy-trading-bot Configures a TypeScript bot that monitors target Polymarket wallets and mirrors BUY orders on Polygon mainnet. Useful for automated copy trading via CLOB API. CX Codex +1 804installs taiwan-equity-research-coverage Structured database covering 1,735 Taiwan-listed companies across 99 sectors with supply chain maps, wikilink graphs, and financial update utilities. CX Codex +1 801installs

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor