supabase-database

Standardize Supabase migrations, functions, and RLS policies with SQL style and naming conventions.

55|5|Updated Feb 1, 2024
One-click install
npx skills add https://github.com/MakePrisms/agicash --skill supabase-database-makeprisms
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: supabase-database
Source: https://github.com/MakePrisms/agicash/tree/main/.claude/skills/supabase-database
Command: npx skills add https://github.com/MakePrisms/agicash --skill supabase-database-makeprisms

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Standardizes how teams approach Supabase database work—migrations, functions, and Row Level Security (RLS)—to ensure consistent, secure, and auditable code across projects.

Core Features & Use Cases

  • Guidelines for creating migrations, database functions, RLS policies, and SQL style.
  • Best practices to ensure security, maintainability, and clear naming conventions in a Supabase environment.
  • Use Case: start a new Supabase project or refactor an existing database to align with established standards.

Quick Start

Follow these guidelines to start crafting compliant Supabase migrations, functions, and RLS policies.

Frequently Asked Questions about supabase-database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
What are the best practices for writing Supabase database migrations?

Supabase database migrations should follow enforceable SQL style, clear naming conventions, and security requirements to deliver production-ready, auditable database code across projects. This ensures consistency and maintainability for schema changes.

How do I configure Row Level Security policies in Supabase?

Configuring Row Level Security (RLS) policies in Supabase requires following established guidelines for access controls and security requirements. These standards ensure your database enforces proper data protection and auditable policy configurations.

How do I write Postgres functions in a Supabase database?

Writing Postgres functions in a Supabase database involves following unified guidelines for building functions, applying specific SQL style, and adhering to naming conventions. This ensures your functions are maintainable and production-ready.

Do I need to follow specific SQL style conventions for Supabase database projects?

Yes, Supabase database projects require following specific SQL style conventions and naming standards. These enforceable guidelines ensure security, maintainability, and consistency across migrations, functions, and RLS policies.

When should I standardize my Supabase database schema?

You should standardize your Supabase database schema when starting a new project or refactoring an existing database. Applying unified guidelines for migrations, functions, and RLS ensures your codebase remains secure and auditable.

What's the best way to enforce security requirements in Supabase database code?

The best way to enforce security in Supabase database code is applying standardized guidelines for RLS policies, Postgres functions, and migrations. This approach specifies enforceable security requirements and access controls for production-ready code.