pg-extension-lab
ysys143/pg-extension-lab
Harness completo para testar, benchmarkar e tunar extensões PostgreSQL
Ver no GitHubHarness para desenvolver, testar, fazer benchmark e tunar extensões PostgreSQL em ambiente isolado e reproduzível. Oferece templates prontos para testes (PGXS/pgrx), benchmarks com matched-recall, relatórios Pareto e contratos de serviço, eliminando gaps comuns entre testes verdes e comportamento real.
Instalação
npx convez-ai ysys143/pg-extension-lab1 comando no terminal: detecta o formato do repositório (marketplace ou plugin avulso) e instala via Claude Code. Requer Node 18+ e o Claude Code instalado.
Métricas
Casos de uso
- Desenvolver e validar extensões PostgreSQL do zero com CI/testes isolados
- Executar benchmarks de extensões existentes com métricas confiáveis (matched-recall, Pareto)
- Desenhar experimentos de tuning e otimização com relatórios de hipótese-evidência-resultado
Veredito

Ferramenta madura e opinada para eliminar gaps reais no desenvolvimento de extensões PostgreSQL. Excelente para times que querem feedback rápido e artefatos confiáveis, mas requer familiaridade com PGXS, pgrx e ciclos de teste complexos.
README
A tradução para o português deste README ainda está na fila.
pg-extension-lab

pg-extension-lab is a harness for developing, testing, benchmarking, and tuning a PostgreSQL extension — validating observable behavior in an isolated, reproducible environment, separately from the implementation.
A Claude Code skill, distilled from real
C/PGXS, Rust/pgrx, GPU/CUDA, and extension+microservice projects. Use it to build an
extension from scratch, or to design tuning experiments, write scenarios, and run
isolation/regression tests against an existing one. Packaged as a Claude Code plugin
marketplace (.claude-plugin/) so it installs without manual symlinks.
Why This Exists
Most PostgreSQL extension work fails in the gaps: a green unit test that never loaded the
.so, a benchmark that compares mismatched recall, a fast path that only wins because the
fixture is too friendly, or a service integration where the API, fixture, and environment each
tell a different story.
This skill turns those hard lessons into reusable working material:
- copy-ready PGXS/pgrx test ladders, isolation specs, and CI fragments;
- filtered ANN and accelerator benchmark harnesses with bounded parameter-space planning;
- Pareto/frontier reporting that explains where an option fits, not just which number won;
- hypothesis, evidence, and report templates that keep claims tied to raw artifacts;
- service-boundary contracts that separately verify API shape, fixture meaning, and effective runtime environment.
The point is not to add ceremony. The point is to make feedback faster, sharper, and harder to fake.
What's inside
The skill lives at skills/pg-extension-lab/: three
architecture shapes (in-process / microservice / out-of-process daemon) across five reference
categories — testing (C unit / pg_regress golden-file / pg_isolation_regress
concurrency), benchmarking (matched-recall, trust labeling, accelerator-vs-CPU crossover,
cost-per-query), performance (resource-vs-performance Pareto, governance), architecture
(Rust/pgrx, async outbox workers, service-boundary contracts, security), and accelerator
(GPU/CUDA specifics).
Install
As a Claude Code plugin (recommended)
/plugin marketplace add ysys143/pg-extension-lab
/plugin install pg-extension-lab
Claude Code clones the repo, registers the bundled skill, and handles updates via the plugin
manager. The skill auto-activates by its description; invoke it explicitly with
/pg-extension-lab.
Manual (clone + symlink)
git clone https://github.com/ysys143/pg-extension-lab.git ~/src/pg-extension-lab
ln -s ~/src/pg-extension-lab/skills/pg-extension-lab ~/.claude/skills/pg-extension-lab
Layout
pg-extension-lab/
.claude-plugin/
marketplace.json # this repo as a Claude Code marketplace
plugin.json # plugin manifest; skills: ./skills/
skills/
pg-extension-lab/
SKILL.md # overview + navigation
references/ # testing/ benchmarking/ performance/ architecture/ accelerator/ harnesses/
assets/ # reusable harness templates: testing, benchmarks, service contracts, ops
README.md
LICENSE
The skills/ layout leaves room to add more skills later (skills/<name>/SKILL.md); the
plugin manifest's "skills": "./skills/" picks them up automatically.
License
MIT