skills.rest
coreymaypray
coreymayprayCOMMUNITY
Explore all skills by this author →
GitHub

backend-architect

Automate Supabase backend architecture tasks including schema design, RLS policies, edge functions, and migrations.

1|Updated Mar 13, 2026
Search Tags:#design#migrations#rls#backend#supabase#postgres#edge-functions
One-click install
npx skills add https://github.com/coreymaypray/sloth-skill-tree --skill backend-architect-coreymaypray
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: backend-architect
Source: https://github.com/coreymaypray/sloth-skill-tree/tree/main/plugins/maycrest-automate/skills/backend-architect
Command: npx skills add https://github.com/coreymaypray/sloth-skill-tree --skill backend-architect-coreymaypray

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Designs and builds the server-side architecture for Supabase-powered applications, ensuring secure data access, scalable APIs, and maintainable backend code.

Core Features & Use Cases

  • Schema design and migrations for Postgres-backed apps, including reversible migrations and proper indexing.
  • Implementing Row Level Security (RLS) policies and multi-tenant access controls.
  • Developing Supabase Edge Functions and server-side logic to handle webhooks, authentication flows, and data processing.
  • Security, performance, and cost-aware architecture decisions for scalable backends in production.

Quick Start

Build a production-ready Supabase backend by defining a schema, adding RLS policies, and deploying Edge Functions for a multi-tenant SaaS.

Frequently Asked Questions about backend-architect

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

FAQPage Schema
How do I design Supabase schema migrations with reversible rollback plans?▼

Supabase schema migrations require structured rollback plans to ensure safe deployment. This Skill automates reversible Postgres migrations, generates proper indexes, and creates rollback scripts to maintain data integrity during multi-tenant SaaS updates.

How do I set up Row Level Security policies for multi-tenant Supabase apps?▼

Row Level Security policies enforce data isolation in multi-tenant Supabase apps. This Skill generates RLS policy templates and multi-tenant access controls to secure data access across tenant boundaries in Postgres-backed applications.

How do I handle production-grade error handling in Supabase Edge Functions?▼

Production-grade error handling in Supabase Edge Functions requires structured logging and graceful failure responses. This Skill develops server-side logic for webhooks, authentication flows, and data processing with robust error handling mechanisms.

Can I use Supabase for scalable multi-tenant SaaS backend architecture?▼

Supabase supports scalable multi-tenant SaaS backends through Postgres schemas, RLS policies, and Edge Functions. This Skill automates security, performance, and cost-aware architecture decisions for production-grade data isolation and scalable API surfaces.

What's the best way to structure Supabase backend deployment pipelines?▼

Supabase backend deployment pipelines need structured migration sequences and rollback plans. This Skill automates reversible migrations, index recommendations, and policy templates to create robust deployment workflows for Postgres-backed apps.

Why do my Supabase RLS policies fail to isolate tenant data properly?▼

RLS policies fail to isolate tenant data when policy logic doesn't match multi-tenant access patterns. This Skill provides policy templates and access control structures designed specifically for secure data isolation in multi-tenant SaaS environments.

Related Skills

Explore More Software Engineering Skills→
cengo33cengo33

supabase-postgres-best-practices

Optimize Postgres performance with Supabase-focused schema, query, and configuration best practices.

Community
Advanced
antonpmeantonpme
1

supabase

Guides Supabase edge functions, schemas, migrations, and RLS policies.

Community
Advanced
mohamedgshoaibmohamedgshoaib
5

supabase

Manage Supabase database operations, authentication workflows, and security configurations.

Community
Advanced
YOYOMAIIYOYOMAII
1

supabase

Manage Supabase project lifecycle with RLS policies and CLI operations.

Community
Advanced