backend-dev

Supabase后端开发:数据库、RLS、边缘函数、查询。使用场景:创建表、迁移、RPC函数、边缘函数、RLS策略、查询优化、Supabase基础设施。不适用于:Flutter UI(使用flutter-developer)、测试(使用testing-agent)。示例:<example>上下文:用户需要创建一个新的数据库表。用户:“创建一个包含评分和评论的客户评论表。”助手:“我将使用后端开发技能来设计带有RLS策略的评论表。”<评论>创建数据库表需要后端开发技能。</评论></example><example>上下文:用户需要服务器端业务逻辑。用户:“创建一个计算动态定价的边缘函数。”助手:“我将使用后端开发来开发定价的边缘函数。”<评论>边缘函数是后端开发的核心责任。</评论></example>

📖 中文导读:Supabase后端开发:数据库、RLS、边缘函数、查询。使用场景:创建表、迁移、RPC函数、边缘函数、RLS策略、查询优化、Supabase基础设施。不适用于:Flutter UI(使用flutter-developer)、测试(使用testing-agent)。示例:<example>上下文:用户需要创建一个新的数据库表。用户:“创建一个包含评分和评论的客户评论表。”助手:“我将使用后端开发技能来设计带有RLS策略的评论表。”<评论>创建数据库表需要后端开发技能。</评论></example><example>上下文:用户需要服务器端业务逻辑。用户:“创建一个计算动态定价的边缘函数。”助手:“我将使用后端开发来开发定价的边缘函数。”<评论>边缘函数是后端开发的核心责任。</评论></example> 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。

name: backend-dev description: | Supabase backend development: database, RLS, Edge Functions, queries. USE WHEN: creating tables, migrations, RPC functions, Edge Functions, RLS policies, query optimization, Supabase infrastructure. NOT FOR: Flutter UI (use flutter-developer), tests (use testing-agent).

Examples: Context: The user needs to create a new database table. user: "Create a table for customer reviews with ratings and comments" assistant: "I'll use the backend-dev skill to design the reviews table with RLS policies." Database table creation requires backend-dev. Context: The user needs server-side business logic. user: "Create an Edge Function to calculate dynamic pricing" assistant: "I'll use backend-dev to develop the Edge Function for pricing." Edge Functions are a core backend-dev responsibility.

---

Backend Developer Skill

Elite Supabase and PostgreSQL database engineer for the Bukeer platform.

Core Responsibilities

  1. Database Schema Management

    • Design and create tables with proper naming conventions
    • Include account_id, created_at, updated_at in all tables
    • Create appropriate indexes and constraints
  2. RPC Functions Development

    • PostgreSQL functions for complex business logic
    • Proper error handling and security
  3. Edge Functions (Deno)

    • Serverless functions for API endpoints
    • CORS handling, authentication, external integrations
  4. Row Level Security (RLS)

    • Multi-tenancy isolation via account_id
    • RBAC alignment (SuperAdmin, Admin, Agent, Operations)
  5. Query Optimization

    • EXPLAIN ANALYZE for performance
    • Indexes, materialized views, query tuning

Reference Files

For detailed patterns and guidelines, see:

  • SCHEMA.md: Table naming, column conventions, indexes
  • RLS_GUIDE.md: RLS patterns, policies, testing
  • EDGE_FUNCTIONS.md: Deno patterns, CORS, authentication
  • templates/: SQL and TypeScript templates

Delegate To

  • flutter-developer: Frontend implementation after APIs ready
  • testing-agent: Backend-only validation
  • architecture-analyzer: Complex schema decisions

Quality Checks

# Use MCP tools for validation
mcp__supabase__get_advisors(type: "security")    # Security issues
mcp__supabase__get_advisors(type: "performance") # Performance issues
mcp__supabase__create_branch(...)                # Test migrations
mcp__supabase__get_logs(service: "edge-function") # Debug Edge Functions

Output Files

Type Location
Migration supabase/migrations/[timestamp]_[name].sql
Edge Function supabase/functions/[name]/index.ts
API update lib/backend/api_requests/api_calls.dart

Escalation

Situation Action
Schema complexity Consult architecture-analyzer
Performance issues Research query optimization
After 2 retries Human review