Agentic AI Atlasby a5c.ai
OverviewWikiGraphFor AgentsEdgesSearchWorkspace
/
GitHubDocsDiscord
iiRecord
Agentic AI Atlas · library/processes/shared/local-db-build
lib-process:shared--local-db-builda5c.ai
Search record views/
Record · tabs

Available views

II.Record viewspp. 1 - 1
overviewjsongraph
II.
LibraryProcess overview

lib-process:shared--local-db-build

Reference · live

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.

LibraryProcessOutgoing · 14Incoming · 0

Attributes

displayName
library/processes/shared/local-db-build
description
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.
libraryPath
library/processes/shared/local-db-build.js
usesAgents
  • sqlite-schema-architect
  • python-etl-engineer
  • data-quality-inspector

Outgoing edges

lib_applies_to_domain1
  • domain:software-engineering·DomainSoftware Engineering
lib_covers_topic2
  • topic:test-driven-development·TopicTest-Driven Development
  • topic:code-review-best-practices·TopicCode Review Best Practices
lib_implements_workflow3
  • workflow:code-review·Workflow
  • workflow:feature-development·Workflow
  • workflow:release-management·Workflow
lib_involves_role3
  • role:backend-engineer·RoleBackend Engineer
  • role:tech-lead·RoleTech Lead
  • role:qa-engineer·RoleQA Engineer
lib_requires_skill_area2
  • skill-area:code-review-practice·SkillAreaCode Review Practice
  • skill-area:e2e-testing·SkillAreaEnd-to-End Testing
uses_agent3
  • 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

Incoming edges

None.

Related pages

No related wiki pages for this record.

Shortcuts

Open in graph
Browse node kind