lb-drizzle-skill

· v0.1.0

High Risk

Complete Drizzle ORM documentation in markdown format. Use when working with Drizzle ORM - covers schema definition, queries, migrations, database connections (PostgreSQL, MySQL, SQLite), integrations (Neon, Supabase, PlanetScale, Cloudflare D1, Turso), column types, relations, transactions, and framework usage (Next.js, SvelteKit, Astro).

H:4 D:3 A:3 C:1

⚠️ Hazard Flags

FS_READ_USER NET_EGRESS_ANY NET_INGRESS CREDS_ENV CREDS_FILES ACT_DEPLOY ACT_DELETE_EXTERNAL PI_WEB

📋 Capabilities

Execution

❌ Shell execution
❌ Code execution
❌ Install dependencies
❌ Persistence
Privilege: user

Filesystem

❌ Read workspace
❌ Write workspace
✅ Read home
❌ Write home
❌ Read system
❌ Delete

Network

Egress: any
✅ Ingress

Credentials

✅ Environment vars
✅ Credential files
❌ Browser data
❌ Keychain

Actions

❌ send messages❌ post public❌ purchase❌ transfer money✅ deploy✅ delete external

🔒 Containment

Level: maximum

Recommended:

LOG_ACTIONS: Audit trail for all actions

⚡ Risks

Pipe-to-shell pattern detected (curl|bash) in: references/tutorials/drizzle-with-frameworks/drizzle-with-encore.mdx critical

Mitigation: Do not execute. Review source for malicious intent.

Hardcoded secrets detected in: references/connect-drizzle-proxy.mdx, references/drizzle-config-file.mdx, references/guides/mysql-local-setup.mdx, references/guides/postgresql-local-setup.mdx, references/latest-releases/drizzle-orm-v0110.mdx, references/read-replicas.mdx, references/tutorials/drizzle-on-the-edge/drizzle-with-netlify-edge-functions-neon.mdx, references/tutorials/drizzle-on-the-edge/drizzle-with-vercel-edge-functions.mdx, references/tutorials/drizzle-with-db/drizzle-with-neon.mdx, references/tutorials/drizzle-with-db/drizzle-with-nile.mdx, references/tutorials/drizzle-with-frameworks/drizzle-nextjs-neon.mdx high

Mitigation: Remove hardcoded secrets. Use environment variables instead.

Unauthorized tool use: INSTRUCTED_BINARY_INSTALL high

Mitigation: Avoid instructing agents to install arbitrary binaries; bundle dependencies or use sandboxed environments

Command injection risk: MCP_SQL_BLIND, MCP_SQL_TAUTOLOGY critical

Mitigation: Remove SQL exploitation patterns.

Social engineering indicators: SOCIAL_ENG_VAGUE_DESCRIPTION low

Mitigation: Provide clear, detailed description of skill functionality

Want a deeper analysis?

This report was generated by static analysis. Get an LLM-powered deep review with behavioral reasoning and attack surface mapping.

🧠 Deep Analysis — $5.00

🚨 Incident Response

Kill switch: Stop the agent process

Containment: Review logs for unexpected actions

Recovery: Depends on skill capabilities

📄 Raw SSDS JSON click to expand

