Postgres performance optimization and best practices. Use when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

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.
See the Supabase AI Skills documentation for detailed installation instructions.
npx skills add supabase/agent-skills
npx skills add supabase/agent-skills --skill supabase
npx skills add supabase/agent-skills --skill supabase-postgres-best-practices
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
Comprehensive Supabase development skill covering all Supabase products and integrations.
Use when:
Postgres performance optimization guidelines from Supabase. Contains references across 8 categories, prioritized by impact.
Use when:
Categories covered:
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
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.well-known discoveryEach release uploads a dist/index.json alongside the skill tarballs. This index conforms to the agent-skills .well-known URI spec (schema v0.2.0) and is consumed by supabase.com to serve skills at https://supabase.com/.well-known/agent-skills/.
The release artifacts are built by scripts/build-release.ts and triggered by Release Please on every semver release.
jonathanhefner/agentskills-build-for-well-known is intended to be transferred to the agentskills org and published to the GitHub Marketplace. When that happens, scripts/build-release.ts and the pnpm build:release step in release-please.yml can be replaced with the Action directly:
- name: Build release artifacts
uses: agentskills/build-for-well-known@v1 # replaces pnpm build:release
with:
skills-dir: skills
output-dir: dist
Everything else — the Release Please trigger, the upload step, the supabase-plugin dispatch — stays exactly the same. The script and the Action produce identical output, so it is a drop-in swap.
External network access
Connects to servers outside your machine
Own this plugin?
Verify ownership to unlock analytics, metadata editing, and a verified badge. GitHub access is read-only (username + org membership).
Sign in to claimOwn this plugin?
Verify ownership to unlock analytics, metadata editing, and a verified badge. GitHub access is read-only (username + org membership).
Sign in to claimBased on adoption, maintenance, documentation, and repository signals. Not a security audit or endorsement.
Write SQL, explore datasets, and generate insights faster. Build visualizations and dashboards, and turn raw data into clear stories for stakeholders.
Give your AI a memory — mine projects and conversations into a searchable palace. 35 MCP tools, auto-save hooks, and guided setup.
MCP server that saves 98% of your context window with session continuity. Sandboxed code execution in 11 languages, FTS5 knowledge base with BM25 ranking, and automatic state restore across compactions.
Open-source, local-first Claude Code plugin for token reduction, context compression, and cost optimization using hybrid RAG retrieval (BM25 + vector search), reranking, AST-aware chunking, and compact context packets.
Agent Skills for AI/ML tasks including dataset creation, model training, evaluation, and research paper publishing on Hugging Face Hub
npx claudepluginhub bpthevenot-hub/agent-skills --plugin supabase