postgres-patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

1.12x

Quality

60%

Does it follow best practices?

Impact

96%

1.12x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./docs/ja-JP/skills/postgres-patterns/SKILL.md

Evaluation results

88%

E-Commerce Platform Schema Design

Schema design with correct data types and indexes

Criteria

Without context

With context

bigint IDs

100%

text for strings

100%

timestamptz for timestamps

100%

numeric for money

100%

boolean for flags

100%

Composite index equality-first

100%

Covering index INCLUDE

Partial index WHERE clause

100%

Cursor pagination pattern

100%

No OFFSET usage

100%

Background Job Queue with Searchable Metadata

Job queue processing and JSONB/full-text indexing

Criteria

Without context

With context

GIN index for JSONB

100%

GIN index for full-text

100%

BRIN index for timestamp

100%

FOR UPDATE SKIP LOCKED

100%

RETURNING clause

100%

UPSERT ON CONFLICT

100%

EXCLUDED reference

100%

No SELECT then INSERT anti-pattern

100%

23%

Multi-Tenant SaaS Security and Monitoring Hardening

RLS optimization, security hardening, and monitoring setup

Criteria

Without context

With context

RLS SELECT auth.uid() wrap

100%

RLS USING clause

100%

max_connections = 100

100%

work_mem = 8MB

100%

idle_in_transaction_session_timeout

100%

statement_timeout

100%

pg_stat_statements extension

100%

REVOKE public schema

53%

100%

pg_reload_conf

100%

ALTER SYSTEM used

100%

Repository: affaan-m/everything-claude-code
Commit: 5df943e

Evaluated: 29 days ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

E-Commerce Platform Schema Design Background Job Queue with Searchable Metadata Multi-Tenant SaaS Security and Monitoring Hardening

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.