Name: supabase-postgres-best-practices
Rating: 60.8 (1 reviews)
Author: supabase

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.

1.14x

Quality

41%

Does it follow best practices?

Impact

96%

1.14x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./skills/supabase-postgres-best-practices/SKILL.md

Evaluation results

100%

36%

Multi-Tenant SaaS Database Schema

Schema design conventions

Criteria

Without context

With context

Identity PK strategy

100%

Timestamp type

100%

String type

75%

100%

Numeric for money

100%

Lowercase identifiers

100%

FK indexes present

100%

RLS enabled

100%

RLS policies defined

100%

Least-privilege role

100%

bigint for IDs

100%

90%

Optimize Slow Analytics Dashboard Queries

Query optimization patterns

Criteria

Without context

With context

Cursor pagination

100%

No OFFSET

100%

GIN index for JSONB

100%

JSONB index type choice

100%

N+1 batch loading

100%

Partial index for active orders

100%

Covering index or INCLUDE

EXPLAIN ANALYZE present

100%

EXPLAIN interpretation

100%

SQL comments explaining fixes

100%

High-Throughput Job Queue and Connection Setup

Connection pooling and concurrency

Criteria

Without context

With context

Transaction pool mode

100%

Idle timeout configured

100%

Prepared statement fix

100%

SKIP LOCKED present

100%

FOR UPDATE in claim query

100%

Advisory lock usage

100%

Non-blocking advisory lock

100%

Short transaction scope

100%

Deadlock prevention ordering

80%

100%

Pool mode rationale

100%

Repository: supabase/agent-skills
Commit: 4e69c80

Evaluated: about 2 months ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Multi-Tenant SaaS Database Schema Optimize Slow Analytics Dashboard Queries High-Throughput Job Queue and Connection Setup

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.