{
  "meta": {
    "document_id": "ssds:auto:drizzle:0.1.0",
    "ssds_version": "0.2.0",
    "scanner_version": "0.4.0+fe6fd9123d50",
    "created_at": "2026-03-05T02:13:15.923Z",
    "created_by": {
      "agent": "safeagentskills-cli/generate-ssds"
    },
    "language": "en",
    "notes": "Auto-generated SSDS. Manual review recommended."
  },
  "skill": {
    "name": "lb-drizzle-skill",
    "version": "0.1.0",
    "format": "agent_skill",
    "description": "Complete Drizzle ORM documentation in markdown format. Use when working with Drizzle ORM - covers schema definition, queries, migrations, database connections (PostgreSQL, MySQL, SQLite), integrations (Neon, Supabase, PlanetScale, Cloudflare D1, Turso), column types, relations, transactions, and framework usage (Next.js, SvelteKit, Astro).",
    "publisher": "ClawHub",
    "source": {
      "channel": "local"
    },
    "artifact": {
      "sha256": "3a15511e57995b86b09413a0c137f78c0449a08ccf0df5e0f85e49fae12bf131",
      "hash_method": "files_sorted"
    }
  },
  "capabilities": {
    "execution": {
      "can_exec_shell": false,
      "can_exec_code": false,
      "privilege_level": "user",
      "can_install_deps": false,
      "can_persist": false
    },
    "filesystem": {
      "reads_workspace": false,
      "reads_user_home": true,
      "reads_system": false,
      "writes_workspace": false,
      "writes_user_home": false,
      "writes_system": false,
      "can_delete": false
    },
    "network": {
      "egress": "any",
      "ingress": true
    },
    "credentials": {
      "reads_env_vars": true,
      "reads_credential_files": true,
      "reads_browser_data": false,
      "reads_keychain": false
    },
    "services": [],
    "actions": {
      "can_send_messages": false,
      "can_post_public": false,
      "can_purchase": false,
      "can_transfer_money": false,
      "can_deploy": true,
      "can_delete_external": true
    },
    "prompt_injection_surfaces": [
      "web"
    ],
    "content_types": [
      "general"
    ]
  },
  "hazards": {
    "hdac": {
      "H": 4,
      "D": 3,
      "A": 3,
      "C": 1
    },
    "flags": [
      "FS_READ_USER",
      "NET_EGRESS_ANY",
      "NET_INGRESS",
      "CREDS_ENV",
      "CREDS_FILES",
      "ACT_DEPLOY",
      "ACT_DELETE_EXTERNAL",
      "PI_WEB"
    ],
    "custom_flags": [
      {
        "code": "PIPE_TO_SHELL",
        "name": "Pipe to Shell",
        "description": "Downloads and executes remote code (curl|bash pattern) in: references/tutorials/drizzle-with-frameworks/drizzle-with-encore.mdx"
      },
      {
        "code": "HARDCODED_SECRET",
        "name": "Hardcoded Secrets",
        "description": "Contains hardcoded secrets/API keys in: references/connect-drizzle-proxy.mdx, references/drizzle-config-file.mdx, references/guides/mysql-local-setup.mdx, references/guides/postgresql-local-setup.mdx, references/latest-releases/drizzle-orm-v0110.mdx, references/read-replicas.mdx, references/tutorials/drizzle-on-the-edge/drizzle-with-netlify-edge-functions-neon.mdx, references/tutorials/drizzle-on-the-edge/drizzle-with-vercel-edge-functions.mdx, references/tutorials/drizzle-with-db/drizzle-with-neon.mdx, references/tutorials/drizzle-with-db/drizzle-with-nile.mdx, references/tutorials/drizzle-with-frameworks/drizzle-nextjs-neon.mdx"
      },
      {
        "code": "NET_INGRESS",
        "name": "Network Server",
        "description": "Listens for incoming connections in: references/connect-drizzle-proxy.mdx, references/graphql.mdx, references/tutorials/drizzle-with-db/drizzle-with-nile.mdx"
      },
      {
        "code": "DEPLOY_CAPABILITY",
        "name": "Deploy Capability",
        "description": "Can deploy to external services in: references/tutorials/drizzle-on-the-edge/drizzle-with-netlify-edge-functions-neon.mdx, references/tutorials/drizzle-on-the-edge/drizzle-with-netlify-edge-functions-supabase.mdx"
      },
      {
        "code": "TOOL_ABUSE",
        "name": "Unauthorized Tool Use",
        "description": "INSTRUCTED_BINARY_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": "MCP_SQL_BLIND, MCP_SQL_TAUTOLOGY: Blind SQL injection, system table access, or stored procedure abuse"
      }
    ],
    "confidence": {
      "level": "medium",
      "basis": [
        "static_analysis"
      ],
      "notes": "Detected 7 security patterns (31 vendored rule hits). Review recommended."
    },
    "rationale": {
      "H": "H4: Critical: Privilege escalation or malware detected",
      "D": "D3: Credential access detected",
      "A": "A3: External actions (deploy/message/post)",
      "C": "C1: General content"
    }
  },
  "containment": {
    "level": "maximum",
    "required": [],
    "recommended": [
      {
        "control": "LOG_ACTIONS",
        "reason": "Audit trail for all actions"
      }
    ],
    "uncontained_risk": "Risk level depends on manual review of actual capabilities."
  },
  "risks": {
    "risks": [
      {
        "risk": "Pipe-to-shell pattern detected (curl|bash) in: references/tutorials/drizzle-with-frameworks/drizzle-with-encore.mdx",
        "severity": "critical",
        "mitigation": "Do not execute. Review source for malicious intent."
      },
      {
        "risk": "Hardcoded secrets detected in: references/connect-drizzle-proxy.mdx, references/drizzle-config-file.mdx, references/guides/mysql-local-setup.mdx, references/guides/postgresql-local-setup.mdx, references/latest-releases/drizzle-orm-v0110.mdx, references/read-replicas.mdx, references/tutorials/drizzle-on-the-edge/drizzle-with-netlify-edge-functions-neon.mdx, references/tutorials/drizzle-on-the-edge/drizzle-with-vercel-edge-functions.mdx, references/tutorials/drizzle-with-db/drizzle-with-neon.mdx, references/tutorials/drizzle-with-db/drizzle-with-nile.mdx, references/tutorials/drizzle-with-frameworks/drizzle-nextjs-neon.mdx",
        "severity": "high",
        "mitigation": "Remove hardcoded secrets. Use environment variables instead."
      },
      {
        "risk": "Unauthorized tool use: INSTRUCTED_BINARY_INSTALL",
        "severity": "high",
        "mitigation": "Avoid instructing agents to install arbitrary binaries; bundle dependencies or use sandboxed environments"
      },
      {
        "risk": "Command injection risk: MCP_SQL_BLIND, MCP_SQL_TAUTOLOGY",
        "severity": "critical",
        "mitigation": "Remove SQL exploitation patterns."
      },
      {
        "risk": "Social engineering indicators: SOCIAL_ENG_VAGUE_DESCRIPTION",
        "severity": "low",
        "mitigation": "Provide clear, detailed description of skill functionality"
      }
    ],
    "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/_meta.json",
      "file_path": "references/_meta.json"
    },
    {
      "evidence_id": "EV:file-4",
      "type": "file_excerpt",
      "title": "references/arktype.mdx",
      "file_path": "references/arktype.mdx"
    },
    {
      "evidence_id": "EV:file-5",
      "type": "file_excerpt",
      "title": "references/batch-api.mdx",
      "file_path": "references/batch-api.mdx"
    },
    {
      "evidence_id": "EV:file-6",
      "type": "file_excerpt",
      "title": "references/cache.mdx",
      "file_path": "references/cache.mdx"
    },
    {
      "evidence_id": "EV:file-7",
      "type": "file_excerpt",
      "title": "references/column-types/_meta.json",
      "file_path": "references/column-types/_meta.json"
    },
    {
      "evidence_id": "EV:file-8",
      "type": "file_excerpt",
      "title": "references/column-types/cockroach.mdx",
      "file_path": "references/column-types/cockroach.mdx"
    },
    {
      "evidence_id": "EV:file-9",
      "type": "file_excerpt",
      "title": "references/column-types/mssql.mdx",
      "file_path": "references/column-types/mssql.mdx"
    },
    {
      "evidence_id": "EV:file-10",
      "type": "file_excerpt",
      "title": "references/column-types/mysql.mdx",
      "file_path": "references/column-types/mysql.mdx"
    },
    {
      "evidence_id": "EV:cisco-1",
      "type": "file_excerpt",
      "title": "SECRET_CONNECTION_STRING [HIGH] references/connect-drizzle-proxy.mdx:84: const client = new Client('postgres://postgres:postgres@localhost:5432/postgres'",
      "file_path": "references/connect-drizzle-proxy.mdx"
    },
    {
      "evidence_id": "EV:cisco-2",
      "type": "file_excerpt",
      "title": "SECRET_CONNECTION_STRING [HIGH] references/connect-overview.mdx:127: postgresql://alex:[email protected]/dbna",
      "file_path": "references/connect-overview.mdx"
    },
    {
      "evidence_id": "EV:cisco-3",
      "type": "file_excerpt",
      "title": "SECRET_CONNECTION_STRING [HIGH] references/connect-planetscale-postgres.mdx:138: {`postgresql://{username}:{password}@{host}:{port}/postgres?sslmode=verify-full`",
      "file_path": "references/connect-planetscale-postgres.mdx"
    },
    {
      "evidence_id": "EV:cisco-4",
      "type": "file_excerpt",
      "title": "SECRET_CONNECTION_STRING [HIGH] references/drizzle-config-file.mdx:248: url: \"postgres://user:password@host:port/db\",",
      "file_path": "references/drizzle-config-file.mdx"
    },
    {
      "evidence_id": "EV:cisco-5",
      "type": "file_excerpt",
      "title": "SECRET_CONNECTION_STRING [HIGH] references/drizzle-kit-migrate.mdx:68: url: \"postgresql://user:password@host:port/dbname\"",
      "file_path": "references/drizzle-kit-migrate.mdx"
    },
    {
      "evidence_id": "EV:cisco-6",
      "type": "file_excerpt",
      "title": "SECRET_CONNECTION_STRING [HIGH] references/drizzle-kit-pull.mdx:77: url: \"postgresql://user:password@host:port/dbname\",",
      "file_path": "references/drizzle-kit-pull.mdx"
    },
    {
      "evidence_id": "EV:cisco-7",
      "type": "file_excerpt",
      "title": "SECRET_CONNECTION_STRING [HIGH] references/drizzle-kit-push.mdx:87: url: \"postgresql://user:password@host:port/dbname\",",
      "file_path": "references/drizzle-kit-push.mdx"
    },
    {
      "evidence_id": "EV:cisco-8",
      "type": "file_excerpt",
      "title": "SECRET_CONNECTION_STRING [HIGH] references/drizzle-kit-studio.mdx:30: url: \"postgresql://user:password@host:port/dbname\"",
      "file_path": "references/drizzle-kit-studio.mdx"
    },
    {
      "evidence_id": "EV:cisco-9",
      "type": "file_excerpt",
      "title": "SECRET_CONNECTION_STRING [HIGH] references/get-started/planetscale-postgres-existing.mdx:52: DATABASE_URL=postgresql://{username}:{password}@{host}:{port}/postgres?sslmode=v",
      "file_path": "references/get-started/planetscale-postgres-existing.mdx"
    },
    {
      "evidence_id": "EV:cisco-10",
      "type": "file_excerpt",
      "title": "SECRET_CONNECTION_STRING [HIGH] references/get-started/planetscale-postgres-new.mdx:49: DATABASE_URL=postgresql://{username}:{password}@{host}:{port}/postgres?sslmode=v",
      "file_path": "references/get-started/planetscale-postgres-new.mdx"
    }
  ]
}