# pumarogie

> Open-source publisher. Listings imported from github.com/pumarogie — credited to the original author with their license.

- **Listings:** 6
- **Total installs:** 0
- **Profile:** https://agentstack.voostack.com/s/pumarogie
- **Website:** https://github.com/pumarogie

## Published listings

- [Designing Postgres Schemas](https://agentstack.voostack.com/l/skill-pumarogie-claude-postgres-skills-designing-postgres-schemas) — Skill · Free · security-reviewed — `agentstack add skill-pumarogie-claude-postgres-skills-designing-postgres-schemas`
  Guides Postgres schema design when creating tables, choosing keys and data types, defining foreign keys and deletion behavior, modeling JSONB, or planning retention for unbounded event and log data.
- [Postgres Advanced Patterns](https://agentstack.voostack.com/l/skill-pumarogie-claude-postgres-skills-postgres-advanced-patterns) — Skill · Free · security-reviewed — `agentstack add skill-pumarogie-claude-postgres-skills-postgres-advanced-patterns`
  Guides production Postgres patterns when implementing multi-worker job queues and leases, batching writes, managing unbounded time-series partitions, or moving data between large live tables.
- [Writing Performant Queries](https://agentstack.voostack.com/l/skill-pumarogie-claude-postgres-skills-writing-performant-queries) — Skill · Free · security-reviewed — `agentstack add skill-pumarogie-claude-postgres-skills-writing-performant-queries`
  Guides evidence-first Postgres query diagnosis when an API or database becomes slow, an expensive query must be found, EXPLAIN must be used safely, the planner ignores an index, statistics may be stale, or a filter-and-sort query needs an index.
- [Tuning Autovacuum And Bloat](https://agentstack.voostack.com/l/skill-pumarogie-claude-postgres-skills-tuning-autovacuum-and-bloat) — Skill · Free · security-reviewed — `agentstack add skill-pumarogie-claude-postgres-skills-tuning-autovacuum-and-bloat`
  Guides autovacuum and bloat remediation when dead tuples accumulate, write-heavy tables outgrow scale-factor defaults, vacuum falls behind, transaction-ID age approaches freeze limits, or tables and indexes consume disproportionate disk.
- [Writing Safe Migrations](https://agentstack.voostack.com/l/skill-pumarogie-claude-postgres-skills-writing-safe-migrations) — Skill · Free · security-reviewed — `agentstack add skill-pumarogie-claude-postgres-skills-writing-safe-migrations`
  Guides Postgres migrations when altering large or live tables, adding indexes or constraints, backfilling columns, changing column types, or planning zero-downtime rollouts. Covers lock levels, lock_timeout, CREATE INDEX CONCURRENTLY, NOT VALID constraints, and expand-and-contract.
- [Managing Postgres Connections](https://agentstack.voostack.com/l/skill-pumarogie-claude-postgres-skills-managing-postgres-connections) — Skill · Free · security-reviewed — `agentstack add skill-pumarogie-claude-postgres-skills-managing-postgres-connections`
  Guides Postgres connection pooling when applications add instances, connection churn or storms appear, max_connections is exhausted, PgBouncer is introduced, or pgxpool and server pool limits must be sized safely.

---
Seller on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Install any with `agentstack add <slug>`.