lb-supabase-skill

{
  "meta": {
    "document_id": "ssds:auto:supabase:0.1.0",
    "ssds_version": "0.2.0",
    "scanner_version": "0.4.0+fe6fd9123d50",
    "created_at": "2026-03-05T02:13:27.123Z",
    "created_by": {
      "agent": "safeagentskills-cli/generate-ssds"
    },
    "language": "en",
    "notes": "Auto-generated SSDS. Manual review recommended."
  },
  "skill": {
    "name": "lb-supabase-skill",
    "version": "0.1.0",
    "format": "agent_skill",
    "description": "Complete Supabase platform documentation. Use when working with Supabase - covers authentication (email, OAuth, magic links, phone, SSO), database (PostgreSQL, RLS, migrations), storage (file uploads, CDN), edge functions, realtime subscriptions, AI/embeddings, cron jobs, queues, and platform management. Includes framework integrations (Next.js, React, SvelteKit, etc.).",
    "publisher": "ClawHub",
    "source": {
      "channel": "local"
    },
    "artifact": {
      "sha256": "067e80c389a2c847e2fe33abc99358a79902b4df6f7720c3ff545360112c7e8b",
      "hash_method": "files_sorted"
    }
  },
  "capabilities": {
    "execution": {
      "can_exec_shell": true,
      "can_exec_code": false,
      "privilege_level": "admin",
      "can_install_deps": false,
      "can_persist": true
    },
    "filesystem": {
      "reads_workspace": true,
      "reads_user_home": true,
      "reads_system": false,
      "writes_workspace": true,
      "writes_user_home": true,
      "writes_system": true,
      "can_delete": true
    },
    "network": {
      "egress": "any",
      "ingress": true
    },
    "credentials": {
      "reads_env_vars": true,
      "reads_credential_files": true,
      "reads_browser_data": true,
      "reads_keychain": true
    },
    "services": [
      {
        "service": "email",
        "operations": [
          "read",
          "write"
        ]
      },
      {
        "service": "messaging",
        "operations": [
          "read",
          "write"
        ]
      }
    ],
    "actions": {
      "can_send_messages": true,
      "can_post_public": true,
      "can_purchase": true,
      "can_transfer_money": false,
      "can_deploy": false,
      "can_delete_external": true
    },
    "prompt_injection_surfaces": [
      "web",
      "documents"
    ],
    "content_types": [
      "general"
    ]
  },
  "hazards": {
    "hdac": {
      "H": 4,
      "D": 4,
      "A": 4,
      "C": 1
    },
    "flags": [
      "EXEC",
      "PRIVILEGED",
      "PERSISTENCE",
      "FS_READ_WORKSPACE",
      "FS_READ_USER",
      "FS_WRITE_WORKSPACE",
      "FS_WRITE_USER",
      "FS_WRITE_SYSTEM",
      "FS_DELETE",
      "NET_EGRESS_ANY",
      "NET_INGRESS",
      "CREDS_ENV",
      "CREDS_FILES",
      "CREDS_BROWSER",
      "CREDS_KEYCHAIN",
      "ACT_SEND_MESSAGE",
      "ACT_POST_PUBLIC",
      "ACT_PURCHASE",
      "ACT_DELETE_EXTERNAL",
      "PI_WEB",
      "PI_DOCUMENTS"
    ],
    "custom_flags": [
      {
        "code": "SECURITY_BYPASS",
        "name": "Security Bypass",
        "description": "Attempts to disable security features in: references/guides/auth/auth-hooks.mdx, references/guides/auth/signing-keys.mdx, references/guides/platform/multi-factor-authentication.mdx, references/guides/platform/privatelink.mdx, references/guides/security/hipaa-compliance.mdx, references/troubleshooting/rls-performance-and-best-practices-Z5Jjwv.mdx"
      },
      {
        "code": "CRED_CLOUD",
        "name": "Cloud Credential Access",
        "description": "Accesses cloud credentials (AWS/GCP/Azure) in: references/guides/ai/examples/semantic-image-search-amazon-titan.mdx, references/guides/ai/integrations/amazon-bedrock.mdx, references/guides/functions/examples/amazon-bedrock-image-generator.mdx, references/guides/storage/s3/authentication.mdx, references/troubleshooting/get-detailed-storage-metrics-with-the-aws-cli-587a7d.mdx"
      },
      {
        "code": "CRED_KEYCHAIN",
        "name": "Keychain Access",
        "description": "Accesses system keychain in: references/guides/platform/multi-factor-authentication.mdx"
      },
      {
        "code": "OBFUSCATED_CODE",
        "name": "Obfuscated Code",
        "description": "Contains obfuscated code patterns in: references/guides/auth/oauth-server/oauth-flows.mdx, references/guides/auth/social-login/auth-google.mdx"
      },
      {
        "code": "HARDCODED_SECRET",
        "name": "Hardcoded Secrets",
        "description": "Contains hardcoded secrets/API keys in: references/guides/ai/google-colab.mdx, references/guides/database/connecting-to-postgres.mdx, references/guides/database/connecting-to-postgres/serverless-drivers.mdx, references/guides/database/import-data.mdx, references/guides/database/prisma.mdx, references/guides/deployment/branching/github-integration.mdx, references/guides/getting-started/quickstarts/laravel.mdx, references/guides/getting-started/quickstarts/redwoodjs.mdx, references/guides/getting-started/quickstarts/ruby-on-rails.mdx, references/guides/platform/migrating-to-supabase/amazon-rds.mdx, references/guides/platform/migrating-to-supabase/mssql.mdx, references/guides/platform/migrating-to-supabase/mysql.mdx, references/guides/platform/migrating-to-supabase/vercel-postgres.mdx, references/guides/self-hosting/docker.mdx, references/troubleshooting/disabling-prepared-statements-qL8lEL.mdx, references/troubleshooting/how-do-i-update-connection-pool-settings-in-my-dashboard-wAxTJ_.mdx, references/troubleshooting/prisma-error-management-Cm5P_o.mdx, references/troubleshooting/supavisor-and-connection-terminology-explained-9pr_ZO.mdx, references/troubleshooting/supavisor-faq-YyP5tI.mdx, references/troubleshooting/using-sqlalchemy-with-supabase-FUqebT.mdx, references/guides/functions/examples/slack-bot-mention.mdx"
      },
      {
        "code": "PROMPT_INJECTION",
        "name": "Prompt Injection Risk",
        "description": "Contains prompt injection patterns in: references/guides/ai/automatic-embeddings.mdx, references/guides/auth/third-party/aws-cognito.mdx, references/guides/getting-started/mcp.mdx, references/guides/self-hosting/docker.mdx, references/troubleshooting/insufficient-privilege-when-accessing-pgstatstatements-e5M_EQ.mdx"
      },
      {
        "code": "HIDDEN_INSTRUCTIONS",
        "name": "Hidden Instructions",
        "description": "Contains hidden instructions in comments/invisible chars in: references/guides/telemetry/logs.mdx"
      },
      {
        "code": "PERSISTENCE",
        "name": "Persistence Mechanism",
        "description": "Creates scheduled tasks or startup entries in: references/guides/auth/auth-hooks/send-email-hook.mdx, references/guides/auth/auth-hooks/send-sms-hook.mdx, references/_partials/postgres_installation.mdx"
      },
      {
        "code": "PRIVILEGE_ESCALATION",
        "name": "Privilege Escalation",
        "description": "Uses elevated privileges (sudo/root) in: references/guides/local-development/cli/getting-started.mdx, references/guides/platform/migrating-to-supabase/postgres.mdx, references/troubleshooting/avoiding-timeouts-in-long-running-queries-6nmbdN.mdx, references/troubleshooting/increase-vector-lookup-speeds-by-applying-an-hsnw-index-ohLHUM.mdx, references/guides/database/extensions/pgtap.mdx"
      },
      {
        "code": "FILE_DELETE",
        "name": "File Deletion",
        "description": "Can delete files in: references/guides/auth/auth-identity-linking.mdx, references/guides/auth/auth-mfa.mdx, references/guides/self-hosting/docker.mdx, references/troubleshooting/how-to-delete-vercel-linked-projects-9d08aa.mdx"
      },
      {
        "code": "NET_INGRESS",
        "name": "Network Server",
        "description": "Listens for incoming connections in: references/guides/auth/server-side/creating-a-client.mdx, references/guides/functions/examples/mcp-server-mcp-lite.mdx, references/guides/functions/routing.mdx, references/guides/functions/websockets.mdx, references/guides/getting-started/byo-mcp.mdx, references/guides/getting-started/quickstarts/flask.mdx"
      },
      {
        "code": "TOOL_ABUSE",
        "name": "Unauthorized Tool Use",
        "description": "INSTRUCTED_BINARY_INSTALL, MCP_SYS_PERMISSION_MANIPULATION, INSTRUCTED_GIT_CLONE_AND_BUILD, MCP_SYS_FILE_DESTRUCTION, TOOL_ABUSE_SYSTEM_PACKAGE_INSTALL: Instructs agent to install external binary or package"
      },
      {
        "code": "SOCIAL_ENGINEERING",
        "name": "Social Engineering Risk",
        "description": "SOCIAL_ENG_VAGUE_DESCRIPTION: Skill description is too vague or missing"
      },
      {
        "code": "COMMAND_INJECTION",
        "name": "Command Injection Risk",
        "description": "TIRITH_DOTFILE_OVERWRITE, MCP_SCRIPT_TAGS, MCP_SQL_BLIND, TIRITH_INSECURE_TLS, MCP_CMD_DANGEROUS_SYSTEM: Redirecting output to home directory dotfiles (shell config, SSH keys, etc.)"
      },
      {
        "code": "TOOL_POISONING",
        "name": "Tool Poisoning",
        "description": "Hidden secondary behavior detected: MCP_TOOL_POISONING_SENSITIVE_DATA, MCP_TOOL_POISONING_REMOTE_STORAGE, MCP_TOOL_POISONING_DECEPTION, MCP_TOOL_POISONING_HIDDEN_ACTIONS"
      },
      {
        "code": "DATA_EXFILTRATION",
        "name": "Data Exfiltration Risk",
        "description": "MCP_EXFIL_EXTERNAL_UPLOAD, MCP_EXFIL_CONVERSATION: Description mentions uploading data to external servers"
      }
    ],
    "confidence": {
      "level": "medium",
      "basis": [
        "static_analysis"
      ],
      "notes": "Detected 16 security patterns (153 vendored rule hits). Review recommended."
    },
    "rationale": {
      "H": "H4: Critical: Privilege escalation or malware detected",
      "D": "D4: Critical: Credential theft or data exfiltration",
      "A": "A4: External actions (deploy/message/post)",
      "C": "C1: General content"
    }
  },
  "containment": {
    "level": "maximum",
    "required": [
      {
        "control": "APPROVE_SEND",
        "reason": "Can send messages"
      },
      {
        "control": "APPROVE_POST",
        "reason": "Can post publicly"
      },
      {
        "control": "APPROVE_PURCHASE",
        "reason": "Financial actions possible"
      },
      {
        "control": "SANDBOX_CONTAINER",
        "reason": "Code execution capability"
      }
    ],
    "recommended": [
      {
        "control": "LOG_ACTIONS",
        "reason": "Audit trail for all actions"
      }
    ],
    "uncontained_risk": "Risk level depends on manual review of actual capabilities."
  },
  "risks": {
    "risks": [
      {
        "risk": "Security bypass pattern detected in: references/guides/auth/auth-hooks.mdx, references/guides/auth/signing-keys.mdx, references/guides/platform/multi-factor-authentication.mdx, references/guides/platform/privatelink.mdx, references/guides/security/hipaa-compliance.mdx, references/troubleshooting/rls-performance-and-best-practices-Z5Jjwv.mdx",
        "severity": "critical",
        "mitigation": "This skill attempts to disable security features. Do not use."
      },
      {
        "risk": "Cloud credential access patterns in: references/guides/ai/examples/semantic-image-search-amazon-titan.mdx, references/guides/ai/integrations/amazon-bedrock.mdx, references/guides/functions/examples/amazon-bedrock-image-generator.mdx, references/guides/storage/s3/authentication.mdx, references/troubleshooting/get-detailed-storage-metrics-with-the-aws-cli-587a7d.mdx",
        "severity": "high",
        "mitigation": "Verify legitimate need for cloud credential access."
      },
      {
        "risk": "Keychain/credential store access in: references/guides/platform/multi-factor-authentication.mdx",
        "severity": "high",
        "mitigation": "Block keychain access or use isolated environment."
      },
      {
        "risk": "Hardcoded secrets detected in: references/guides/ai/google-colab.mdx, references/guides/database/connecting-to-postgres.mdx, references/guides/database/connecting-to-postgres/serverless-drivers.mdx, references/guides/database/import-data.mdx, references/guides/database/prisma.mdx, references/guides/deployment/branching/github-integration.mdx, references/guides/getting-started/quickstarts/laravel.mdx, references/guides/getting-started/quickstarts/redwoodjs.mdx, references/guides/getting-started/quickstarts/ruby-on-rails.mdx, references/guides/platform/migrating-to-supabase/amazon-rds.mdx, references/guides/platform/migrating-to-supabase/mssql.mdx, references/guides/platform/migrating-to-supabase/mysql.mdx, references/guides/platform/migrating-to-supabase/vercel-postgres.mdx, references/guides/self-hosting/docker.mdx, references/troubleshooting/disabling-prepared-statements-qL8lEL.mdx, references/troubleshooting/how-do-i-update-connection-pool-settings-in-my-dashboard-wAxTJ_.mdx, references/troubleshooting/prisma-error-management-Cm5P_o.mdx, references/troubleshooting/supavisor-and-connection-terminology-explained-9pr_ZO.mdx, references/troubleshooting/supavisor-faq-YyP5tI.mdx, references/troubleshooting/using-sqlalchemy-with-supabase-FUqebT.mdx, references/guides/functions/examples/slack-bot-mention.mdx",
        "severity": "high",
        "mitigation": "Remove hardcoded secrets. Use environment variables instead."
      },
      {
        "risk": "Code obfuscation detected in: references/guides/auth/oauth-server/oauth-flows.mdx, references/guides/auth/social-login/auth-google.mdx",
        "severity": "medium",
        "mitigation": "Deobfuscate and review code before use."
      },
      {
        "risk": "Prompt injection patterns detected in: references/guides/ai/automatic-embeddings.mdx, references/guides/auth/third-party/aws-cognito.mdx, references/guides/getting-started/mcp.mdx, references/guides/self-hosting/docker.mdx, references/troubleshooting/insufficient-privilege-when-accessing-pgstatstatements-e5M_EQ.mdx, references/guides/telemetry/logs.mdx",
        "severity": "high",
        "mitigation": "Review SKILL.md for hidden instructions. Do not use with untrusted input."
      },
      {
        "risk": "Unauthorized tool use: INSTRUCTED_BINARY_INSTALL, MCP_SYS_PERMISSION_MANIPULATION, INSTRUCTED_GIT_CLONE_AND_BUILD, MCP_SYS_FILE_DESTRUCTION, TOOL_ABUSE_SYSTEM_PACKAGE_INSTALL",
        "severity": "critical",
        "mitigation": "Avoid instructing agents to install arbitrary binaries; bundle dependencies or use sandboxed environments"
      },
      {
        "risk": "Command injection risk: TIRITH_DOTFILE_OVERWRITE, MCP_SCRIPT_TAGS, MCP_SQL_BLIND, TIRITH_INSECURE_TLS, MCP_CMD_DANGEROUS_SYSTEM",
        "severity": "critical"
      },
      {
        "risk": "Social engineering indicators: SOCIAL_ENG_VAGUE_DESCRIPTION",
        "severity": "low",
        "mitigation": "Provide clear, detailed description of skill functionality"
      },
      {
        "risk": "Tool poisoning: hidden behaviors detected (MCP_TOOL_POISONING_SENSITIVE_DATA, MCP_TOOL_POISONING_REMOTE_STORAGE, MCP_TOOL_POISONING_DECEPTION, MCP_TOOL_POISONING_HIDDEN_ACTIONS)",
        "severity": "critical",
        "mitigation": "Remove references to sensitive data collection."
      },
      {
        "risk": "Data exfiltration patterns: MCP_EXFIL_EXTERNAL_UPLOAD, MCP_EXFIL_CONVERSATION",
        "severity": "high",
        "mitigation": "Document all external data transfers. Remove suspicious upload references."
      }
    ],
    "limitations": [
      "Static analysis only - runtime behavior not verified"
    ]
  },
  "incident_response": {
    "kill_switch": [
      "Stop the agent process"
    ],
    "containment": [
      "Review logs for unexpected actions"
    ],
    "recovery": [
      "Depends on skill capabilities"
    ]
  },
  "evidence": [
    {
      "evidence_id": "EV:file-1",
      "type": "file_excerpt",
      "title": "_meta.json",
      "file_path": "_meta.json"
    },
    {
      "evidence_id": "EV:file-2",
      "type": "file_excerpt",
      "title": "README.md",
      "file_path": "README.md"
    },
    {
      "evidence_id": "EV:file-3",
      "type": "file_excerpt",
      "title": "references/_partials/_fixtures/hyphenated-variables.mdx",
      "file_path": "references/_partials/_fixtures/hyphenated-variables.mdx"
    },
    {
      "evidence_id": "EV:file-4",
      "type": "file_excerpt",
      "title": "references/_partials/_fixtures/multiple-variables.mdx",
      "file_path": "references/_partials/_fixtures/multiple-variables.mdx"
    },
    {
      "evidence_id": "EV:file-5",
      "type": "file_excerpt",
      "title": "references/_partials/_fixtures/nested1.mdx",
      "file_path": "references/_partials/_fixtures/nested1.mdx"
    },
    {
      "evidence_id": "EV:file-6",
      "type": "file_excerpt",
      "title": "references/_partials/_fixtures/nested2.mdx",
      "file_path": "references/_partials/_fixtures/nested2.mdx"
    },
    {
      "evidence_id": "EV:file-7",
      "type": "file_excerpt",
      "title": "references/_partials/_fixtures/test.mdx",
      "file_path": "references/_partials/_fixtures/test.mdx"
    },
    {
      "evidence_id": "EV:file-8",
      "type": "file_excerpt",
      "title": "references/_partials/_fixtures/variables.mdx",
      "file_path": "references/_partials/_fixtures/variables.mdx"
    },
    {
      "evidence_id": "EV:file-9",
      "type": "file_excerpt",
      "title": "references/_partials/ai/quickstart_hf_deployment.mdx",
      "file_path": "references/_partials/ai/quickstart_hf_deployment.mdx"
    },
    {
      "evidence_id": "EV:file-10",
      "type": "file_excerpt",
      "title": "references/_partials/api_rate_limits.mdx",
      "file_path": "references/_partials/api_rate_limits.mdx"
    },
    {
      "evidence_id": "EV:cisco-1",
      "type": "file_excerpt",
      "title": "INSTRUCTED_BINARY_INSTALL [HIGH] references/_partials/postgres_installation.mdx:85: brew install postgresql@17",
      "file_path": "references/_partials/postgres_installation.mdx"
    },
    {
      "evidence_id": "EV:cisco-2",
      "type": "file_excerpt",
      "title": "TIRITH_DOTFILE_OVERWRITE [HIGH] references/_partials/postgres_installation.mdx:115: echo 'export PATH=\"/opt/homebrew/opt/postgresql@17/bin:$PATH\"' >> ~/.zshrc",
      "file_path": "references/_partials/postgres_installation.mdx"
    },
    {
      "evidence_id": "EV:cisco-3",
      "type": "file_excerpt",
      "title": "MCP_EXFIL_EXTERNAL_UPLOAD [HIGH] references/_partials/quickstart_db_setup.mdx:20: curl -X POST https://api.supabase.com/v1/projects \\",
      "file_path": "references/_partials/quickstart_db_setup.mdx"
    },
    {
      "evidence_id": "EV:cisco-4",
      "type": "file_excerpt",
      "title": "INSTRUCTED_BINARY_INSTALL [HIGH] references/guides/ai/examples/image-search-openai-clip.mdx:22: pip install poetry",
      "file_path": "references/guides/ai/examples/image-search-openai-clip.mdx"
    },
    {
      "evidence_id": "EV:cisco-5",
      "type": "file_excerpt",
      "title": "SECRET_CONNECTION_STRING [HIGH] references/guides/ai/examples/image-search-openai-clip.mdx:70: DB_CONNECTION = \"postgresql://postgres:postgres@localhost:54322/postgres\"",
      "file_path": "references/guides/ai/examples/image-search-openai-clip.mdx"
    },
    {
      "evidence_id": "EV:cisco-6",
      "type": "file_excerpt",
      "title": "INSTRUCTED_BINARY_INSTALL [HIGH] references/guides/ai/examples/mixpeek-video-search.mdx:20: pip install poetry",
      "file_path": "references/guides/ai/examples/mixpeek-video-search.mdx"
    },
    {
      "evidence_id": "EV:cisco-7",
      "type": "file_excerpt",
      "title": "MCP_EXFIL_EXTERNAL_UPLOAD [HIGH] references/guides/ai/examples/openai.mdx:85: curl -i --location --request POST http://localhost:54321/functions/v1/openai \\",
      "file_path": "references/guides/ai/examples/openai.mdx"
    },
    {
      "evidence_id": "EV:cisco-8",
      "type": "file_excerpt",
      "title": "INSTRUCTED_BINARY_INSTALL [HIGH] references/guides/ai/examples/semantic-image-search-amazon-titan.mdx:22: pip install poetry",
      "file_path": "references/guides/ai/examples/semantic-image-search-amazon-titan.mdx"
    },
    {
      "evidence_id": "EV:cisco-9",
      "type": "file_excerpt",
      "title": "SECRET_CONNECTION_STRING [HIGH] references/guides/ai/examples/semantic-image-search-amazon-titan.mdx:40: postgresql://postgres.[PROJECT-REF]:[YOUR-PASSWORD]@aws-0-[REGION].pooler.supaba",
      "file_path": "references/guides/ai/examples/semantic-image-search-amazon-titan.mdx"
    },
    {
      "evidence_id": "EV:cisco-10",
      "type": "file_excerpt",
      "title": "INSTRUCTED_BINARY_INSTALL [HIGH] references/guides/ai/google-colab.mdx:33: pip install vecs",
      "file_path": "references/guides/ai/google-colab.mdx"
    }
  ]
}