{
  "id": "lib-process:shared--local-db-build",
  "_kind": "LibraryProcess",
  "_file": "generated-library/processes.yaml",
  "_cluster": "generated-library",
  "attributes": {
    "displayName": "library/processes/shared/local-db-build",
    "description": "Generic \"build a local SQLite database from a source manifest\"\n  process. Generalized from the schema-design + ETL + index + validation +\n  documentation phases of\n  `specializations/domains/business/travel/flight-dataset-build.js`.\n  Produces a queryable SQLite file + SCHEMA.md that downstream\n  exploration processes (see `db-agent-explore.js`) can consume without\n  guessing table/column names.\n  Hard constraints (inherited from the travel pattern):\n  - All tasks are `kind:'agent'`. No shell tasks. No MCP.\n  - All DB creation, loading, indexing, and validation is performed by\n    Python 3 scripts that use ONLY the stdlib `sqlite3` module.\n  - No ORM, no sqlite3 CLI.\n  - The build is idempotent: re-running with the same inputs either\n    reuses the existing DB or rebuilds deterministically.",
    "libraryPath": "library/processes/shared/local-db-build.js",
    "usesAgents": [
      "sqlite-schema-architect",
      "python-etl-engineer",
      "data-quality-inspector"
    ]
  },
  "outgoingEdges": [
    {
      "from": "lib-process:shared--local-db-build",
      "to": "skill-area:code-review-practice",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:shared--local-db-build",
      "to": "skill-area:e2e-testing",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-process:shared--local-db-build",
      "to": "topic:test-driven-development",
      "kind": "lib_covers_topic",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:shared--local-db-build",
      "to": "topic:code-review-best-practices",
      "kind": "lib_covers_topic",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-process:shared--local-db-build",
      "to": "domain:software-engineering",
      "kind": "lib_applies_to_domain",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:shared--local-db-build",
      "to": "role:backend-engineer",
      "kind": "lib_involves_role",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:shared--local-db-build",
      "to": "role:tech-lead",
      "kind": "lib_involves_role",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-process:shared--local-db-build",
      "to": "role:qa-engineer",
      "kind": "lib_involves_role",
      "attributes": {
        "weight": 0.5
      }
    },
    {
      "from": "lib-process:shared--local-db-build",
      "to": "workflow:code-review",
      "kind": "lib_implements_workflow",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:shared--local-db-build",
      "to": "workflow:feature-development",
      "kind": "lib_implements_workflow",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-process:shared--local-db-build",
      "to": "workflow:release-management",
      "kind": "lib_implements_workflow",
      "attributes": {
        "weight": 0.5
      }
    },
    {
      "from": "lib-process:shared--local-db-build",
      "to": "lib-agent:travel--sqlite-schema-architect",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    },
    {
      "from": "lib-process:shared--local-db-build",
      "to": "lib-agent:travel--python-etl-engineer",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    },
    {
      "from": "lib-process:shared--local-db-build",
      "to": "lib-agent:travel--data-quality-inspector",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    }
  ],
  "incomingEdges": []
}