Toast Storage | Agent Skills Atlas

About this skill

PostgreSQL's TOAST (The Oversized-Attribute Storage Technique) — out-of-line + compressed storage for large varlena values (text, bytea, jsonb, arrays, xml, tsvector). Covers src/backend/access/common/toast.c + src/backend/access/table/toasthelper.c + the compression backends (pglz, lz4). Loads when the user asks about TOAST semantics, pgtoast tables, storage strategies (PLAIN / EXTERNAL / EXTENDED / MAIN), inline vs out-of-line thresholds (2 KB / 8 KB rules), TOAST pointers, sliced access (substring optimization), or lz4 vs pglz. Skip when the ask is about pgtoastpgclass etc. as objects (that's catalog metadata) or about specific varlena types' semantics (that's their type's skill).

Quick start

Copy the install prompt. Use the green button above this README.
Send it to your agent. Paste it into your coding agent’s chat and send.
Review the setup. Your agent checks the skill’s instructions, requirements, and installation scope.

Installation guide →

Review, license & listing details

Review the source before using this skill

This is an imported listing. We haven’t certified its safety, license, or compatibility. Skills may include executable scripts.

Automated security scan: Partial

Only SKILL.md was scanned. Supporting files and scripts were not checked. No safety grade has been assigned.

0 potential findings · Scanned 11/4/2026 · Scanner 0.2.1

Content SHA-256: 0eea5c55b61e98f474b5102807fbe0bcb0fe5805c42869774bf8b1be68bddb79

About scan coverage and limitations

Original listing metadata

Original name

toast-storage

Original description

PostgreSQL's TOAST (The Oversized-Attribute Storage Technique) — out-of-line + compressed storage for large `varlena` values (text, bytea, jsonb, arrays, xml, tsvector). Covers `src/backend/access/common/toast_*.c` + `src/backend/access/table/toast_helper.c` + the compression backends (pglz, lz4). Loads when the user asks about TOAST semantics, `pg_toast_<oid>` tables, storage strategies (PLAIN / EXTERNAL / EXTENDED / MAIN), inline vs out-of-line thresholds (2 KB / 8 KB rules), TOAST pointers, sliced access (`substring` optimization), or lz4 vs pglz. Skip when the ask is about `pg_toast_pg_class` etc. as objects (that's catalog metadata) or about specific varlena types' semantics (that's their type's skill).

About this listing

Category: Engineering
Reported license: PostgreSQL
Listing language (estimated): English
Review status: Not individually reviewed
Agent compatibility: Atlas installation supports Claude Code, Codex, and Cursor. Skill-specific dependencies and features are checked during setup.