Supabase 与 Postgres 最佳实践
提供 Supabase 开发支持和 Postgres 性能建议。
使用前,准备这些
输入素材:代码库、技术环境与任务验收条件
- 在下方原始文档中确认支持的 AI 工具、模型和运行依赖。
- 打开原仓库,按作者的安装说明完成配置;模型 API 或外部服务可能需要单独开通。
- 用自己的素材试运行,再检查事实、版式与输出文件。
许可证:MIT
来源快照:2026-09-15。README ↗
原项目许可证与版权声明
MIT License Copyright (c) 2026 Supabase Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
可以这样开始
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
.well-known discovery
Each 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.
Migrating to the official GitHub Action
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.