AGENTS.md@skills/supabase-postgres-best-practicesA

AGENTS.md@skills/supabase-postgres-best-practices from julianromli/ai-skills is an AGENTS.md file: the standing instructions coding agents read in that repo.

Install it, pinned
mdr add julianromli/ai-skills/skills/supabase-postgres-best-practices/AGENTS.md@git:20260505.3e57ae0

Pins git:20260505.3e57ae0 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 14 of 14 checks passed
Kind
AGENTS.md file
Repository
julianromli/ai-skills
Path
skills/supabase-postgres-best-practices/AGENTS.md
Versions recorded
1
Latest version
git:20260505.3e57ae0, committed May 5, 2026
Size
44,927 bytes
Repository stars
214
License
none declared

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

# Postgres Best Practices

**Version 1.0.0**
Supabase
January 2026

> This document is optimized for AI agents and LLMs. Rules are prioritized by performance impact.

---

## Abstract

Comprehensive Postgres performance optimization guide for developers using Supabase and Postgres. Contains performance rules across 8 categories, prioritized by impact from critical (query performance, connection management) to incremental (advanced features). Each rule includes detailed explanations, incorrect vs. correct SQL examples, query plan analysis, and specific performance metrics to guide automated optimization and code generation.

---

## Table of Contents

1. [Query Performance](#query-performance) - **CRITICAL**
   - 1.1 [Add Indexes on WHERE and JOIN Columns](#11-add-indexes-on-where-and-join-columns)
   - 1.2 [Choose the Right Index Type for Your Data](#12-choose-the-right-index-type-for-your-data)
   - 1.3 [Create Composite Indexes for Multi-Column Queries](#13-create-composite-indexes-for-multi-column-queries)
   - 1.4 [Use Covering Indexes to Avoid Table Lookups](#14-use-covering-indexes-to-avoid-table-lookups)
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add julianromli/ai-skills/skills/supabase-postgres-best-practices/AGENTS.md@sha256:a5226ca435fe12cf

The line at the top of this page pins the label git:20260505.3e57ae0, 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_ratkrt3nzo6ueswu.svg)](https://markdownregistry.com/a/art_ratkrt3nzo6ueswu)

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

Versions

The registry has recorded 1 version of this file, committed on May 5, 2026.

versioncommittedcommitsizeaudit
git:20260505.3e57ae0 latest2026-05-05 3e57ae0 44,927 BA view

Audit of the latest version

A  14 of 14 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Size between 200 bytes and 200 KB (44927 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

julianromli/ai-skills · 214 stars · license none declared · pushed 2026-10-26 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_ratkrt3nzo6ueswu
GET https://markdownregistry.com/api/v1/resolve?ref=julianromli/ai-skills/skills/supabase-postgres-best-practices/AGENTS.md
GET https://markdownregistry.com/api/v1/blob/a5226ca435fe12cf69ef8343aeaa5a9f2ae40679986b09eacb247711471e8722

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: how to write a good AGENTS.md · AGENTS.md vs CLAUDE.md · which agent file does what.

More from julianromli/ai-skills

agent-browser SKILL.md skill
julianromli/ai-skills · skills/agent-browser/SKILL.md · Browser automation CLI for AI agents. Use when the user needs to interact with websites, including navigating pages…
git:20260505.3e57ae0 · audit A · 214 stars
brainstorming SKILL.md skill
julianromli/ai-skills · skills/brainstorming/SKILL.md · You MUST use this before any creative work - creating features, building components, adding functionality, or modifying…
git:20260505.3e57ae0 · audit A · 214 stars
clone-website SKILL.md skill
julianromli/ai-skills · skills/clone-website/SKILL.md · Reverse-engineer and clone one or more websites in one shot — extracts assets, CSS, and content section-by-section and…
git:20260505.3e57ae0 · audit A · 214 stars
collapsible-sidebar SKILL.md skill
julianromli/ai-skills · skills/collapsible-sidebar/SKILL.md · Use this when building a sidebar that collapses to an icon rail, or any element that toggles between shown and hidden…
git:20261025.aa1a923 · audit A · 214 stars
AGENTS.md@skills/composition-patterns AGENTS.md file
julianromli/ai-skills · skills/composition-patterns/AGENTS.md
git:20260505.3e57ae0 · audit A · 214 stars
vercel-composition-patterns SKILL.md skill
julianromli/ai-skills · skills/composition-patterns/SKILL.md
v1.0.0 · audit B · 214 stars
convex-best-practices SKILL.md skill
julianromli/ai-skills · skills/convex-best-practices/SKILL.md · Guidelines for building production-ready Convex apps covering function organization, query patterns, validation…
git:20260505.3e57ae0 · audit A · 214 stars
deploy-to-vercel SKILL.md skill
julianromli/ai-skills · skills/deploy-to-vercel/SKILL.md · Deploy applications and websites to Vercel. Use when the user requests deployment actions like "deploy my app", "deploy…
v3.0.0 · audit A · 214 stars
design-engineer-router SKILL.md skill
julianromli/ai-skills · skills/design-engineer-router/SKILL.md · Use at the start of EVERY design, UI/UX, frontend, motion, copy-on-screen, component, review, or product-idea task…
git:20261026.1a245b1 · audit A · 214 stars
frontend-design SKILL.md skill
julianromli/ai-skills · skills/frontend-design/SKILL.md · Create distinctive, production-grade frontend interfaces with high design quality. Use this skill when the user asks to…
git:20260505.3e57ae0 · audit A · 214 stars
frontend-skill SKILL.md skill
julianromli/ai-skills · skills/frontend-skill/SKILL.md · Use when the task asks for a visually strong landing page, website, app, prototype, demo, or game UI. This skill…
git:20260505.3e57ae0 · audit A · 214 stars
gpt-taste SKILL.md skill
julianromli/ai-skills · skills/gpt-tasteskill/SKILL.md · Elite UX/UI & Advanced GSAP Motion Engineer. Enforces Python-driven true randomization for layout variance, strict AIDA…
git:20260505.3e57ae0 · audit A · 214 stars

Every file in julianromli/ai-skills

Other files named AGENTS.md@skills/supabase-postgres-best-practices

AGENTS.md@skills/supabase-postgres-best-practices AGENTS.md file
dannykkh/skill-olympus · skills/supabase-postgres-best-practices/AGENTS.md
git:20260206.27f795b · audit A · 7 stars

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