postgres-patterns

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

Quality

—

Does it follow best practices?

Impact

—

No eval scenarios have been run

Securityby

Passed

No known issues

Evaluation results

100%

13%

Content Feed Optimization

Covering indexes, cursor pagination, upsert

Criteria

Baseline

With context

Cursor pagination

100%

No OFFSET

100%

Covering index INCLUDE

100%

Composite index order

100%

Partial index WHERE

100%

UPSERT ON CONFLICT

100%

bigint IDs

100%

text strings

100%

timestamptz timestamps

100%

boolean flags

100%

89%

E-commerce Catalog Database Schema

Data types and index selection

Criteria

Baseline

With context

bigint IDs

100%

text strings

100%

timestamptz timestamps

100%

numeric amounts

83%

100%

boolean flags

100%

GIN for JSONB

100%

BRIN for time-series

100%

Composite index order

100%

Partial index

97%

38%

Production PostgreSQL Hardening and Job Queue

RLS, queue processing, production config, security

Criteria

Baseline

With context

RLS SELECT wrapper

100%

SKIP LOCKED queue

100%

REVOKE public schema

100%

pg_stat_statements

100%

idle transaction timeout

100%

statement timeout

100%

max_connections

50%

70%

work_mem 8MB

100%

Unindexed FK query

40%

100%

Table bloat query

100%

Repository: ysyecust/everything-claude-code
Commit: a9cbecb

Evaluated: 4 months ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

E-commerce Catalog Database Schema Content Feed Optimization Production PostgreSQL Hardening and Job Queue

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.