Community Команды Базы данных

Команда supabase-security-audit

Установка
npx claude-code-templates@latest --command database/supabase-security-audit

Описание

supabase-security-audit — slash-команда проверки защищённости Supabase: RLS-анализ — аудит политик построчной безопасности, оценка уязвимостей — поиск слабых мест конфигурации, комплексность — проверка базы целиком. Для разработчиков на Supabase, желающих уверенности, что данные защищены на уровне строк.

Что умеет:
— аудировать RLS-политики;
— оценивать уязвимости базы;
— проверять конфигурацию Supabase;
— запускаться одной командой.

Supabase Security Audit

Conduct comprehensive Supabase security audit with RLS policy analysis and vulnerability assessment: $ARGUMENTS

Current Security Context

  • Supabase access: MCP integration for security analysis and policy review
  • RLS policies: Current Row Level Security implementation and policy effectiveness
  • Auth configuration: !find . -name "*auth*" -o -name "*supabase*" | grep -E "\\.(js|ts|json)$" | head -5 authentication setup
  • API security: Current API key management and access control implementation

Task

Execute comprehensive security audit with vulnerability assessment and policy optimization:

Audit Scope: Use $ARGUMENTS to focus on RLS policies, permission analysis, authentication security, API key management, or comprehensive security review

Security Audit Framework:

  • RLS Policy Analysis – Review Row Level Security policies, test policy effectiveness, identify policy gaps, optimize policy performance
  • Permission Assessment – Analyze table permissions, review role-based access, validate permission hierarchies, identify over-privileged access
  • Authentication Security – Review auth configuration, analyze JWT security, validate session management, assess multi-factor authentication
  • API Key Management – Audit API key usage, review key rotation policies, validate key scoping, assess exposure risks
  • Data Protection – Analyze sensitive data handling, review encryption implementation, validate data masking, assess backup security
  • Vulnerability Scanning – Identify security vulnerabilities, assess injection risks, review CORS configuration, validate rate limiting

Advanced Features: Automated security testing, policy simulation, vulnerability scoring, compliance checking, security monitoring setup.

Compliance Integration: GDPR compliance checking, SOC2 requirements validation, security best practices enforcement, audit trail analysis.

Output: Comprehensive security audit report with vulnerability assessments, policy recommendations, security improvements, and compliance validation.