supabase-postgres-best-practices SKILL.md skillA

supabase-postgres-best-practices from dannykkh/skill-olympus is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add dannykkh/skill-olympus/supabase-postgres-best-practices@v1.1.0

Pins v1.1.0 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
dannykkh/skill-olympus
Path
skills/supabase-postgres-best-practices/SKILL.md
Versions recorded
1
Latest version
v1.1.0, committed Feb 6, 2026
Size
2,577 bytes
Repository stars
7
License
MIT

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Supabase Postgres Best Practices

Comprehensive performance optimization guide for Postgres, maintained by Supabase. Contains rules across 8 categories, prioritized by impact to guide automated query optimization and schema design.

## When to Apply

Reference these guidelines when:
- Writing SQL queries or designing schemas
- Implementing indexes or query optimization
- Reviewing database performance issues
- Configuring connection pooling or scaling
- Optimizing for Postgres-specific features
- Working with Row-Level Security (RLS)

## Rule Categories by Priority

| Priority | Category | Impact | Prefix |
|----------|----------|--------|--------|
| 1 | Query Performance | CRITICAL | `query-` |
| 2 | Connection Management | CRITICAL | `conn-` |
| 3 | Security & RLS | CRITICAL | `security-` |
| 4 | Schema Design | HIGH | `schema-` |
| 5 | Concurrency & Locking | MEDIUM-HIGH | `lock-` |
| 6 | Data Access Patterns | MEDIUM | `data-` |
| 7 | Monitoring & Diagnostics | LOW-MEDIUM | `monitor-` |
| 8 | Advanced Features | LOW | `advanced-` |

## How to Use

Read individual rule files for detailed explanations and SQL examples:

