supabase-postgres-best-practices
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
76
78%
Does it follow best practices?
Impact
90%
1.08xAverage score across 2 eval scenarios
Passed
No findings from the security scan
Fix and improve this skill with Tessl
tessl review fix ./plugins/build-web-apps/skills/supabase-best-practices/SKILL.mdThe canonical home for this skill is supabase-postgres-best-practices in supabase/agent-skills
Evaluation results
89%
11%Project Atlas: PostgreSQL Schema Migration
Multi-tenant SaaS PostgreSQL schema design
Identity PKs
0%
20%
Correct column types
100%
100%
FK indexes present
70%
70%
snake_case identifiers
100%
100%
Idempotent constraints
100%
100%
Partial indexes
100%
100%
RLS enabled and forced
50%
100%
SELECT-wrapped auth function
80%
100%
Indexes on RLS policy columns
100%
100%
Event log partitioning
100%
100%
Least privilege grants
75%
100%
92%
3%ShopStream Product Catalog Backend
Efficient product catalog query layer
Cursor pagination pattern
100%
100%
No OFFSET usage
100%
100%
Batch variant load
100%
100%
tsvector generated column
100%
100%
GIN index on tsvector
100%
100%
FTS operator in search query
100%
100%
GIN index on JSONB column
100%
100%
Composite index column order
100%
100%
Covering index with INCLUDE
0%
0%
Partial index
100%
100%
EXPLAIN diagnostic flags
62%
100%
- Repository
- openai/plugins
- Commit
1e28582
- Evaluated
- Agent
- Claude Code
- Model
- Claude Sonnet 4.6
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.