backend-dev

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

Escalation