supabase · mindrally — Claude Code skill: what it does, how to install
Guides AI agents on Supabase backend patterns, PostgreSQL schemas, Row Level Security policies, and Deno Edge Functions.
npx skills add Mindrally/skills --skill supabase -a claude-codeWhat supabase does
This skill directs the agent to generate backend code matching Supabase conventions. It enforces Row Level Security (RLS) on database tables, foreign key constraints, and migration files for schema updates. Queries must include indexes for performance, and input validation on the server side is mandatory.
The guidelines cover authentication flows for email and OAuth, secure session handling, and signed URLs in Supabase Storage. For serverless tasks, it requires Deno-based Edge Functions with environment variables for secrets and CORS headers. Real-time subscriptions must include cleanup handlers and filters to prevent wasted bandwidth.
Frontend integrations focus on Next.js and SvelteKit. In Next.js, the agent defaults to React Server Components with minimal client components and caching. In SvelteKit projects, it relies on server-side rendering and native Svelte stores.
What it helps with
- configure PostgreSQL Row Level Security (RLS) policies
- create migration files with indexes and foreign keys
- write Deno Edge Functions with CORS and environment secrets
- implement real-time subscriptions with filtered payloads and cleanup
Example prompts for the agent
- Create a PostgreSQL migration for a comments table with RLS policies linked to auth.users
- Write a Supabase Edge Function in Deno that processes incoming webhooks with CORS support
- Set up a real-time subscription for chat messages filtered by channel_id with proper cleanup
How to install supabase
1Skills CLI (Vercel)
npx skills add Mindrally/skills --skill supabase -a claude-code2Manually: put the files in place
~/.claude/skills/supabase/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/supabase/
1Skills CLI (Vercel)
npx skills add Mindrally/skills --skill supabase -a codex2Manually: put the files in place
.agents/skills/supabase/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add Mindrally/skills --skill supabase -a cursor2Manually: put the files in place
.cursor/skills/supabase/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install Mindrally/skills supabase2Manually: put the files in place
.github/skills/supabase/SKILL.md1Skills CLI (Vercel)
npx skills add Mindrally/skills --skill supabase -a gemini-cli2Platform CLI
gemini skills install https://github.com/Mindrally/skills --path supabaseManually: put the files in place
.devin/skills/supabase/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add Mindrally/skills --skill supabase -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about supabase
How do I install supabase in Claude Code?
Run npx skills add Mindrally/skills --skill supabase -a claude-code in your terminal. The configuration file will be stored at ~/.claude/skills/supabase/SKILL.md.
What does the supabase skill do?
It provides architecture rules for Supabase backend development, covering PostgreSQL migrations, Row Level Security, session authentication, Storage signed URLs, and Deno Edge Functions.
Which frontend frameworks are covered by the skill?
The skill defines patterns for Next.js and SvelteKit. It prioritizes React Server Components in Next.js and server-side rendering with stores in SvelteKit.
Source text
SKILL.md · Apache-2.0
--- name: supabase description: Expert in Supabase backend development with authentication and database patterns metadata: maintainer: Mindrally source: https://github.com/Mindrally/skills --- # Supabase You are an expert in Supabase backend development with deep knowledge of PostgreSQL, authentication, and real-time features. ## Core Principles - Write correct, up-to-date, bug-free, fully functional and working, secure, performant and efficient code - Implement comprehensive error handling and loading states for data-fetching components - Use Row Level Security (RLS) policies for data protection - Leverage Supabase's real-time capabilities when appropriate ## Authentication - Implement proper Supabase authentication flows - Use Row Level Security policies for authorization - Handle auth state changes properly - Implement secure session management - Use appropriate auth providers (email, OAuth, etc.) ## Database - Design efficient PostgreSQL schemas - Use proper data types and constraints - Implement foreign key relationships - Create appropriate indexes for query performance - Use migrations for schema changes ## Real-time - Use Supabase real-time subscriptions appropriately - Implement proper cleanup for subscriptions - Handle connection states and reconnection - Filter subscriptions to minimize data transfer ## Storage - Use Supabase Storage for file management - Implement proper access controls for buckets - Handle file upload/download with proper error handling - Use signed URLs for secure access ## Edge Functions - Use Deno-based Edge Functions for serverless logic - Implement proper error handling - Use environment variables for secrets - Handle CORS appropriately ## Client Integration ### Next.js - Use React Server Components where appropriate - Implement minimal client components - Handle data fetching with proper caching ### SvelteKit - Leverage SSR features - Use Svelte stores for state management ## Security Best Practices - Always use RLS policies - Validate inputs on server side - Use prepared statements (handled by Supabase client) - Implement proper error logging without exposing sensitive data
© Mindrally · Apache-2.0 · Mindrally/skills
Similar skills
All skills for Backend and APIs →supabase by other authors comes first.
