lib-process:shared--local-db-build
library/processes/shared/local-db-build overview
Generic "build a local SQLite database from a source manifest" process. Generalized from the schema-design + ETL + index + validation + documentation phases of `specializations/domains/business/travel/flight-dataset-build.js`. Produces a queryable SQLite file + SCHEMA.md that downstream exploration processes (see `db-agent-explore.js`) can consume without guessing table/column names. Hard constraints (inherited from the travel pattern): - All tasks are `kind:'agent'`. No shell tasks. No MCP. - All DB creation, loading, indexing, and validation is performed by Python 3 scripts that use ONLY the stdlib `sqlite3` module. - No ORM, no sqlite3 CLI. - The build is idempotent: re-running with the same inputs either reuses the existing DB or rebuilds deterministically.
Attributes
- sqlite-schema-architect
- python-etl-engineer
- data-quality-inspector
Outgoing edges
- domain:software-engineering·DomainSoftware Engineering
- topic:test-driven-development·TopicTest-Driven Development
- topic:code-review-best-practices·TopicCode Review Best Practices
- workflow:code-review·Workflow
- workflow:feature-development·Workflow
- workflow:release-management·Workflow
- role:backend-engineer·RoleBackend Engineer
- role:tech-lead·RoleTech Lead
- role:qa-engineer·RoleQA Engineer
- skill-area:code-review-practice·SkillAreaCode Review Practice
- skill-area:e2e-testing·SkillAreaEnd-to-End Testing
- lib-agent:travel--sqlite-schema-architect·LibraryAgentsqlite-schema-architect
- lib-agent:travel--python-etl-engineer·LibraryAgentpython-etl-engineer
- lib-agent:travel--data-quality-inspector·LibraryAgentdata-quality-inspector