backend-engineer
Supabase integration specialist. Handles database schema, authentication, Row Level Security (RLS), real-time subscriptions, and storage. Connects existing UI to real backend. Only called AFTER UI exists with mock data. Triggers: connect database, connect Supabase, add auth, make login, backend integration, real data, authentication, database schema.
wasintoh · 已有 AI 审核记录
安装与使用
运行命令前先阅读来源与依赖说明。复制命令不会自动安装或执行。
npx skills add wasintoh/toh-framework --skill backend-engineer技能说明
name: backend-engineer description: > Supabase integration specialist. Handles database schema, authentication, Row Level Security (RLS), real-time subscriptions, and storage. Connects existing UI to real backend. Only called AFTER UI exists with mock data. Triggers: connect database, connect Supabase, add auth, make login, backend integration, real data, authentication, database schema.
Backend Engineer
Connect beautiful UI to real data. Supabase-first approach.
<core_principle>
The Integration Promise
Working UI with mock data → Connect Supabase → Real data flows automatically
We DON'T redesign. We DON'T add features. We connect what exists. </core_principle>
<default_to_action> NEVER ask:
- "Which database should I use?" → Supabase (our standard)
- "What's the schema?" → Derive from existing TypeScript types
- "What type of auth do you need?" → Supabase Auth with social providers
ALWAYS do:
- Create Supabase client configuration
- Generate schema from existing types
- Setup RLS policies
- Replace mock API calls with Supabase queries </default_to_action>
<supabase_setup>
Initial Setup
1. Install Dependencies
npm install @supabase/supabase-js
2. Environment Variables
# .env.local
NEXT_PUBLIC_SUPABASE_URL=https://xxxxx.supabase.co
NEXT_PUBLIC_SUPABASE_ANON_KEY=eyJhbGc...
3. Client Configuration
// src/lib/supabase.ts
import { createClient } from '@supabase/supabase-js'
import { Database } from '@/types/supabase'
const supabaseUrl = process.env.NEXT_PUBLIC_SUPABASE_URL!
const supabaseKey = process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY!
export const supabase = createClient<Database>(supabaseUrl, supabaseKey)
4. Type Generation (after creating tables)
npx supabase gen types typescript --project-id xxxxx > src/types/supabase.ts
</supabase_setup>
<schema_patterns>
Database Schema Patterns
Derive from TypeScript Types
// Existing type from dev-engineer
interface Product {
id: string
name: string
description: string
price: number
stock: number
category: string
isActive: boolean
createdAt: Date
updatedAt: Date
}
// Becomes SQL
-- SQL for Supabase
create table products (
id uuid default gen_random_uuid() primary key,
name text not null,
description text,
price decimal(10,2) not null default 0,
stock integer not null default 0,
category text not null,
is_active boolean not null default true,
created_at timestamp with time zone default now(),
updated_at timestamp with time zone default now()
);
-- Auto-update updated_at
create or replace function update_updated_at()
returns trigger as $$
begin
new.updated_at = now();
return new;
end;
$$ language plpgsql;
create trigger products_updated_at
before update on products
for each row execute function update_updated_at();
Common Tables
-- Users (extends Supabase auth.users)
create table profiles (
id uuid references auth.users(id) primary key,
full_name text,
avatar_url text,
role text default 'user',
created_at timestamp with time zone default now(),
updated_at timestamp with time zone default now()
);
-- Auto-create profile on signup
create or replace function handle_new_user()
returns trigger as $$
begin
insert into profiles (id, full_name, avatar_url)
values (
new.id,
new.raw_user_meta_data->>'full_name',
new.raw_user_meta_data->>'avatar_url'
);
return new;
end;
$$ language plpgsql security definer;
create trigger on_auth_user_created
after insert on auth.users
for each row execute function handle_new_user();
</schema_patterns>
<rls_patterns>
Row Level Security (RLS)
Always Enable RLS
-- Enable RLS on all tables
alter table products enable row level security;
alter table profiles enable row level security;
Common Policies
Public Read, Authenticated Write
-- Anyone can view products
create policy "Products are viewable by everyone"
on products for select
using (true);
-- Only authenticated users can insert
create policy "Authenticated users can create products"
on products for insert
to authenticated
with check (true);
-- Only owners can update (if user_id column exists)
create policy "Users can update own products"
on products for update
to authenticated
using (user_id = auth.uid());
User-Owned Data
-- Users can only see their own data
create policy "Users can view own orders"
on orders for select
to authenticated
using (user_id = auth.uid());
create policy "Users can create own orders"
on orders for insert
to authenticated
with check (user_id = auth.uid());
Role-Based Access
-- Admins can do everything
create policy "Admins have full access"
on products for all
to authenticated
using (
exists (
select 1 from profiles
where profiles.id = auth.uid()
and profiles.role = 'admin'
)
);
</rls_patterns>
<auth_patterns>
Authentication
Setup Auth Provider
// src/lib/auth.ts
import { supabase } from './supabase'
export async function signInWithEmail(email: string, password: string) {
const { data, error } = await supabase.auth.signInWithPassword({
email,
password,
})
if (error) throw error
return data
}
export async function signUp(email: string, password: string, fullName: string) {
const { data, error } = await supabase.auth.signUp({
email,
password,
options: {
data: { full_name: fullName }
}
})
if (error) throw error
return data
}
export async function signInWithGoogle() {
const { data, error } = await supabase.auth.signInWithOAuth({
provider: 'google',
options: {
redirectTo: `${window.location.origin}/auth/callback`
}
})
if (error) throw error
return data
}
export async function signInWithLine() {
const { data, error } = await supabase.auth.signInWithOAuth({
provider: 'line' as
阅读完整来源 ↗