PostgreSQL Optimization

Attested

PostgreSQL quick reference: B-tree/GIN/BRIN index selection, data type cheat sheet, Row Level Security patterns, connection pooling, and Supabase-specific best practices.

postgresqldatabaseindexingsupabaserls

Governance Receipt

Signer
sovereign-claw-ed25519
Signed At
6/4/2026
Risk Tier
T1
Receipt Hash
bff2b29f
Manifest Hash
88cee60cd7070bf773c104ac8866e7462e198bb01fa2d2717a69b352262c0370
Signature
z29Et4D1
Root Public Key
349b0348

Skill Details

Gate Verdict
Attested
Publication State
published
Risk Tier
T1
Manifest Hash
88cee60c

Download Attested Bundle

Claude Code SkillMCP ToolsRaw Bundle
Attested Source RepositoryOriginal Source

Install PostgreSQL Optimization

Each bundle is served from the attested copy of PostgreSQL Optimization, so the file you download is the one covered by the governance receipt on this page rather than whatever currently sits at the upstream source.

Claude Code skill

curl -L "https://atestiv.com/api/download/ecc-postgres-optimization?format=claude-code" -o ecc-postgres-optimization.skill.md

MCP tool definitions

curl -L "https://atestiv.com/api/download/ecc-postgres-optimization?format=mcp" -o ecc-postgres-optimization.mcp-tools.json

Raw attested bundle

curl -L "https://atestiv.com/api/download/ecc-postgres-optimization?format=raw" -o ecc-postgres-optimization.bundle.json

Verify the bundle against its manifest hash

shasum -a 256 ecc-postgres-optimization.bundle.json

Provenance

  • Catalog identifier: ecc-postgres-optimization
  • Harvested from the upstream repository.
  • The manifest hash below is what the signing key committed to. A bundle whose digest does not match it is not the attested PostgreSQL Optimization.
  • Anything published here has been through the same gate, so a missing receipt is itself a signal rather than an omission.

More Skills

DB Migration Patterns

Elevated · Review

Zero-downtime database migration patterns: forward-only production migrations, concurrent index creation, nullable column additions, separate schema vs data migrations, rollback planning.

PPTX

Elevated · Review

Use this skill any time a .pptx file is involved in any way — as input, output, or both. This includes: creating slide decks, pitch decks, or presentations; reading, parsing, or extracting text from any .pptx file (even if the extracted content will be used elsewhere, like in an email or summary); editing, modifying, or updating existing presentations; combining or splitting slide files; working with templates, layouts, speaker notes, or comments. Trigger whenever the user mentions \"deck,\" \"slides,\" \"presentation,\" or references a .pptx filename, regardless of what they plan to do wit…

Pricing Strategist

Elevated · Review

Designs pricing models including usage-based, tiered, freemium, and enterprise pricing. Covers price sensitivity analysis, competitive positioning, and margin optimization.