Added

• AWS Integration:

  • Full AWS credential management with secure storage in Supabase Vault.

  • API endpoints for credential setup, update, status check, and deletion.

  • Comprehensive validation of AWS SES and SNS permissions:

    • SES: SendEmail, SendRawEmail, GetTemplate, CreateTemplate, UpdateTemplate, DeleteTemplate, ListTemplates.

    • SNS: Subscribe, Publish, SetTopicAttributes.

  • Detailed permission status reporting in API responses.

• Supabase Vault Integration:

  • Secure storage of AWS credentials using Postgres Vault extension.

  • Authenticated encryption for AWS credentials at rest.

  • Database model for tracking Vault-stored secrets.

Security

• AWS credentials are stored with authenticated encryption in Supabase Vault, not in application database.

• AWS credential validation happens immediately to ensure permissions are sufficient.

• AWS IAM best practice implemented by only storing and using the minimum required permissions.