Supabase Postgres Best Practices
supabase/agent-skills/skills/supabase-postgres-best-practicesai-mlOfficial
Official Provider SkillView repo
Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres database: creating or altering tables and columns (including choosing column types), schema design, migrations and declarative schema files, RLS policies and the tests that verify them, indexes, triggers, database functions, queues and scheduled jobs (pg_cron, pgmq), vector/semantic search (pgvector), and restoring dumps (pg_restore) or impor
Files36 files
CHANGELOG.md74 lines
Loading editor…
Install
RecommendedOne command — your agent picks it up automatically.
Select an AI agent above to see the install command.
or
Manual Install
More stepsDownload the archive and add the files to your project manually.
Skill details
Versionv1.0.0
AuthorSupabase
Categoryai-ml
Skill IDsupabase/agent-skills/skills/supabase-postgres-best-practices
Files36 files
Related skills
SupabaseUse 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, declarative schemas, security audits, Postgres extensions (pg_graphql, pg_cron, pg_vector); debTest AuditLoad whenever a test is authored, changed, or reviewed. Gates new tests before they are added
and audits existing suites for low-value, duplicated, or implementation-coupled coverage across
the unit/integration/e2e/live tiers.Agent Host Chat ContributionsBuild and review cross-cutting agent-host chat behavior through lifecycle contributions. Use when adding turn lifecycle side effects, prompt or context injection, restored-history transformation, protocol-action observation, or when reviewing changes that add code to AgentSideEffects or AgentService.Build Champ TriageFind out why a build has failedChat Customizations EditorUse when working on the Chat Customizations editor — the management UI for agents, skills, instructions, hooks, prompts, MCP servers, and plugins.ComponentHelp author a component specification for an agent.