supabase-postgres-best-practices

Agent Skills to help developers using AI agents with Supabase

Installation
CLI
npx skills add https://github.com/supabase/agent-skills --skill supabase-postgres-best-practices

Installez cette compétence avec la CLI et commencez à utiliser le flux de travail SKILL.md dans votre espace de travail.

Dernière mise à jour le 5/2/2026

Supabase Agent Skills

Supabase Agent Skills

Agent Skills to help developers using AI agents with Supabase. Agent Skills are
folders of instructions, scripts, and resources that agents can discover and use
to do things more accurately and efficiently. Compatible with 18+ AI agents
including Claude Code, GitHub Copilot, Cursor, Cline, and many others.

The skills in this repo follow the Agent Skills
format.

Installation

See the Supabase AI Skills documentation
for detailed installation instructions.

Install all skills

npx skills add supabase/agent-skills

Install a specific skill

npx skills add supabase/agent-skills --skill supabase
npx skills add supabase/agent-skills --skill supabase-postgres-best-practices

Claude Code Plugin

You can also install the skills as Claude Code plugins:

# 1. Install supabase/agent-skill marketplace
claude plugin marketplace add supabase/agent-skills

# 2. Install the plugin that you want 
claude plugin install supabase@supabase-agent-skills
claude plugin install postgres-best-practices@supabase-agent-skills

Available Skills

supabase

Comprehensive Supabase development skill covering all Supabase products and
integrations.

Use when:

  • Working with any Supabase product (Database, Auth, Edge Functions, Realtime,
    Storage, Vectors, Cron, Queues)
  • Using client libraries and SSR integrations (supabase-js, @supabase/ssr) in
    Next.js, React, SvelteKit, Astro, Remix
  • Troubleshooting auth issues (login, logout, sessions, JWT, cookies, getSession,
    getUser, getClaims, RLS)
  • Using the Supabase CLI or MCP server
  • Working with schema changes, migrations, security audits, or Postgres extensions
    (pg_graphql, pg_cron, pg_vector)
supabase-postgres-best-practices

Postgres performance optimization guidelines from Supabase. Contains references
across 8 categories, prioritized by impact.

Use when:

  • Writing SQL queries or designing schemas
  • Implementing indexes or query optimization
  • Reviewing database performance issues
  • Configuring connection pooling or scaling
  • Working with Row-Level Security (RLS)

Categories covered:

  • Query Performance (Critical)
  • Connection Management (Critical)
  • Schema Design (High)
  • Concurrency & Locking (Medium-High)
  • Security & RLS (Critical)
  • Data Access Patterns (Medium)
  • Monitoring & Diagnostics (Low-Medium)
  • Advanced Features (Low)

Usage

Skills are automatically available once installed. The agent will use them when
relevant tasks are detected.

Examples:

Optimize this Postgres query
Review my schema for performance issues
Help me set up Supabase Auth with Next.js
Help me add proper indexes to this table

Skill Structure

Each skill follows the Agent Skills Open Standard:

  • SKILL.md - Required skill manifest with frontmatter (name, description, metadata)
  • references/ - (Optional) Reference files for detailed documentation