convez.ai
SkillDevOps & InfraestruturaAvançado
ysys143

pg-extension-lab

ysys143/pg-extension-lab

Harness completo para testar, benchmarkar e tunar extensões PostgreSQL

Ver no GitHub
InicialPluginScore · de 0 a 100

Harness 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-lab

1 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

Estrelas
1
Forks
1
Acompanhando
0
Saúde
42%
Último commit
há 3 semanas
Versão
—
Issues abertas
0
Contribuidores
1

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 hero

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

Ver o original no GitHub

Bom para

Relacionados