```
references/query-missing-indexes.md
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add dannykkh/skill-olympus/supabase-postgres-best-practices@sha256:8e5a86aa92990a70

The line at the top of this page pins the label v1.1.0, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_n5hrpmdghplhtdfv.svg)](https://markdownregistry.com/a/art_n5hrpmdghplhtdfv)

5 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 1 version of this file, committed on Feb 6, 2026.

versioncommittedcommitsizeaudit
v1.1.0 latest2026-02-06 27f795b 2,577 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (2577 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

dannykkh/skill-olympus · 7 stars · license MIT · pushed 2026-11-03 · branch master

API

GET https://markdownregistry.com/api/v1/artifacts/art_n5hrpmdghplhtdfv
GET https://markdownregistry.com/api/v1/resolve?ref=dannykkh/skill-olympus/supabase-postgres-best-practices
GET https://markdownregistry.com/api/v1/blob/8e5a86aa92990a706512a6454e3a6a6345a950b454e75a11d048210d0a2ca830

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from dannykkh/skill-olympus

AGENTS.md AGENTS.md file
dannykkh/skill-olympus · AGENTS.md
git:20261018.77243bb · audit A · 7 stars
DESIGN.md DESIGN.md file
dannykkh/skill-olympus · DESIGN.md
git:20260901.44bff6a · audit A · 7 stars
agent-md-refactor SKILL.md skill
dannykkh/skill-olympus · skills/agent-md-refactor/SKILL.md · Use when AGENTS.md, CLAUDE.md, or similar instruction files are bloated (300+ lines). Splits monolithic files into…
git:20260901.8bc747e · audit A · 7 stars
agent-team-codex SKILL.md skill
dannykkh/skill-olympus · skills/agent-team-codex/SKILL.md · Codex CLI의 내장 default, explorer, worker를 조합해 병렬 구현을 수행한다. zephermine 섹션 모드와 자유 모드를 지원하며 /agent-team, /poseidon…
git:20261028.a5e37ce · audit A · 7 stars
agent-team SKILL.md skill
dannykkh/skill-olympus · skills/agent-team/SKILL.md · zephermine 섹션 기반 네이티브 멀티에이전트 오케스트레이션. 의존성 분석, Wave 그룹핑, 파일 소유권 분리, 병렬 구현과 통합 검증을 수행한다. Claude, Codex, Antigravity…
git:20261028.a5e37ce · audit A · 7 stars
antigravity-mnemo SKILL.md skill
dannykkh/skill-olympus · skills/antigravity-mnemo/SKILL.md · Install, remove, or diagnose Mnemo long-term conversation memory for Google Antigravity CLI using its global Stop hook…
git:20261012.94ae631 · audit A · 7 stars
antigravity SKILL.md skill
dannykkh/skill-olympus · skills/antigravity/SKILL.md · Use Google Antigravity CLI (`agy`) for independent code or plan review, large-context analysis, and a second-model…
git:20260901.8bc747e · audit A · 7 stars
api-handoff SKILL.md skill
dannykkh/skill-olympus · skills/api-handoff/SKILL.md · Create backend/frontend API handoff docs for endpoints, frontend data needs, and cross-team data requirements.
git:20260427.85307e1 · audit A · 7 stars
api-tester SKILL.md skill
dannykkh/skill-olympus · skills/api-tester/SKILL.md · API 연동 테스트 스킬. 프론트-백엔드 통신 검증, 프록시 설정 확인, CORS, JWT 토큰, 에러 응답, 파일 업로드 테스트. "API 테스트해줘"로 실행.
git:20261002.d0b4bfd · audit A · 7 stars
argos SKILL.md skill
dannykkh/skill-olympus · skills/argos/SKILL.md · 준공검사 감리 스킬. 설계 산출물(spec, api-spec, qa-scenarios, flow-diagrams) 대비 구현을 정적·런타임·API·QA·도면·보안 관점으로 검증한다. 일반 diff 품질은 가용한…
git:20261103.e529fff · audit A · 7 stars
auto-continue-loop SKILL.md skill
dannykkh/skill-olympus · skills/auto-continue-loop/SKILL.md · 네이티브 /goal(Stop 게이트)을 녹여 쓰는 자율 작업 규율 스킬. 주 진입점은 /chronos. goal은 "끝까지 안 멈추기"(지속성)를 담당하고, 크로노스는 goal이 못 하는 것 — 자가 판단이 아닌…
git:20261028.a5e37ce · audit A · 7 stars
autoresearch SKILL.md skill
dannykkh/skill-olympus · skills/autoresearch/SKILL.md · 기존 스킬의 실제 과업 실패나 측정된 비용을 개선할 때 사용한다. 기준점과 후보를 실행해 비교하고, 수정에 쓰지 않은 별도 평가와 회귀 검사로 채택한다. scan은 조사 우선순위만 제시한다. 기본 설치에서는…
git:20261028.a5e37ce · audit A · 7 stars

Every file in dannykkh/skill-olympus

Other files named supabase-postgres-best-practices

supabase-postgres-best-practices SKILL.md skill
fcakyon/claude-codex-settings · plugins/supabase-skills/skills/supabase-postgres-best-practices/SKILL.md · Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or…
v1.1.1 · audit A · 1,193 stars
supabase-postgres-best-practices SKILL.md skill
syahiidkamil/software-engineer-ai-agent-atlas · .claude/skills/supabase-postgres-best-practices/SKILL.md · Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or…
v1.1.1 · audit A · 404 stars
supabase-postgres-best-practices SKILL.md skill
asymmetric-al/core · .agents/skills/supabase-postgres-best-practices/SKILL.md · Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or…
v1.1.1 · audit A · 373 stars
supabase-postgres-best-practices SKILL.md skill
julianromli/ai-skills · skills/supabase-postgres-best-practices/SKILL.md · Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or…
v1.0.0 · audit A · 214 stars
supabase-postgres-best-practices SKILL.md skill
patrickserrano/lacquer · profiles/supabase/skills/supabase-postgres-best-practices/SKILL.md · Use when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations — including…
v1.1.1 · audit A · 5 stars

Browse by kind, by grade A, or by owner.