postgres-schema-design

postgres-schema-design is a skill for Claude Code, Codex from Dankosik/go-service-template-rest. It costs 22 tokens per session (181 once invoked), scanned A, original, MIT.

A reference for designing tables and relationships in PostgreSQL, a database system that stores structured data in related tables.

In plain words
What is it for?
Use it to decide table structure, relationships, identifiers, constraints, data types, indexes, row-level security, generated values, and safe database changes.
Why use it?
It helps ensure every row has a clear meaning and stable identity, while important business rules are enforced consistently by the database or one defined transaction.

Skill for Claude CodeCodex

Written for no agent in particular: nothing here depends on one.

Good fit Use it to decide table structure, relationships, identifiers, constraints, data types, indexes, row-level security, generated values, and safe database changes.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/dankosik/go-service-template-rest/postgres-schema-design
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add Dankosik/go-service-template-rest --skill postgres-schema-design
Clone the repo
git clone --depth 1 https://github.com/Dankosik/go-service-template-rest

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for postgres-schema-design

README.md
[![agentmods](https://agentmods.dev/badge/skills/dankosik/go-service-template-rest/postgres-schema-design/github.svg)](https://agentmods.dev/skills/dankosik/go-service-template-rest/postgres-schema-design)
Your own site
<a href="https://agentmods.dev/skills/dankosik/go-service-template-rest/postgres-schema-design"><img src="https://agentmods.dev/badge/skills/dankosik/go-service-template-rest/postgres-schema-design/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for postgres-schema-design

Your own site · 80×15
<a href="https://agentmods.dev/skills/dankosik/go-service-template-rest/postgres-schema-design"><img src="https://agentmods.dev/badge/skills/dankosik/go-service-template-rest/postgres-schema-design.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 22 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 181 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00022 $0.00181
Opus 5 $0.00011 $0.00090
Sonnet 5 $0.00004 $0.00036
Haiku 4.5 $0.00002 $0.00018

Measured 9d ago against content hash a064628ea1e7, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-09, from the pricing page.

Security

Grade A, and why

postgres-schema-design scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 9d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

docs/universal-disciplines/postgres-schema-design/SKILL.md · 22 lines

What it actually says

PostgreSQL Schema Design

Use only after the active phase identifies a durable relational-model decision. Inherit its authority, artifact, review, proof, output, and completion contract; do not select a work mode or authorize production DDL here.

Core invariant: every table has one row meaning and stable identity; every business invariant is enforced by the database or assigned to one explicit transactional owner with a falsifier.

Load one branch:

  • relation grain, identity, cardinality, normalization, or lifecycle -> relational-design.md;
  • PostgreSQL type, constraint, index, generated value, RLS, or migration shape -> postgresql-ddl.md.
Files

What ships with it

2 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 9d ago First seen · 22 lines · 22 tokens per session scan A a064628ea1e7

Subscribe to this mod's changes

postgres-schema-design is a skill published in the GitHub repository Dankosik/go-service-template-rest (7 stars, last pushed today), licensed MIT. It adds 22 tokens to every session and 181 once invoked, about $0.0001 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.