supabase
By supabase
Optimize Supabase Postgres databases with best practices for query tuning, schema design, connection pooling, RLS policies, and performance. Secure auth sessions, JWTs, storage; test Database, Edge Functions, Realtime implementations. Access live Supabase docs and features via MCP server.
npx claudepluginhub supabase/agent-skills --plugin postgres-best-practicesComponent Overview
Component Details
Skills (2)
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
Use when doing ANY task involving Supabase. Triggers: Supabase products (Database, Auth, Edge Functions, Realtime, Storage, Vectors, Cron, Queues); client libraries and SSR integrations (supabase-js, @supabase/ssr) in Next.js, React, SvelteKit, Astro, Remix; auth issues (login, logout, sessions, JWT, cookies, getSession, getUser, getClaims, RLS); Supabase CLI or MCP server; schema changes, migrations, security audits, Postgres extensions (pg_graphql, pg_cron, pg_vector).
MCP Servers (1)
README
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:
/plugin marketplace add supabase/agent-skills
/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
Similar Plugins
External network access
Connects to servers outside your machine
Help us improve
Share bugs, ideas, or general feedback.