II.
LibraryAgent overview
Reference · livelib-agent:travel--sqlite-schema-architect
sqlite-schema-architect overview
Designs the SQLite schema, indexes, and denormalized helper views for a curated travel dataset, and writes SCHEMA.md for downstream SQL authors.
Attributes
displayName
sqlite-schema-architect
description
Designs the SQLite schema, indexes, and denormalized helper views for a curated travel dataset, and writes SCHEMA.md for downstream SQL authors.
libraryPath
library/specializations/domains/business/travel/agents/sqlite-schema-architect/AGENT.md
specialization
travel
role
SQLite Schema Architect
expertise
- Read-heavy SQLite design for single-user datasets
- Explicit FK modelling with IATA codes as natural keys
- Query-shape-driven denormalization
- Index + view design that collapses repeated query shapes
- SCHEMA.md documentation for LLM-driven SQL authors
Outgoing edges
lib_applies_to_domain1
- domain:travel·DomainTravel
lib_belongs_to_specialization1
- specialization:travel·SpecializationTravel
lib_implements_workflow1
- workflow:customer-journey-optimization·WorkflowCustomer Journey Optimization
lib_involves_role3
- role:data-engineer·RoleData Engineer
- role:database-administrator·RoleDatabase Administrator
- role:analytics-engineer·RoleAnalytics Engineer
lib_requires_skill_area3
- skill-area:etl-pipelines·SkillAreaETL Pipelines
- skill-area:travel-itinerary-planning·SkillAreaTravel Itinerary Planning
- skill-area:data-governance·SkillAreaData Governance
Incoming edges
uses_agent2
- lib-process:shared--local-db-build·LibraryProcesslibrary/processes/shared/local-db-build
- lib-process:travel--flight-dataset-build·LibraryProcessflight-dataset-build