Skip to content

aiskillstore/marketplace / skills/abdullahmalik17/fastapi-mastery

fastapi-mastery

Verified

Comprehensive FastAPI development skill covering REST API creation, routing, request/response handling, validation, authentication, database integration, middleware, and deployment. Use when working with FastAPI projects, building APIs, implementing CRUD operations, setting up authentication/authorization, integrating databases (SQL/NoSQL), adding middleware, handling WebSockets, or deploying FastAPI applications. Triggered by requests involving .py files with FastAPI code, API endpoint creation, Pydantic models, or FastAPI-specific features.

FileKindSize
SKILL.mdskill md4.2 KB
references/01-beginner.mdmarkdown8.9 KB
references/02-intermediate.mdmarkdown16.6 KB
references/03-advanced.mdmarkdown19.7 KB
skill-report.jsonconfig74.8 KB

skill-report.json

View on GitHub
{
  "schema_version": "2.0",
  "meta": {
    "generated_at": "2026-07-07T18:41:44.079Z",
    "slug": "abdullahmalik17-fastapi-mastery",
    "source_url": "https://github.com/AbdullahMalik17/Cloud-Native-AI/tree/main/.claude/skills/fastapi-mastery",
    "source_ref": "main",
    "model": "codex",
    "analysis_version": "3.0.0",
    "source_type": "community",
    "content_hash": "f5d95df54d62050106e7f5f14520b174bcee21af79aa0effdb9826fe63671d27",
    "tree_hash": "35488930254f49be300f386055bc7370e660198d714fa1464ddc1484b5889a8d",
    "provenance": {
      "model_effective": "codex",
      "fallback_chain": [
        {
          "agent": "codex",
          "outcome": "success"
        }
      ],
      "analysis_version": "3.0.0"
    }
  },
  "skill": {
    "name": "fastapi-mastery",
    "description": "Build and improve FastAPI applications with guidance for routing, validation, authentication, databases, middleware, testing, WebSockets, and deployment.",
    "summary": "Progressive FastAPI guidance for building, testing, securing, and deploying Python APIs.",
    "icon": "📦",
    "version": "1.0.1",
    "author": "AbdullahMalik17",
    "license": "MIT",
    "tags": [
      "FastAPI",
      "Python",
      "REST APIs",
      "Pydantic",
      "SQLAlchemy"
    ],
    "supported_tools": [
      "claude",
      "codex",
      "claude-code"
    ],
    "risk_factors": [
      "network",
      "filesystem",
      "env_access",
      "external_commands"
    ],
    "category": "coding"
  },
  "security_audit": {
    "risk_level": "high",
    "is_blocked": false,
    "safe_to_publish": false,
    "analysis_status": "ok",
    "summary": "No prompt injection, hidden command execution, or data-exfiltration intent was found. Most static findings are false positives from Markdown examples, placeholder secrets, test URLs, normal container binds, and database configuration samples. The confirmed risk is unsafe file-upload sample code that writes user-controlled filenames, with additional copy-paste concerns in deployment defaults.",
    "remediation": [
      {
        "issue": "Unsafe upload path construction",
        "suggestion": "Generate server-side filenames, normalize paths, restrict extensions, enforce storage boundaries, and validate downloads before returning files.",
        "severity": "high"
      },
      {
        "issue": "Placeholder secrets and database URLs in examples",
        "suggestion": "Mark placeholder values as non-production and prefer environment or secret-manager examples that do not include reusable passwords.",
        "severity": "medium"
      },
      {
        "issue": "Deployment examples expose broad defaults",
        "suggestion": "Label Docker Compose as local development, avoid publishing database and cache ports by default, and require explicit host and CORS allowlists.",
        "severity": "medium"
      }
    ],
    "risk_factor_evidence": [
      {
        "factor": "network",
        "evidence": [
          {
            "file": "references/02-intermediate.md",
            "line_start": 395,
            "line_end": 395
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 230,
            "line_end": 230
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 236,
            "line_end": 236
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 577,
            "line_end": 577
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 607,
            "line_end": 607
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 628,
            "line_end": 628
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 699,
            "line_end": 699
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 706,
            "line_end": 706
          },
          {
            "file": "SKILL.md",
            "line_start": 31,
            "line_end": 31
          }
        ]
      },
      {
        "factor": "filesystem",
        "evidence": [
          {
            "file": "references/02-intermediate.md",
            "line_start": 518,
            "line_end": 518
          },
          {
            "file": "references/02-intermediate.md",
            "line_start": 526,
            "line_end": 526
          },
          {
            "file": "references/02-intermediate.md",
            "line_start": 543,
            "line_end": 543
          },
          {
            "file": "references/02-intermediate.md",
            "line_start": 519,
            "line_end": 519
          },
          {
            "file": "references/02-intermediate.md",
            "line_start": 527,
            "line_end": 527
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 596,
            "line_end": 596
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 597,
            "line_end": 597
          }
        ]
      },
      {
        "factor": "env_access",
        "evidence": [
          {
            "file": "references/02-intermediate.md",
            "line_start": 184,
            "line_end": 184
          },
          {
            "file": "references/02-intermediate.md",
            "line_start": 187,
            "line_end": 187
          },
          {
            "file": "references/02-intermediate.md",
            "line_start": 285,
            "line_end": 285
          },
          {
            "file": "references/02-intermediate.md",
            "line_start": 286,
            "line_end": 286
          },
          {
            "file": "references/02-intermediate.md",
            "line_start": 593,
            "line_end": 593
          },
          {
            "file": "references/02-intermediate.md",
            "line_start": 615,
            "line_end": 615
          },
          {
            "file": "references/02-intermediate.md",
            "line_start": 31,
            "line_end": 31
          },
          {
            "file": "references/02-intermediate.md",
            "line_start": 57,
            "line_end": 57
          },
          {
            "file": "references/02-intermediate.md",
            "line_start": 99,
            "line_end": 99
          },
          {
            "file": "references/02-intermediate.md",
            "line_start": 594,
            "line_end": 594
          },
          {
            "file": "references/02-intermediate.md",
            "line_start": 616,
            "line_end": 616
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 169,
            "line_end": 169
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 170,
            "line_end": 170
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 348,
            "line_end": 348
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 621,
            "line_end": 621
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 622,
            "line_end": 622
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 667,
            "line_end": 667
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 670,
            "line_end": 670
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 774,
            "line_end": 774
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 81,
            "line_end": 81
          },
          {
            "file": "references/03-advanced.md",
            "line_start": 663,
            "line_end": 663
          }
        ]
      },
      {
        "factor": "external_commands",
        "evidence": [
          {
            "file": "SKILL.md",
            "line_start": 16,
            "line_end": 24
          },
          {
            "file": "SKILL.md",
            "line_start": 24,
            "line_end": 27
          },
          {
            "file": "SKILL.md",
            "line_start": 27,
            "line_end": 29
          },
          {
            "file": "SKILL.md",
            "line_start": 29,
            "line_end": 102
          },
          {
            "file": "SKILL.md",
            "line_start": 102,
            "line_end": 110
          },
          {
            "file": "SKILL.md",
            "line_start": 110,
            "line_end": 114
          },
          {
            "file": "SKILL.md",
            "line_start": 114,
            "line_end": 120
          },
          {
            "file": "SKILL.md",
            "line_start": 120,
            "line_end": 124
          },
          {
            "file": "SKILL.md",
            "line_start": 124,
            "line_end": 129
          },
          {
            "file": "SKILL.md",
            "line_start": 129,
            "line_end": 133
          },
          {
            "file": "SKILL.md",
            "line_start": 133,
            "line_end": 137
          }
        ]
      }
    ],
    "static_findings": [
      {
        "id": "blocker:references/01-beginner.md:331:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/01-beginner.md",
        "line_start": 331,
        "line_end": 331,
        "snippet": "if item_id not in fake_db:"
      },
      {
        "id": "blocker:references/01-beginner.md:347:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/01-beginner.md",
        "line_start": 347,
        "line_end": 347,
        "snippet": "self.item_id = item_id"
      },
      {
        "id": "blocker:references/01-beginner.md:358:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/01-beginner.md",
        "line_start": 358,
        "line_end": 358,
        "snippet": "if item_id not in fake_db:"
      },
      {
        "id": "blocker:references/01-beginner.md:387:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/01-beginner.md",
        "line_start": 387,
        "line_end": 387,
        "snippet": "next_id = 1"
      },
      {
        "id": "blocker:references/01-beginner.md:391:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/01-beginner.md",
        "line_start": 391,
        "line_end": 392,
        "snippet": "global next_id"
      },
      {
        "id": "blocker:references/01-beginner.md:392:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/01-beginner.md",
        "line_start": 392,
        "line_end": 392,
        "snippet": "item_id = next_id"
      },
      {
        "id": "blocker:references/01-beginner.md:394:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/01-beginner.md",
        "line_start": 394,
        "line_end": 394,
        "snippet": "next_id += 1"
      },
      {
        "id": "blocker:references/01-beginner.md:399:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/01-beginner.md",
        "line_start": 399,
        "line_end": 399,
        "snippet": "if item_id not in fake_db:"
      },
      {
        "id": "blocker:references/01-beginner.md:405:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/01-beginner.md",
        "line_start": 405,
        "line_end": 405,
        "snippet": "if item_id not in fake_db:"
      },
      {
        "id": "blocker:references/01-beginner.md:412:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/01-beginner.md",
        "line_start": 412,
        "line_end": 412,
        "snippet": "if item_id not in fake_db:"
      },
      {
        "id": "network:references/02-intermediate.md:395:hardcoded-url",
        "category": "network",
        "severity": "low",
        "pattern": "Hardcoded URL",
        "file": "references/02-intermediate.md",
        "line_start": 395,
        "line_end": 395,
        "snippet": "allow_origins=[\"http://localhost:3000\", \"https://example.com\"],  # Specific origins"
      },
      {
        "id": "filesystem:references/02-intermediate.md:518:python-file-write-append",
        "category": "filesystem",
        "severity": "medium",
        "pattern": "Python file write/append",
        "file": "references/02-intermediate.md",
        "line_start": 518,
        "line_end": 518,
        "snippet": "with open(f\"uploads/{file.filename}\", \"wb\") as buffer:"
      },
      {
        "id": "filesystem:references/02-intermediate.md:526:python-file-write-append",
        "category": "filesystem",
        "severity": "medium",
        "pattern": "Python file write/append",
        "file": "references/02-intermediate.md",
        "line_start": 526,
        "line_end": 526,
        "snippet": "with open(f\"uploads/{file.filename}\", \"wb\") as buffer:"
      },
      {
        "id": "filesystem:references/02-intermediate.md:543:python-file-write-append",
        "category": "filesystem",
        "severity": "medium",
        "pattern": "Python file write/append",
        "file": "references/02-intermediate.md",
        "line_start": 543,
        "line_end": 543,
        "snippet": "with open(f\"uploads/{file.filename}\", \"wb\") as f:"
      },
      {
        "id": "filesystem:references/02-intermediate.md:519:python-shutil-operations",
        "category": "filesystem",
        "severity": "medium",
        "pattern": "Python shutil operations",
        "file": "references/02-intermediate.md",
        "line_start": 519,
        "line_end": 519,
        "snippet": "shutil.copyfileobj(file.file, buffer)"
      },
      {
        "id": "filesystem:references/02-intermediate.md:527:python-shutil-operations",
        "category": "filesystem",
        "severity": "medium",
        "pattern": "Python shutil operations",
        "file": "references/02-intermediate.md",
        "line_start": 527,
        "line_end": 527,
        "snippet": "shutil.copyfileobj(file.file, buffer)"
      },
      {
        "id": "env_access:references/02-intermediate.md:184:database-connection-strings",
        "category": "env_access",
        "severity": "high",
        "pattern": "Database connection strings",
        "file": "references/02-intermediate.md",
        "line_start": 184,
        "line_end": 184,
        "snippet": "SQLALCHEMY_DATABASE_URL = \"postgresql://user:password@localhost/dbname\""
      },
      {
        "id": "env_access:references/02-intermediate.md:187:database-connection-strings",
        "category": "env_access",
        "severity": "high",
        "pattern": "Database connection strings",
        "file": "references/02-intermediate.md",
        "line_start": 187,
        "line_end": 187,
        "snippet": "engine = create_engine(SQLALCHEMY_DATABASE_URL)"
      },
      {
        "id": "env_access:references/02-intermediate.md:285:database-connection-strings",
        "category": "env_access",
        "severity": "high",
        "pattern": "Database connection strings",
        "file": "references/02-intermediate.md",
        "line_start": 285,
        "line_end": 285,
        "snippet": "DATABASE_URL = \"postgresql://user:password@localhost/dbname\""
      },
      {
        "id": "env_access:references/02-intermediate.md:286:database-connection-strings",
        "category": "env_access",
        "severity": "high",
        "pattern": "Database connection strings",
        "file": "references/02-intermediate.md",
        "line_start": 286,
        "line_end": 286,
        "snippet": "database = databases.Database(DATABASE_URL)"
      },
      {
        "id": "env_access:references/02-intermediate.md:593:database-connection-strings",
        "category": "env_access",
        "severity": "high",
        "pattern": "Database connection strings",
        "file": "references/02-intermediate.md",
        "line_start": 593,
        "line_end": 593,
        "snippet": "database_url: str"
      },
      {
        "id": "env_access:references/02-intermediate.md:615:database-connection-strings",
        "category": "env_access",
        "severity": "high",
        "pattern": "Database connection strings",
        "file": "references/02-intermediate.md",
        "line_start": 615,
        "line_end": 615,
        "snippet": "DATABASE_URL=postgresql://user:password@localhost/dbname"
      },
      {
        "id": "env_access:references/02-intermediate.md:31:generic-api-secret-keys",
        "category": "env_access",
        "severity": "high",
        "pattern": "Generic API/secret keys",
        "file": "references/02-intermediate.md",
        "line_start": 31,
        "line_end": 31,
        "snippet": "SECRET_KEY = \"your-secret-key-here\"  # Use environment variable in production"
      },
      {
        "id": "env_access:references/02-intermediate.md:57:generic-api-secret-keys",
        "category": "env_access",
        "severity": "high",
        "pattern": "Generic API/secret keys",
        "file": "references/02-intermediate.md",
        "line_start": 57,
        "line_end": 57,
        "snippet": "encoded_jwt = jwt.encode(to_encode, SECRET_KEY, algorithm=ALGORITHM)"
      },
      {
        "id": "env_access:references/02-intermediate.md:99:generic-api-secret-keys",
        "category": "env_access",
        "severity": "high",
        "pattern": "Generic API/secret keys",
        "file": "references/02-intermediate.md",
        "line_start": 99,
        "line_end": 99,
        "snippet": "payload = jwt.decode(token, SECRET_KEY, algorithms=[ALGORITHM])"
      },
      {
        "id": "env_access:references/02-intermediate.md:594:generic-api-secret-keys",
        "category": "env_access",
        "severity": "high",
        "pattern": "Generic API/secret keys",
        "file": "references/02-intermediate.md",
        "line_start": 594,
        "line_end": 594,
        "snippet": "secret_key: str"
      },
      {
        "id": "env_access:references/02-intermediate.md:616:generic-api-secret-keys",
        "category": "env_access",
        "severity": "high",
        "pattern": "Generic API/secret keys",
        "file": "references/02-intermediate.md",
        "line_start": 616,
        "line_end": 616,
        "snippet": "SECRET_KEY=your-secret-key-here"
      },
      {
        "id": "sensitive:references/02-intermediate.md:599:environment-file-access",
        "category": "sensitive",
        "severity": "high",
        "pattern": "Environment file access",
        "file": "references/02-intermediate.md",
        "line_start": 599,
        "line_end": 599,
        "snippet": "env_file = \".env\""
      },
      {
        "id": "sensitive:references/02-intermediate.md:611:environment-file-access",
        "category": "sensitive",
        "severity": "high",
        "pattern": "Environment file access",
        "file": "references/02-intermediate.md",
        "line_start": 611,
        "line_end": 611,
        "snippet": "**.env file:**"
      },
      {
        "id": "sensitive:references/02-intermediate.md:185:sqlite-database-file",
        "category": "sensitive",
        "severity": "medium",
        "pattern": "SQLite database file",
        "file": "references/02-intermediate.md",
        "line_start": 185,
        "line_end": 185,
        "snippet": "# For SQLite: \"sqlite:///./test.db\""
      },
      {
        "id": "blocker:references/02-intermediate.md:200:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/02-intermediate.md",
        "line_start": 200,
        "line_end": 200,
        "snippet": "id = Column(Integer, primary_key=True, index=True)"
      },
      {
        "id": "blocker:references/02-intermediate.md:205:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/02-intermediate.md",
        "line_start": 205,
        "line_end": 205,
        "snippet": "owner_id = Column(Integer, ForeignKey(\"users.id\"))"
      },
      {
        "id": "blocker:references/02-intermediate.md:212:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/02-intermediate.md",
        "line_start": 212,
        "line_end": 212,
        "snippet": "id = Column(Integer, primary_key=True, index=True)"
      },
      {
        "id": "blocker:references/02-intermediate.md:248:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/02-intermediate.md",
        "line_start": 248,
        "line_end": 248,
        "snippet": "db_item = db.query(DBItem).filter(DBItem.id == item_id).first()"
      },
      {
        "id": "blocker:references/02-intermediate.md:260:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/02-intermediate.md",
        "line_start": 260,
        "line_end": 260,
        "snippet": "db_item = db.query(DBItem).filter(DBItem.id == item_id).first()"
      },
      {
        "id": "blocker:references/02-intermediate.md:271:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/02-intermediate.md",
        "line_start": 271,
        "line_end": 271,
        "snippet": "db_item = db.query(DBItem).filter(DBItem.id == item_id).first()"
      },
      {
        "id": "blocker:references/02-intermediate.md:307:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/02-intermediate.md",
        "line_start": 307,
        "line_end": 307,
        "snippet": "last_record_id = await database.execute(query=query, values=values)"
      },
      {
        "id": "network:references/03-advanced.md:230:hardcoded-url",
        "category": "network",
        "severity": "low",
        "pattern": "Hardcoded URL",
        "file": "references/03-advanced.md",
        "line_start": 230,
        "line_end": 230,
        "snippet": "async with AsyncClient(app=app, base_url=\"http://test\") as ac:"
      },
      {
        "id": "network:references/03-advanced.md:236:hardcoded-url",
        "category": "network",
        "severity": "low",
        "pattern": "Hardcoded URL",
        "file": "references/03-advanced.md",
        "line_start": 236,
        "line_end": 236,
        "snippet": "async with AsyncClient(app=app, base_url=\"http://test\") as ac:"
      },
      {
        "id": "network:references/03-advanced.md:577:hardcoded-ip-address",
        "category": "network",
        "severity": "medium",
        "pattern": "Hardcoded IP address",
        "file": "references/03-advanced.md",
        "line_start": 577,
        "line_end": 577,
        "snippet": "CMD [\"uvicorn\", \"app.main:app\", \"--host\", \"0.0.0.0\", \"--port\", \"8000\"]"
      },
      {
        "id": "network:references/03-advanced.md:607:hardcoded-ip-address",
        "category": "network",
        "severity": "medium",
        "pattern": "Hardcoded IP address",
        "file": "references/03-advanced.md",
        "line_start": 607,
        "line_end": 607,
        "snippet": "CMD [\"uvicorn\", \"app.main:app\", \"--host\", \"0.0.0.0\", \"--port\", \"8000\"]"
      },
      {
        "id": "network:references/03-advanced.md:628:hardcoded-ip-address",
        "category": "network",
        "severity": "medium",
        "pattern": "Hardcoded IP address",
        "file": "references/03-advanced.md",
        "line_start": 628,
        "line_end": 628,
        "snippet": "command: uvicorn app.main:app --host 0.0.0.0 --port 8000 --reload"
      },
      {
        "id": "network:references/03-advanced.md:699:hardcoded-ip-address",
        "category": "network",
        "severity": "medium",
        "pattern": "Hardcoded IP address",
        "file": "references/03-advanced.md",
        "line_start": 699,
        "line_end": 699,
        "snippet": "gunicorn app.main:app -w 4 -k uvicorn.workers.UvicornWorker --bind 0.0.0.0:8000"
      },
      {
        "id": "network:references/03-advanced.md:706:hardcoded-ip-address",
        "category": "network",
        "severity": "medium",
        "pattern": "Hardcoded IP address",
        "file": "references/03-advanced.md",
        "line_start": 706,
        "line_end": 706,
        "snippet": "bind = \"0.0.0.0:8000\""
      },
      {
        "id": "filesystem:references/03-advanced.md:596:hidden-file-access",
        "category": "filesystem",
        "severity": "medium",
        "pattern": "Hidden file access",
        "file": "references/03-advanced.md",
        "line_start": 596,
        "line_end": 596,
        "snippet": "COPY --from=builder /root/.local /root/.local"
      },
      {
        "id": "filesystem:references/03-advanced.md:597:hidden-file-access",
        "category": "filesystem",
        "severity": "medium",
        "pattern": "Hidden file access",
        "file": "references/03-advanced.md",
        "line_start": 597,
        "line_end": 597,
        "snippet": "ENV PATH=/root/.local/bin:$PATH"
      },
      {
        "id": "env_access:references/03-advanced.md:169:database-connection-strings",
        "category": "env_access",
        "severity": "high",
        "pattern": "Database connection strings",
        "file": "references/03-advanced.md",
        "line_start": 169,
        "line_end": 169,
        "snippet": "SQLALCHEMY_DATABASE_URL = \"sqlite:///./test.db\""
      },
      {
        "id": "env_access:references/03-advanced.md:170:database-connection-strings",
        "category": "env_access",
        "severity": "high",
        "pattern": "Database connection strings",
        "file": "references/03-advanced.md",
        "line_start": 170,
        "line_end": 170,
        "snippet": "engine = create_engine(SQLALCHEMY_DATABASE_URL, connect_args={\"check_same_thread\": False})"
      },
      {
        "id": "env_access:references/03-advanced.md:348:database-connection-strings",
        "category": "env_access",
        "severity": "high",
        "pattern": "Database connection strings",
        "file": "references/03-advanced.md",
        "line_start": 348,
        "line_end": 348,
        "snippet": "SQLALCHEMY_DATABASE_URL,"
      },
      {
        "id": "env_access:references/03-advanced.md:621:database-connection-strings",
        "category": "env_access",
        "severity": "high",
        "pattern": "Database connection strings",
        "file": "references/03-advanced.md",
        "line_start": 621,
        "line_end": 621,
        "snippet": "- DATABASE_URL=postgresql://user:password@db:5432/appdb"
      },
      {
        "id": "env_access:references/03-advanced.md:622:database-connection-strings",
        "category": "env_access",
        "severity": "high",
        "pattern": "Database connection strings",
        "file": "references/03-advanced.md",
        "line_start": 622,
        "line_end": 622,
        "snippet": "- REDIS_URL=redis://redis:6379"
      },
      {
        "id": "env_access:references/03-advanced.md:667:database-connection-strings",
        "category": "env_access",
        "severity": "high",
        "pattern": "Database connection strings",
        "file": "references/03-advanced.md",
        "line_start": 667,
        "line_end": 667,
        "snippet": "database_url: str"
      },
      {
        "id": "env_access:references/03-advanced.md:670:database-connection-strings",
        "category": "env_access",
        "severity": "high",
        "pattern": "Database connection strings",
        "file": "references/03-advanced.md",
        "line_start": 670,
        "line_end": 670,
        "snippet": "redis_url: str"
      },
      {
        "id": "env_access:references/03-advanced.md:774:database-connection-strings",
        "category": "env_access",
        "severity": "high",
        "pattern": "Database connection strings",
        "file": "references/03-advanced.md",
        "line_start": 774,
        "line_end": 774,
        "snippet": "- name: DATABASE_URL"
      },
      {
        "id": "env_access:references/03-advanced.md:81:generic-api-secret-keys",
        "category": "env_access",
        "severity": "high",
        "pattern": "Generic API/secret keys",
        "file": "references/03-advanced.md",
        "line_start": 81,
        "line_end": 81,
        "snippet": "payload = jwt.decode(token, SECRET_KEY, algorithms=[ALGORITHM])"
      },
      {
        "id": "env_access:references/03-advanced.md:663:generic-api-secret-keys",
        "category": "env_access",
        "severity": "high",
        "pattern": "Generic API/secret keys",
        "file": "references/03-advanced.md",
        "line_start": 663,
        "line_end": 663,
        "snippet": "secret_key: str"
      },
      {
        "id": "sensitive:references/03-advanced.md:679:environment-file-access",
        "category": "sensitive",
        "severity": "high",
        "pattern": "Environment file access",
        "file": "references/03-advanced.md",
        "line_start": 679,
        "line_end": 679,
        "snippet": "env_file = \".env\""
      },
      {
        "id": "sensitive:references/03-advanced.md:169:sqlite-database-file",
        "category": "sensitive",
        "severity": "medium",
        "pattern": "SQLite database file",
        "file": "references/03-advanced.md",
        "line_start": 169,
        "line_end": 169,
        "snippet": "SQLALCHEMY_DATABASE_URL = \"sqlite:///./test.db\""
      },
      {
        "id": "blocker:references/03-advanced.md:275:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/03-advanced.md",
        "line_start": 275,
        "line_end": 275,
        "snippet": "**Use select loading to avoid N+1 queries:**"
      },
      {
        "id": "blocker:references/03-advanced.md:315:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/03-advanced.md",
        "line_start": 315,
        "line_end": 315,
        "snippet": "item = db.query(DBItem).filter(DBItem.id == item_id).first()"
      },
      {
        "id": "blocker:references/03-advanced.md:531:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/03-advanced.md",
        "line_start": 531,
        "line_end": 532,
        "snippet": "import uuid"
      },
      {
        "id": "blocker:references/03-advanced.md:538:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/03-advanced.md",
        "line_start": 538,
        "line_end": 538,
        "snippet": "request_id = str(uuid.uuid4())"
      },
      {
        "id": "blocker:references/03-advanced.md:542:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/03-advanced.md",
        "line_start": 542,
        "line_end": 543,
        "snippet": "response.headers[\"X-Request-ID\"] = request_id"
      },
      {
        "id": "blocker:references/03-advanced.md:547:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/03-advanced.md",
        "line_start": 547,
        "line_end": 547,
        "snippet": "record.request_id = request_id_var.get()"
      },
      {
        "id": "external_commands:SKILL.md:16:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 16,
        "line_end": 24,
        "snippet": "```python"
      },
      {
        "id": "external_commands:SKILL.md:24:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 24,
        "line_end": 27,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:27:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 27,
        "line_end": 29,
        "snippet": "```bash"
      },
      {
        "id": "external_commands:SKILL.md:29:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 29,
        "line_end": 102,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:102:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 102,
        "line_end": 110,
        "snippet": "```python"
      },
      {
        "id": "external_commands:SKILL.md:110:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 110,
        "line_end": 114,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:114:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 114,
        "line_end": 120,
        "snippet": "```python"
      },
      {
        "id": "external_commands:SKILL.md:120:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 120,
        "line_end": 124,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:124:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 124,
        "line_end": 129,
        "snippet": "```python"
      },
      {
        "id": "external_commands:SKILL.md:129:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 129,
        "line_end": 133,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:133:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 133,
        "line_end": 137,
        "snippet": "```python"
      },
      {
        "id": "network:SKILL.md:31:hardcoded-url",
        "category": "network",
        "severity": "low",
        "pattern": "Hardcoded URL",
        "file": "SKILL.md",
        "line_start": 31,
        "line_end": 31,
        "snippet": "**Access interactive docs:** http://localhost:8000/docs"
      }
    ],
    "finding_verdicts": [
      {
        "id": "blocker:references/01-beginner.md:331:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/01-beginner.md:347:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/01-beginner.md:358:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/01-beginner.md:387:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/01-beginner.md:391:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/01-beginner.md:392:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/01-beginner.md:394:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/01-beginner.md:399:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/01-beginner.md:405:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/01-beginner.md:412:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "network:references/02-intermediate.md:395:hardcoded-url",
        "verdict": "false_positive",
        "confidence": 0.93,
        "reason": "The URL values are CORS origin examples for localhost and example.com in documentation, not outbound network behavior by the skill."
      },
      {
        "id": "filesystem:references/02-intermediate.md:518:python-file-write-append",
        "verdict": "confirmed",
        "confidence": 0.91,
        "reason": "The upload example writes to uploads/{file.filename} directly, so a copied API could allow path traversal or unwanted overwrite through a user-controlled filename.",
        "severity": "high"
      },
      {
        "id": "filesystem:references/02-intermediate.md:526:python-file-write-append",
        "verdict": "confirmed",
        "confidence": 0.91,
        "reason": "The multiple-upload loop writes each UploadFile.filename directly into a filesystem path, which is unsafe if filenames contain traversal or collisions.",
        "severity": "high"
      },
      {
        "id": "filesystem:references/02-intermediate.md:543:python-file-write-append",
        "verdict": "confirmed",
        "confidence": 0.9,
        "reason": "The size-limited upload still writes using the original uploaded filename without normalization, preserving a path traversal and overwrite risk.",
        "severity": "high"
      },
      {
        "id": "filesystem:references/02-intermediate.md:519:python-shutil-operations",
        "verdict": "confirmed",
        "confidence": 0.88,
        "reason": "The copy operation persists uploaded content into the unsanitized path opened on the prior line, so it is part of a concrete unsafe file-write pattern.",
        "severity": "high"
      },
      {
        "id": "filesystem:references/02-intermediate.md:527:python-shutil-operations",
        "verdict": "confirmed",
        "confidence": 0.88,
        "reason": "The copy operation writes each uploaded file into a path derived from the client-provided filename, creating the same unsafe persistence risk.",
        "severity": "high"
      },
      {
        "id": "env_access:references/02-intermediate.md:184:database-connection-strings",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The database string is a placeholder or configuration field in instructional FastAPI documentation, with no real credential or external collection behavior."
      },
      {
        "id": "env_access:references/02-intermediate.md:187:database-connection-strings",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The database string is a placeholder or configuration field in instructional FastAPI documentation, with no real credential or external collection behavior."
      },
      {
        "id": "env_access:references/02-intermediate.md:285:database-connection-strings",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The database string is a placeholder or configuration field in instructional FastAPI documentation, with no real credential or external collection behavior."
      },
      {
        "id": "env_access:references/02-intermediate.md:286:database-connection-strings",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The database string is a placeholder or configuration field in instructional FastAPI documentation, with no real credential or external collection behavior."
      },
      {
        "id": "env_access:references/02-intermediate.md:593:database-connection-strings",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The database string is a placeholder or configuration field in instructional FastAPI documentation, with no real credential or external collection behavior."
      },
      {
        "id": "env_access:references/02-intermediate.md:615:database-connection-strings",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The database string is a placeholder or configuration field in instructional FastAPI documentation, with no real credential or external collection behavior."
      },
      {
        "id": "env_access:references/02-intermediate.md:31:generic-api-secret-keys",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The matched text is a placeholder secret, a settings field, or normal JWT variable usage in examples, not a real secret embedded for misuse."
      },
      {
        "id": "env_access:references/02-intermediate.md:57:generic-api-secret-keys",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The matched text is a placeholder secret, a settings field, or normal JWT variable usage in examples, not a real secret embedded for misuse."
      },
      {
        "id": "env_access:references/02-intermediate.md:99:generic-api-secret-keys",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The matched text is a placeholder secret, a settings field, or normal JWT variable usage in examples, not a real secret embedded for misuse."
      },
      {
        "id": "env_access:references/02-intermediate.md:594:generic-api-secret-keys",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The matched text is a placeholder secret, a settings field, or normal JWT variable usage in examples, not a real secret embedded for misuse."
      },
      {
        "id": "env_access:references/02-intermediate.md:616:generic-api-secret-keys",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The matched text is a placeholder secret, a settings field, or normal JWT variable usage in examples, not a real secret embedded for misuse."
      },
      {
        "id": "sensitive:references/02-intermediate.md:599:environment-file-access",
        "verdict": "false_positive",
        "confidence": 0.86,
        "reason": "The .env reference documents Pydantic settings configuration and example environment variables; the skill does not read local secret files itself."
      },
      {
        "id": "sensitive:references/02-intermediate.md:611:environment-file-access",
        "verdict": "false_positive",
        "confidence": 0.86,
        "reason": "The .env reference documents Pydantic settings configuration and example environment variables; the skill does not read local secret files itself."
      },
      {
        "id": "sensitive:references/02-intermediate.md:185:sqlite-database-file",
        "verdict": "false_positive",
        "confidence": 0.92,
        "reason": "The SQLite path is a test or optional local database example in documentation, not sensitive database access by the skill."
      },
      {
        "id": "blocker:references/02-intermediate.md:200:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/02-intermediate.md:205:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/02-intermediate.md:212:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/02-intermediate.md:248:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/02-intermediate.md:260:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/02-intermediate.md:271:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/02-intermediate.md:307:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "network:references/03-advanced.md:230:hardcoded-url",
        "verdict": "false_positive",
        "confidence": 0.95,
        "reason": "The hardcoded URL is the httpx test base URL used for in-process tests, not an external service connection."
      },
      {
        "id": "network:references/03-advanced.md:236:hardcoded-url",
        "verdict": "false_positive",
        "confidence": 0.95,
        "reason": "The hardcoded URL is the httpx test base URL used for in-process tests, not an external service connection."
      },
      {
        "id": "network:references/03-advanced.md:577:hardcoded-ip-address",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The matched IP is 0.0.0.0 in container or server bind examples, which is standard deployment syntax and not network reconnaissance or exfiltration."
      },
      {
        "id": "network:references/03-advanced.md:607:hardcoded-ip-address",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The matched IP is 0.0.0.0 in container or server bind examples, which is standard deployment syntax and not network reconnaissance or exfiltration."
      },
      {
        "id": "network:references/03-advanced.md:628:hardcoded-ip-address",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The matched IP is 0.0.0.0 in container or server bind examples, which is standard deployment syntax and not network reconnaissance or exfiltration."
      },
      {
        "id": "network:references/03-advanced.md:699:hardcoded-ip-address",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The matched IP is 0.0.0.0 in container or server bind examples, which is standard deployment syntax and not network reconnaissance or exfiltration."
      },
      {
        "id": "network:references/03-advanced.md:706:hardcoded-ip-address",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The matched IP is 0.0.0.0 in container or server bind examples, which is standard deployment syntax and not network reconnaissance or exfiltration."
      },
      {
        "id": "filesystem:references/03-advanced.md:596:hidden-file-access",
        "verdict": "false_positive",
        "confidence": 0.92,
        "reason": "The /root/.local path is inside a Docker multi-stage build example for copied Python packages, not hidden host-file access by the skill."
      },
      {
        "id": "filesystem:references/03-advanced.md:597:hidden-file-access",
        "verdict": "false_positive",
        "confidence": 0.92,
        "reason": "The /root/.local path is inside a Docker multi-stage build example for copied Python packages, not hidden host-file access by the skill."
      },
      {
        "id": "env_access:references/03-advanced.md:169:database-connection-strings",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The database string is a placeholder or configuration field in instructional FastAPI documentation, with no real credential or external collection behavior."
      },
      {
        "id": "env_access:references/03-advanced.md:170:database-connection-strings",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The database string is a placeholder or configuration field in instructional FastAPI documentation, with no real credential or external collection behavior."
      },
      {
        "id": "env_access:references/03-advanced.md:348:database-connection-strings",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The database string is a placeholder or configuration field in instructional FastAPI documentation, with no real credential or external collection behavior."
      },
      {
        "id": "env_access:references/03-advanced.md:621:database-connection-strings",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The database string is a placeholder or configuration field in instructional FastAPI documentation, with no real credential or external collection behavior."
      },
      {
        "id": "env_access:references/03-advanced.md:622:database-connection-strings",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The database string is a placeholder or configuration field in instructional FastAPI documentation, with no real credential or external collection behavior."
      },
      {
        "id": "env_access:references/03-advanced.md:667:database-connection-strings",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The database string is a placeholder or configuration field in instructional FastAPI documentation, with no real credential or external collection behavior."
      },
      {
        "id": "env_access:references/03-advanced.md:670:database-connection-strings",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The database string is a placeholder or configuration field in instructional FastAPI documentation, with no real credential or external collection behavior."
      },
      {
        "id": "env_access:references/03-advanced.md:774:database-connection-strings",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The database string is a placeholder or configuration field in instructional FastAPI documentation, with no real credential or external collection behavior."
      },
      {
        "id": "env_access:references/03-advanced.md:81:generic-api-secret-keys",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The matched text is a placeholder secret, a settings field, or normal JWT variable usage in examples, not a real secret embedded for misuse."
      },
      {
        "id": "env_access:references/03-advanced.md:663:generic-api-secret-keys",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The matched text is a placeholder secret, a settings field, or normal JWT variable usage in examples, not a real secret embedded for misuse."
      },
      {
        "id": "sensitive:references/03-advanced.md:679:environment-file-access",
        "verdict": "false_positive",
        "confidence": 0.86,
        "reason": "The .env reference documents Pydantic settings configuration and example environment variables; the skill does not read local secret files itself."
      },
      {
        "id": "sensitive:references/03-advanced.md:169:sqlite-database-file",
        "verdict": "false_positive",
        "confidence": 0.92,
        "reason": "The SQLite path is a test or optional local database example in documentation, not sensitive database access by the skill."
      },
      {
        "id": "blocker:references/03-advanced.md:275:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/03-advanced.md:315:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/03-advanced.md:531:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/03-advanced.md:538:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/03-advanced.md:542:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "blocker:references/03-advanced.md:547:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "This is ordinary sample API logic using item or request identifiers, not host discovery, environment probing, or system reconnaissance."
      },
      {
        "id": "external_commands:SKILL.md:16:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The matched text is a Markdown code fence in documentation, not Ruby backtick execution or hidden command execution by the skill."
      },
      {
        "id": "external_commands:SKILL.md:24:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The matched text is a Markdown code fence in documentation, not Ruby backtick execution or hidden command execution by the skill."
      },
      {
        "id": "external_commands:SKILL.md:27:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The matched text is a Markdown code fence in documentation, not Ruby backtick execution or hidden command execution by the skill."
      },
      {
        "id": "external_commands:SKILL.md:29:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The matched text is a Markdown code fence in documentation, not Ruby backtick execution or hidden command execution by the skill."
      },
      {
        "id": "external_commands:SKILL.md:102:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The matched text is a Markdown code fence in documentation, not Ruby backtick execution or hidden command execution by the skill."
      },
      {
        "id": "external_commands:SKILL.md:110:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The matched text is a Markdown code fence in documentation, not Ruby backtick execution or hidden command execution by the skill."
      },
      {
        "id": "external_commands:SKILL.md:114:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The matched text is a Markdown code fence in documentation, not Ruby backtick execution or hidden command execution by the skill."
      },
      {
        "id": "external_commands:SKILL.md:120:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The matched text is a Markdown code fence in documentation, not Ruby backtick execution or hidden command execution by the skill."
      },
      {
        "id": "external_commands:SKILL.md:124:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The matched text is a Markdown code fence in documentation, not Ruby backtick execution or hidden command execution by the skill."
      },
      {
        "id": "external_commands:SKILL.md:129:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The matched text is a Markdown code fence in documentation, not Ruby backtick execution or hidden command execution by the skill."
      },
      {
        "id": "external_commands:SKILL.md:133:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The matched text is a Markdown code fence in documentation, not Ruby backtick execution or hidden command execution by the skill."
      },
      {
        "id": "network:SKILL.md:31:hardcoded-url",
        "verdict": "false_positive",
        "confidence": 0.96,
        "reason": "The URL points to localhost interactive FastAPI documentation for a user-run development server, not an external endpoint or exfiltration target."
      }
    ],
    "semantic_findings": [
      {
        "title": "Unsafe File Upload Path Handling",
        "description": "The upload and download examples build paths from UploadFile.filename or filename without normalization. Copying this into an API can allow path traversal, overwrite, or unauthorized file reads.",
        "severity": "high",
        "locations": [
          {
            "file": "references/02-intermediate.md",
            "line_start": 516,
            "line_end": 560
          }
        ],
        "confidence": 0.93,
        "confidence_reasoning": "The examples directly concatenate user-controlled filenames into uploads paths for writes and downloads, and no sanitization or safe-name generation is shown."
      },
      {
        "title": "Insecure Development Deployment Defaults",
        "description": "The Docker Compose example uses placeholder database credentials and publishes database and Redis ports. It needs an explicit development-only warning to avoid production exposure.",
        "severity": "medium",
        "locations": [
          {
            "file": "references/03-advanced.md",
            "line_start": 620,
            "line_end": 644
          }
        ],
        "confidence": 0.78,
        "confidence_reasoning": "The lines show default service credentials and host port publication; the context is educational, so the risk is mainly unsafe copy-paste into production."
      },
      {
        "title": "Permissive Production Host Setting",
        "description": "The production configuration example sets allowed hosts to a wildcard. If reused unchanged, this weakens host validation for deployed services.",
        "severity": "medium",
        "locations": [
          {
            "file": "references/03-advanced.md",
            "line_start": 652,
            "line_end": 681
          }
        ],
        "confidence": 0.82,
        "confidence_reasoning": "The setting appears under production configuration and uses a wildcard host list, which is a clear hardening gap even though it is documentation."
      }
    ],
    "critical_findings": [],
    "high_findings": [
      {
        "title": "Python file write/append",
        "description": "with open(f\"uploads/{file.filename}\", \"wb\") as buffer:",
        "locations": [
          {
            "file": "references/02-intermediate.md",
            "line_start": 518,
            "line_end": 518
          }
        ],
        "review_kind": "capability",
        "source_category": "filesystem",
        "source_severity": "medium",
        "confidence": 0.91,
        "confidence_reasoning": "The upload example writes to uploads/{file.filename} directly, so a copied API could allow path traversal or unwanted overwrite through a user-controlled filename."
      },
      {
        "title": "Python file write/append",
        "description": "with open(f\"uploads/{file.filename}\", \"wb\") as buffer:",
        "locations": [
          {
            "file": "references/02-intermediate.md",
            "line_start": 526,
            "line_end": 526
          }
        ],
        "review_kind": "capability",
        "source_category": "filesystem",
        "source_severity": "medium",
        "confidence": 0.91,
        "confidence_reasoning": "The multiple-upload loop writes each UploadFile.filename directly into a filesystem path, which is unsafe if filenames contain traversal or collisions."
      },
      {
        "title": "Python file write/append",
        "description": "with open(f\"uploads/{file.filename}\", \"wb\") as f:",
        "locations": [
          {
            "file": "references/02-intermediate.md",
            "line_start": 543,
            "line_end": 543
          }
        ],
        "review_kind": "capability",
        "source_category": "filesystem",
        "source_severity": "medium",
        "confidence": 0.9,
        "confidence_reasoning": "The size-limited upload still writes using the original uploaded filename without normalization, preserving a path traversal and overwrite risk."
      },
      {
        "title": "Python shutil operations",
        "description": "shutil.copyfileobj(file.file, buffer)",
        "locations": [
          {
            "file": "references/02-intermediate.md",
            "line_start": 519,
            "line_end": 519
          }
        ],
        "review_kind": "capability",
        "source_category": "filesystem",
        "source_severity": "medium",
        "confidence": 0.88,
        "confidence_reasoning": "The copy operation persists uploaded content into the unsanitized path opened on the prior line, so it is part of a concrete unsafe file-write pattern."
      },
      {
        "title": "Python shutil operations",
        "description": "shutil.copyfileobj(file.file, buffer)",
        "locations": [
          {
            "file": "references/02-intermediate.md",
            "line_start": 527,
            "line_end": 527
          }
        ],
        "review_kind": "capability",
        "source_category": "filesystem",
        "source_severity": "medium",
        "confidence": 0.88,
        "confidence_reasoning": "The copy operation writes each uploaded file into a path derived from the client-provided filename, creating the same unsafe persistence risk."
      },
      {
        "title": "Unsafe File Upload Path Handling",
        "description": "The upload and download examples build paths from UploadFile.filename or filename without normalization. Copying this into an API can allow path traversal, overwrite, or unauthorized file reads.",
        "locations": [
          {
            "file": "references/02-intermediate.md",
            "line_start": 516,
            "line_end": 560
          }
        ],
        "review_kind": "security",
        "source_category": "semantic",
        "source_severity": "high",
        "confidence": 0.93,
        "confidence_reasoning": "The examples directly concatenate user-controlled filenames into uploads paths for writes and downloads, and no sanitization or safe-name generation is shown."
      }
    ],
    "medium_findings": [
      {
        "title": "Insecure Development Deployment Defaults",
        "description": "The Docker Compose example uses placeholder database credentials and publishes database and Redis ports. It needs an explicit development-only warning to avoid production exposure.",
        "locations": [
          {
            "file": "references/03-advanced.md",
            "line_start": 620,
            "line_end": 644
          }
        ],
        "review_kind": "security",
        "source_category": "semantic",
        "source_severity": "medium",
        "confidence": 0.78,
        "confidence_reasoning": "The lines show default service credentials and host port publication; the context is educational, so the risk is mainly unsafe copy-paste into production."
      },
      {
        "title": "Permissive Production Host Setting",
        "description": "The production configuration example sets allowed hosts to a wildcard. If reused unchanged, this weakens host validation for deployed services.",
        "locations": [
          {
            "file": "references/03-advanced.md",
            "line_start": 652,
            "line_end": 681
          }
        ],
        "review_kind": "security",
        "source_category": "semantic",
        "source_severity": "medium",
        "confidence": 0.82,
        "confidence_reasoning": "The setting appears under production configuration and uses a wildcard host list, which is a clear hardening gap even though it is documentation."
      }
    ],
    "low_findings": [],
    "dangerous_patterns": [],
    "files_scanned": 4,
    "total_lines": 2048,
    "audit_model": "codex",
    "audited_at": "2026-07-07T18:41:44.079Z",
    "agent_auto_install_policy": "confirmation_required",
    "manual_install_policy": "allowed"
  },
  "content": {
    "user_title": "Build Production FastAPI APIs",
    "value_statement": "FastAPI teams need patterns for secure APIs, databases, auth, tests, and deployment. This skill provides progressive guidance and examples for Claude, Codex, and Claude Code.",
    "seo_keywords": [
      "FastAPI",
      "Python APIs",
      "REST API development",
      "Pydantic models",
      "SQLAlchemy integration",
      "JWT authentication",
      "Claude",
      "Codex",
      "Claude Code"
    ],
    "actual_capabilities": [
      "Explains FastAPI routing, request parameters, response models, and status codes.",
      "Guides JWT authentication, OAuth2 dependencies, and protected route patterns.",
      "Shows SQLAlchemy and async database integration for CRUD APIs.",
      "Covers middleware, CORS, background tasks, and file handling patterns.",
      "Provides testing, WebSocket, container, and deployment reference material."
    ],
    "limitations": [
      "The skill is documentation-focused and does not run or verify generated code.",
      "Some examples use placeholders that must be replaced before production use.",
      "Database and deployment choices require project-specific review.",
      "Security-sensitive examples need additional hardening before direct reuse."
    ],
    "use_cases": [
      {
        "title": "Create a New API Service",
        "description": "Plan routes, request models, response models, and CRUD behavior for a new FastAPI service.",
        "target_user": "Backend developer"
      },
      {
        "title": "Add Authentication and Data Access",
        "description": "Use JWT, OAuth2, dependency injection, SQLAlchemy, and async database examples to extend an existing API.",
        "target_user": "Application engineer"
      },
      {
        "title": "Prepare for Testing and Deployment",
        "description": "Review pytest patterns, Docker examples, health checks, and production configuration concepts.",
        "target_user": "Platform engineer"
      }
    ],
    "prompt_templates": [
      {
        "title": "Beginner API Skeleton",
        "scenario": "Starting a new FastAPI project",
        "prompt": "Use this FastAPI skill to design a small REST API with routes, Pydantic models, validation, and error handling. Explain the file layout and first implementation steps."
      },
      {
        "title": "Intermediate CRUD Service",
        "scenario": "Adding persistence to an API",
        "prompt": "Use this FastAPI skill to add SQLAlchemy CRUD operations, dependency-injected sessions, response models, and tests for an existing resource."
      },
      {
        "title": "Secure Authentication Flow",
        "scenario": "Protecting API endpoints",
        "prompt": "Use this FastAPI skill to plan JWT authentication with OAuth2 dependencies, password hashing, token expiration, protected routes, and production secret handling."
      },
      {
        "title": "Advanced Deployment Review",
        "scenario": "Preparing a service for release",
        "prompt": "Use this FastAPI skill to review my API for tests, logging, health checks, WebSocket needs, container settings, and deployment hardening."
      }
    ],
    "output_examples": [
      {
        "input": "Design a FastAPI CRUD API for projects and tasks.",
        "output": [
          "A route plan with resource names, request models, and response models.",
          "A database integration outline with session management and CRUD responsibilities.",
          "A testing checklist for success, validation, and not-found cases."
        ]
      },
      {
        "input": "Review my FastAPI upload endpoint for security issues.",
        "output": [
          "A risk summary covering filename handling, file size limits, and download behavior.",
          "Recommended controls for generated filenames, path normalization, and allowed file types.",
          "Production checks for storage location, permissions, and error handling."
        ]
      },
      {
        "input": "Prepare my FastAPI app for deployment.",
        "output": [
          "A deployment readiness review for Docker, environment settings, logging, and health checks.",
          "A list of settings that must move to secrets or environment variables.",
          "A test and observability checklist for release confidence."
        ]
      }
    ],
    "best_practices": [
      "Use project-specific settings for secrets, database URLs, CORS origins, and allowed hosts.",
      "Ask for tests and validation paths when generating endpoints or database changes.",
      "Review copied examples before production use, especially authentication, file handling, and deployment settings."
    ],
    "anti_patterns": [
      "Do not copy placeholder secrets, passwords, or database URLs into production code.",
      "Do not store uploaded files with user-supplied filenames without sanitization.",
      "Do not expose database or cache ports publicly without a clear operational need."
    ],
    "faq": [
      {
        "question": "What does this skill help with?",
        "answer": "It helps design and improve FastAPI APIs, including routing, validation, authentication, databases, tests, and deployment topics."
      },
      {
        "question": "Can it generate complete applications?",
        "answer": "It can guide application structure and implementation, but generated code still needs local testing and project review."
      },
      {
        "question": "Does it cover authentication?",
        "answer": "Yes. It includes JWT, OAuth2, password hashing, protected routes, and token validation concepts."
      },
      {
        "question": "Does it support database work?",
        "answer": "Yes. It covers SQLAlchemy sessions, CRUD operations, async database access, and connection settings."
      },
      {
        "question": "Is the deployment guidance production-ready?",
        "answer": "It provides deployment patterns, but secrets, network exposure, CORS, and host settings must be hardened per environment."
      },
      {
        "question": "Which tools can use this skill?",
        "answer": "The report lists compatibility with Claude, Codex, and Claude Code."
      }
    ]
  },
  "file_structure": [
    {
      "name": "references",
      "type": "dir",
      "path": "references",
      "children": [
        {
          "name": "01-beginner.md",
          "type": "file",
          "path": "references/01-beginner.md",
          "lines": 436
        },
        {
          "name": "02-intermediate.md",
          "type": "file",
          "path": "references/02-intermediate.md",
          "lines": 622
        },
        {
          "name": "03-advanced.md",
          "type": "file",
          "path": "references/03-advanced.md",
          "lines": 842
        }
      ]
    },
    {
      "name": "SKILL.md",
      "type": "file",
      "path": "SKILL.md",
      "lines": 148
    }
  ]
}
writing-skillsobra/superpowersUse when creating new skills, editing existing skills, or verifying skills work before deploymentStars: 322kUpdated Claude CodeCodexVerifiedInstall
xlsxanthropics/skillsUse this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.Stars: 198kUpdated Claude CodeCodexVerifiedInstall
shipping-and-launchaddyosmani/agent-skillsPrepares production launches. Use when preparing to deploy to production, or when asking what needs to be in place before shipping. Use when you need a pre-launch checklist, when setting up monitoring, when planning a staged rollout, or when you need a rollback strategy.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
childhoodthedotmack/claude-memBabysit a shipped release after merge, publication, or deployment. Verify published packages, production behavior, installed plugins, and late CI or user reports until the observation window is clean; use babysit for PR readiness before release.Stars: 118kUpdated Claude CodeCodexVerifiedInstall