postgresql-table-design

Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

1.27x

Quality

48%

Does it follow best practices?

Impact

92%

1.27x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./tests/ext_conformance/artifacts/agents-wshobson/database-design/skills/postgresql/SKILL.md

Evaluation results

95%

35%

Retail Platform: Core Database Schema

Core data types and FK indexing

Criteria

Without context

With context

BIGINT IDENTITY PK

83%

No SERIAL type

100%

NUMERIC for price/money

100%

No money type

100%

TIMESTAMPTZ for timestamps

100%

No plain TIMESTAMP

100%

TEXT not VARCHAR

100%

No VARCHAR/CHAR

100%

FK indexes present

100%

snake_case naming

100%

NOT NULL on required fields

100%

Status as TEXT + CHECK

50%

90%

16%

Content Discovery Platform: Article Search Schema

Full-text search and JSONB design

Criteria

Without context

With context

TSVECTOR column

100%

GIN index on tsvector

100%

Language in to_tsvector

100%

Language in to_tsquery

100%

JSONB not JSON

100%

GIN index on JSONB

100%

TIMESTAMPTZ not TIMESTAMP

100%

BIGINT IDENTITY PK

100%

No SERIAL type

100%

BRIN or RANGE partition for dates

100%

UNLOGGED staging table

100%

92%

Workspace Booking System: Reservations Schema

Range types, exclusion constraints, update-heavy design

Criteria

Without context

With context

tstzrange for time slots

100%

GiST index on range

100%

EXCLUDE for double-booking

100%

Array + GIN for tags

100%

Junction table for teams

100%

fillfactor on reservations

100%

Hot/cold column separation

100%

ENUM for stable values

100%

TEXT+CHECK for reservation status

100%

BIGINT IDENTITY PKs

100%

FK indexes present

100%

Repository: Dicklesworthstone/pi_agent_rust
Commit: 47823e3

Evaluated: about 1 month ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Retail Platform: Core Database Schema Content Discovery Platform: Article Search Schema Workspace Booking System: Reservations Schema

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.