💡 Summary
This skill provides performance optimization guidelines for Postgres when using Supabase.
🎯 Target Audience
🤖 AI Roast: “Powerful, but the setup might scare off the impatient.”
Risk: Medium. Review: shell/CLI command execution; outbound network access (SSRF, data egress). Run with least privilege and audit before enabling in production.
Supabase Agent Skills
Agent Skills to help developers using AI agents with Supabase. Agent Skills are folders of instructions, scripts, and resources that agents like Claude Code, Cursor, Github Copilot, etc... can discover and use to do things more accurately and efficiently.
The skills in this repo follow the Agent Skills format.
Installation
npx skills add supabase/agent-skills
Claude Code Plugin
You can also install the skills in this repo as Claude Code plugins
/plugin marketplace add supabase/agent-skills /plugin install postgres-best-practices@supabase-agent-skills
Available Skills
Postgres performance optimization guidelines from Supabase. Contains rules 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 (Medium-High)
- 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 add proper indexes to this table
Skill Structure
Each skill contains:
SKILL.md- Instructions for the agentAGENTS.md- Compiled rules document (generated)rules/- Individual rule filesmetadata.json- Version and metadata
License
MIT
Pros
- Comprehensive performance guidelines.
- Supports various optimization tasks.
- Easy integration with AI agents.
Cons
- Limited to Postgres optimization.
- May require familiarity with SQL.
- Not all skills may be relevant to every user.
Related Skills
sql-pro
A“This skill knows everything about SQL optimization except how to actually run a query, making it the ultimate backseat database driver.”
supabase-best-practices
A“Powerful, but the setup might scare off the impatient.”
Disclaimer: This content is sourced from GitHub open source projects for display and rating purposes only.
Copyright belongs to the original author supabase.