Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →PostgreSQL best practices, query optimization, schema design, security, operations, and performance tuning. Load when working with Postgres databases.
.claude/skills/mamamou-postgres/SKILL.md| Model | Eval pass | Runs |
|---|---|---|
| gemini-3.6-flash | 94% | 17 |
| Test case | Without → With | Effect | Δ tokens | Δ turns |
|---|---|---|---|---|
| case-09 | ✗→✓ | ▲ Improved | 43% | 0% |
| case-06 | ✓→✓ | ＝ Same ✓ | 67% | 0% |
| case-01 | ✓→✓ | ＝ Same ✓ | 54% | 0% |
| case-02 | ✓→✓ | ＝ Same ✓ | 45% | 0% |
| case-03 | ✓→✓ | ＝ Same ✓ | 141% | 0% |
| Topic | Reference | Use for | | -------------- | ---------------------------------------------------------- | ------------------------------------------------------ | | Schema Design | references/schema-design.md | Tables, primary keys, data types, foreign keys, naming | | JSONB Patterns | references/json-patterns.md | JSONB operators, querying, indexing, best practices | | Partitioning | references/partitioning.md | Range/list partitioning, pg_partman, data retention |
| Topic | Reference | Use for | | ---------------------- | ---------------------------------------------------------------------------- | -------------------------------------------------------- | | Query Patterns | references/query-patterns.md | SQL anti-patterns, JOINs, pagination, N+1 detection | | Indexing | references/indexing.md | Index types, composite, partial, covering, GIN, BRIN | | Index Optimization | references/index-optimization.md | Unused/duplicate index detection, bloat, HOT updates | | Full-Text Search | references/full-text-search.md | tsvector, tsquery, GIN indexing, ranking, search config | | Optimization Checklist | references/optimization-checklist.md | Pre-optimization audit, cleanup, readiness checks |
| Topic | Reference | Use for | | ----------------- | ------------------------------------------------------------------ | ------------------------------------------------------ | | MVCC and VACUUM | references/mvcc-vacuum.md | Dead tuples, autovacuum tuning, bloat prevention | | MVCC Transactions | references/mvcc-transactions.md | Isolation levels, XID wraparound, serialization errors | | Locking | references/locking.md | Lock types, deadlocks, advisory locks, lock monitoring |
| Topic | Reference | Use for | | -------------------- | -------------------------------------------------------------------------- | --------------------------------------------------------------- | | Process Architecture | references/process-architecture.md | Multi-process model, connection management, auxiliary processes | | Memory Architecture | references/memory-management-ops.md | Shared/private memory, OS page cache, OOM prevention | | WAL and Checkpoints | references/wal-operations.md | WAL internals, checkpoint tuning, durability, crash recovery | | Storage Layout | references/storage-layout.md | PGDATA structure, TOAST, fillfactor, tablespaces | | Replication | references/replication.md | Streaming replication, slots, sync commit, failover | | Backup and Recovery | references/backup-recovery.md | pg_dump, pg_basebackup, PITR, WAL archiving |
| Topic | Reference | Use for | | -------------------- | ------------------------------------------------------------------------ | -------------------------------------------------------- | | Configuration Tuning | references/configuration-tuning.md | Memory, I/O, planner, parallelism, workload profiles | | Connection Pooling | references/connection-pooling.md | PgBouncer setup, pool sizing, pooling modes | | Monitoring | references/monitoring.md | pg_stat views, logging, pg_stat_statements, host metrics |
| Topic | Reference | Use for | | ------------------ | ------------------------------------------------------------------------ | ---------------------------------------------------------------- | | Django Integration | references/django-integration.md | ORM optimization, connection pooling, zero-downtime migrations, contrib.postgres |
| Topic | Reference | Use for | | ----------------- | ------------------------------------------------------------------ | --------------------------------------------------------- | | Security | references/security.md | Roles, permissions, RLS, pg_hba.conf, SSL/TLS, audit | | Schema Migrations | references/schema-migrations.md | Zero-downtime DDL, safe migration patterns, backfills | | Extensions | references/extensions.md | pg_stat_statements, pgcrypto, PostGIS, pg_repack, pgAudit |
| Case | Status | Duration (ms) | Turns | Tokens | Tool calls | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Without | With | Δ | Without | With | Δ | Without | With | Δ | Without | With | Δ | ||
case-06 | pass→pass | 10,544 | 11,043 | +5% | 1 | 1 | 0% | 2,061 | 3,432 | +67% | 0 | 0 | — |
case-01 | pass→pass | 11,618 | 11,644 | +0% | 1 | 1 | 0% | 2,124 | 3,279 | +54% | 0 | 0 | — |
case-02 | pass→pass | 12,392 | 10,947 | -12% | 1 | 1 | 0% | 2,193 | 3,182 | +45% | 0 | 0 | — |
case-03 | pass→pass | 5,551 | 7,496 | +35% | 1 | 1 | 0% | 1,016 | 2,446 | +141% | 0 | 0 | — |
case-04 | pass→pass | 7,801 | 8,386 | +7% | 1 | 1 | 0% | 1,461 | 2,775 | +90% | 0 | 0 | — |
case-05 | pass→pass | 3,658 | 4,345 | +19% | 1 | 1 | 0% | 508 | 1,917 | +277% | 0 | 0 | — |
case-07 | pass→pass | 4,253 | 8,148 | +92% | 1 | 1 | 0% | 694 | 2,744 | +295% | 0 | 0 | — |
case-08 | pass→pass | 6,240 | 6,533 | +5% | 1 | 1 | 0% | 1,194 | 2,445 | +105% | 0 | 0 | — |
case-09 | fail→pass | 10,364 | 8,552 | -17% | 1 | 1 | 0% | 1,875 | 2,682 | +43% | 0 | 0 | — |
case-10 | pass→pass | 9,356 | 10,518 | +12% | 1 | 1 | 0% | 1,572 | 2,838 | +81% | 0 | 0 | — |
case-11 | pass→pass | 3,804 | 3,253 | -14% | 1 | 1 | 0% | 740 | 1,831 | +147% | 0 | 0 | — |
case-12 | pass→pass | 4,997 | 6,707 | +34% | 1 | 1 | 0% | 842 | 2,362 | +181% | 0 | 0 | — |
case-13 | pass→pass | 3,547 | 3,549 | +0% | 1 | 1 | 0% | 619 | 1,808 | +192% | 0 | 0 | — |
case-14 | pass→pass | 17,386 | 15,551 | -11% | 1 | 1 | 0% | 2,773 | 4,177 | +51% | 0 | 0 | — |
case-15 | pass→pass | 13,318 | 12,020 | -10% | 1 | 1 | 0% | 2,085 | 3,103 | +49% | 0 | 0 | — |
case-16 | pass→pass | 11,367 | 9,568 | -16% | 1 | 1 | 0% | 1,682 | 2,860 | +70% | 0 | 0 | — |
case-17 | pass→pass | 13,265 | 14,915 | +12% | 1 | 1 | 0% | 2,388 | 3,472 | +45% | 0 | 0 | — |
case-18 | pass→pass | 4,891 | 4,583 | -6% | 1 | 1 | 0% | 806 | 1,976 | +145% | 0 | 0 | — |
case-19 | pass→pass | 7,400 | 6,613 | -11% | 1 | 1 | 0% | 1,225 | 2,290 | +87% | 0 | 0 | — |
case-20 | pass→pass | 3,024 | 3,847 | +27% | 1 | 1 | 0% | 630 | 1,975 | +213% | 0 | 0 | — |
case-21 | pass→pass | 4,014 | 4,244 | +6% | 1 | 1 | 0% | 746 | 1,835 | +146% | 0 | 0 | — |
case-22 | pass→pass | 3,885 | 3,420 | -12% | 1 | 1 | 0% | 650 | 1,782 | +174% | 0 | 0 | — |
DecimalAI ran this skill against gemini-3.6-flash twice over the same eval suite — once with the skill loaded and once without — and compared the two runs case by case. 22 cases were attempted. The headline lift of +5 percentage points is the difference between those two pass rates over the 22 comparable cases.
Without the skill loaded, the model failed this case. With it loaded, the same prompt on the same model passed. This is one improved case from the latest verified run; every case, including any that regressed, is in the table above.
Other measured skills in the registry, with their headline benchmark lift.