postgres-patterns

用于查询优化、模式设计、索引和安全性的PostgreSQL数据库模式。基于Supabase最佳实践。

1.26x

Quality

75%

Does it follow best practices?

Impact

91%

1.26x

Average score across 3 eval scenarios

Securityby

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./docs/zh-CN/skills/postgres-patterns/SKILL.md

Evaluation results

90%

13%

Database Schema for a Multi-Currency Marketplace

Data types and index selection

Criteria

Without this skill

With this skill

bigint for IDs

100%

text for strings

70%

100%

timestamptz for timestamps

100%

numeric for currency

100%

boolean for flags

100%

GIN for JSONB

100%

BRIN for time-series

100%

Partial index usage

100%

Covering index INCLUDE

Composite index column order

100%

95%

45%

Harden a Multi-Tenant SaaS PostgreSQL Instance

RLS policy optimization and security configuration

Criteria

Without this skill

With this skill

SELECT wraps auth.uid() in RLS

100%

REVOKE public schema

50%

100%

max_connections set

100%

work_mem set

50%

100%

idle_in_transaction timeout

50%

100%

statement_timeout set

50%

100%

pg_stat_statements enabled

100%

pg_reload_conf called

100%

RLS enabled on table

100%

Correct timestamp type in schema

100%

bigint for user/tenant IDs

50%

90%

Optimize a Slow Product Catalog with Background Processing

Cursor pagination and queue processing

Criteria

Without this skill

With this skill

Cursor pagination pattern

100%

No OFFSET in pagination

100%

FOR UPDATE SKIP LOCKED

100%

RETURNING clause in queue update

100%

UPSERT ON CONFLICT

100%

Composite index equality-first order

100%

Covering index for listing query

Queue status index

100%

Correct timestamp type

100%

Repository: affaan-m/ECC
Path: docs/zh-CN/skills/postgres-patterns/SKILL.md
Commit: e04ea0b

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

Table of Contents

Database Schema for a Multi-Currency Marketplace Optimize a Slow Product Catalog with Background Processing Harden a Multi-Tenant SaaS PostgreSQL Instance

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.