postgres-best-practices
πPluginInstallation
/plugin marketplace add supabase/agent-skills/plugin install postgres-best-practices@supabase-agent-skillsREADME.md
View on GitHub β
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 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 (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 follows the Agent Skills Open Standard:
SKILL.md- Required skill manifest with frontmatter (name, description, metadata)AGENTS.md- Compiled references document (generated)references/- Individual reference files
More from this repository4
A set of database rules from Supabase that helps Claude write and fix Postgres tables, queries and security settings correctly. It works for Postgres running anywhere, not only on Supabase.
This skill guides your AI agent through Supabase tasks such as database work, user login, file storage and fixing errors. It makes the agent check current docs first and avoid common security mistakes.
Agent Skills to help developers using AI agents with Supabase
Official Supabase agent skills for AI coding agents covering Postgres best practices, query performance, indexing, RLS, connection pooling, and schema design.