Data & Analytics Skill
Airflow DAG Patterns
Build production Apache Airflow DAGs with best practices for operators, sensors, testing, and…
$15
PostgreSQL Table Design
Design a PostgreSQL-specific schema.
A PostgreSQL-specific schema design discipline covering data types, indexing, constraints, performance patterns, and advanced features, the difference between a schema that holds up under load and one that bloats and slows over time. It encodes the database's real gotchas (FK columns aren't auto-indexed, UNIQUE allows multiple NULLs, identity gaps are normal) and a measure-don't-guess approach to indexes. The payoff is fast queries, trustworthy data, and schema changes you can ship safely.
$15 one-time
Add to a kit → Prices include 20% VAT. · Forged on real agency work · one-time, no lock-in
- Type Skill
- Category Data & Analytics
- Delivery Email · instant
- License One-time
Inside the run · no black box
See the actual work before you buy it.
Schemas are easy to create and brutal to change. Every column must justify its existence, every type passes a banned list, and every index is earned with EXPLAIN ANALYZE evidence.
- Every column must answer four questions: which read query uses it, what NULL means semantically, how often it updates, and what its cardinality is. A column that cannot answer gets cut, because unjustified columns become bloat, dead indexes and slow vacuums.
- Type discipline is non-negotiable: BIGINT identity for keys, TIMESTAMPTZ for time, TEXT with CHECK constraints instead of varchar(n), NUMERIC for money. A banned-type list (timestamp without zone, char(n), money, serial) is enforced on review.
- Normalizes to 3NF first and denormalizes only on evidence: a hot path has to show over 100ms join cost in EXPLAIN ANALYZE before any cache column is added, and a materialized view is tried before duplicating data.
- Builds constraint defense in depth: NOT NULL plus CHECK at schema level, foreign keys with an explicit ON DELETE action and a manually added index (Postgres does not auto-index FK columns), UNIQUE with NULLS NOT DISTINCT where one null must mean one row.
- Indexes are earned, not sprinkled: only queries proven slow in EXPLAIN ANALYZE get one, partial and covering indexes are preferred where they fit, and a monthly pg_stat_user_indexes review drops anything with zero scans.
- Post-launch, the schema keeps iterating on real traffic: the top 20 queries from pg_stat_statements are reviewed weekly, and partitioning is only introduced past roughly 100M rows with a consistent filter key.
One power source. 6 lines out.
postgresql-table-design · core
core active · 6 lines
- ✓ designing a new schema f…
Designing a new schema from first principles in 3NF
- ✓ choosing the right index
Choosing the right index type (B-tree, GIN, GiST, BRIN, partial, covering)
- ✓ modeling money, time, js…
Modeling money, time, JSONB, arrays, and ranges with correct types
- ✓ partitioning very large
Partitioning very large tables by range, list, or hash
- ✓ tuning update-heavy and
Tuning update-heavy and insert-heavy workloads
- ✓ evolving schema safely w…
Evolving schema safely with concurrent indexes and non-blocking DDL
Yours to keep.
Drag time forward. Watch what stays.
Forever
That's what owning means.
The rented stack
ai writing tool: subscription
expired · access lostanalytics suite: subscription
expired · access lostdesign platform: subscription
expired · access lost(nothing left)
Your forge
-
Data integrity enforced at the database layer, so bugs and raw SQL can't corrupt state
license: perpetual -
Faster queries by indexing only the access paths you actually run
license: perpetual -
Lower storage and write cost by dropping unused indexes and avoiding premature denormalization
license: perpetual -
Safer migrations that avoid full table rewrites and blocking locks
license: perpetual
subscriptions expire · deeds don't
Everything in the box.
Pick a piece up. Watch it work.
Data type playbook with explicit do-not-use list (no timestamp, char(n), money, serial)
6 parts · one working system · ships instantly by email
This wasn't forged for everyone.
- Not for you if you'd rather rent a tool than own one.
- Not for you if you want someone else to run your stack.
- Not for you if you're happy guessing.
Backend engineers and DBAs who want PostgreSQL schemas that are fast, durable, and safe to evolve.
then this was forged for you.Works with
Universal by design: these run in any AI. Delivered in the open Agent Skills + MCP format (native in Claude); ChatGPT, Gemini, Cursor and Copilot adapt the same files their own way.
- Claude Native format
- ChatGPT Adapts via open standards
- Gemini Adapts via open standards
- Cursor Adapts via open standards
- Copilot Adapts via open standards
Catch what's on your mind.
the air is clear. nothing between you and the forge.
catch a spark: the forge will answer
-
I already have a production schema, is this only for greenfield design?
No. Safe schema evolution is a core part: concurrent index builds, non-blocking DDL, dropping unused indexes, and workload-specific tuning for update-heavy and insert-heavy tables all apply to systems already under load. Greenfield 3NF design is covered, but so is living with what you have.
-
How does it decide which indexes I should add?
Measure, don't guess: index the access paths you actually run, then verify with usage data and drop what goes unused. The guide spans B-tree, composite, covering, partial, expression, GIN, GiST, and BRIN, and it encodes the classic trap that foreign-key columns are not auto-indexed in Postgres.
-
Does it apply to MySQL or other databases?
No, and that's deliberate. The value is in PostgreSQL-specific behavior: UNIQUE allowing multiple NULLs, identity gaps being normal, CONCURRENTLY index builds, the do-not-use type list. Translating it to MySQL would carry over advice that's simply wrong there.
-
How is it delivered?
By email right after purchase: ready to run, downloaded instantly, no setup wait.
-
One-time or subscription?
A one-time purchase; no subscription or hidden fees. VAT (20%) is included.
-
Can I get a refund?
As a digital product, it can’t be refunded once downloaded. That’s why we show exactly what’s inside and who it’s for, right here.