Backend Skill

Scaffold FastAPI CRUD routes with Supabase authentication and RLS.

Updated Dec 22, 2025
One-click install
npx skills add https://github.com/jv92admin/alfredagain --skill backend-skill-jv92admin
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Backend Skill
Source: https://github.com/jv92admin/alfredagain/tree/main/skills/backend
Command: npx skills add https://github.com/jv92admin/alfredagain --skill backend-skill-jv92admin

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Backend development often involves designing CRUD APIs, enforcing secure access with RLS, and building reliable data models. This Skill provides guidance for FastAPI routes, Supabase integration, and clean backend patterns to accelerate development. It includes examples for entity tables, semantic search, and clean CRUD layers.

Core Features & Use Cases

  • Backend scaffolding for FastAPI, Postgres, and Supabase
  • Declarative CRUD patterns with ID translation and semantic search
  • Secure authentication and role-based access using Supabase Auth and RLS

Quick Start

Start the backend server with the FastAPI app and verify a sample API endpoint.

Frequently Asked Questions about Backend Skill

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

FAQPage Schema
How do I build FastAPI CRUD routes with Supabase and PostgreSQL?

Build FastAPI CRUD routes with Supabase by applying declarative data access patterns and entity table scaffolding. This automates route creation, enforces structured PostgreSQL data models, and provides ID translation for reliable operations.

How does Supabase Row Level Security work with FastAPI authentication?

Supabase Row Level Security integrates with FastAPI by validating JWT tokens through Supabase Auth to enforce role-based access control. This restricts data access directly at the PostgreSQL database layer through secure RLS policies.

Can I implement semantic search in a FastAPI backend using Supabase?

Implement semantic search in a FastAPI backend using Supabase by adding embedding columns to your PostgreSQL entity tables. This supports advanced semantic search queries directly within your declarative CRUD data access layers.

What is the best way to scaffold a secure FastAPI backend?

Scaffold a secure FastAPI backend using structured patterns for CRUD operations, JWT authentication, and Supabase RLS. This provides clean data models, secure role-based access, and reliable API design out of the box.

Do I need PostgreSQL to use Supabase Auth and RLS with FastAPI?

Yes, PostgreSQL is required to use Supabase Auth and RLS with FastAPI. Supabase provides the underlying PostgreSQL database layer needed to enforce Row Level Security policies and manage entity tables for your API.