Atlas view

Canonical Storage

Canonical Storage is where raw truth becomes durable truth. These projects normalize schemas, preserve history, and create stable identifiers so data can be reused across tools without re-deriving meaning every time. Storage is where drift is detected, not disguised.
Stage guide

How this stage works

What this stage is

Canonical Storage turns raw truth into stable, reusable datasets. It preserves history and identifiers so downstream systems can trust the boundary.

Inputs

  • Raw extracts and snapshots
  • CSV and JSON feeds
  • Normalized tables or sheets
  • Mapping tables and reference data

Outputs

  • Versioned datasets and snapshots
  • Query-ready tables or sheets
  • Data quality reports
  • Stable identifiers for joins

What good looks like

  • Schemas are documented and stable.
  • History is preserved or versioned.
  • Data quality checks run on ingest.
  • Downstream systems depend on a single source of truth.

Common failure modes

  • Overwrites without history or provenance.
  • Multiple competing sources of truth.
  • Unvalidated data with silent drift.
  • Access controls too broad or too narrow.
Results 36 projects
System · Prototyping

Aether Integrator Platform

Centralize integration workflows in a single web app so connectors share authentication, scheduling, and audit controls instead of bespoke scripts. It ingests …

Automation Engines Canonical Storage Operational Adoption Human Interfaces
Open project
System · Active

ASCIP Sync Engine

Provide a deterministic, auditable way to keep district staff data aligned with ASCIP LMS by turning CSV extracts into a repeatable diff-and-apply workflow. …

Reality Ingestion Canonical Storage Automation Engines Operational Adoption
Open project
System · Active

Staff Device Refresh Operations Portal

Give technicians a clear, role-filtered view of refresh work without manual reconciliation. It ingests SQL extracts of staff/devices; role/site access config …

Reality Ingestion Canonical Storage Human Interfaces Operational Adoption
Open project
Component · Active

Aeries Staff Extract SQL Generator

Extract operationally meaningful staff datasets that reflect reality across schools and roles. It ingests Aeries tables (staff, sections, TCH/MST, etc.); date …

Reality Ingestion Canonical Storage
Open project
System · Active

Perpetual Data Reports Portal

Turn recurring report requests into stable, owned, self-service operational reporting. It ingests recurring extracts; scheduled refreshes; report definitions …

Reality Ingestion Canonical Storage Human Interfaces Operational Adoption
Open project
Experiment · Idea

Email Corpus Ingestion Pipeline (EML)

Transform raw email archives into a structured, searchable knowledge system with strict privacy controls. It ingests EML files export; attachment metadata …

Reality Ingestion Canonical Storage Automation Engines
Open project
Component · Deprecated

MDM Integration Automation (Mosyle)

Unify device inventory and compliance signals so operations can act on a single source of truth. Authenticate with Mosyle using access token, email, and …

Automation Engines Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
Field Tool · Active

BOUSD-ClassSize-Extract

Uses UnixODBC + Microsoft ODBC driver to query Aeries SQL Server. Uses a Google service account to update reporting sheets after each extract. It ingests …

Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
Field Tool · Active

BOUSD-DataConfDocs-Extract

Uses UnixODBC + Microsoft ODBC driver to query Aeries SQL Server. Uses a Google service account to update reporting sheets after each extract. It ingests …

Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
Field Tool · Maintenance

BOUSD-Enrollment-Extract

Uses UnixODBC + Microsoft ODBC driver to query Aeries SQL Server. Uses a Google service account to update reporting sheets after each extract. It ingests …

Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
Experiment · Maintenance

BOUSD-Enrollment-Worksheet-HR

Uses UnixODBC + Microsoft ODBC driver to query Aeries SQL Server. Uses a Google service account to update reporting sheets after each extract. It ingests …

Human Interfaces Operational Adoption Canonical Storage
Open project
System · Active

BOUSD-MonthlyAttendance-Dashboard

This project powers the Brea Olinda USD monthly attendance dashboard that school and district leaders use to monitor attendance and chronic absenteeism trends …

Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
Field Tool · Active

BOUSD-MonthlyAttendance-Extract

Uses UnixODBC + Microsoft ODBC driver to query Aeries SQL Server. Uses a Google service account to update reporting sheets after each extract. Produces …

Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
Field Tool · Maintenance

BOUSD-PADC-Extract

Uses UnixODBC + Microsoft ODBC driver to query Aeries SQL Server. Uses a Google service account to update reporting sheets after each extract. It ingests …

Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
System · Active

BOUSD-Staff-Technology-Dashboard

This project powers the Brea Olinda USD staff technology dashboard that the Technology Services department uses to manage technology needs and plan device …

Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
Component · Deprecated

camcott

Development and production setup steps for a Laravel application with MySQL. Optional FreeTDS configuration for MSSQL date formatting. It ingests Configuration …

Human Interfaces Operational Adoption Canonical Storage
Open project
Component · Deprecated

clasp

Enable local development, version control, and deployment workflows for Google Apps Script projects. Authenticates a local developer against Google APIs. Syncs …

Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
Component · Maintenance

Database-Ingester

Enable safe, repeatable CSV ingestion into SQL Server tables with backups and dry-run visibility. Load config, optionally back up the target table, compare CSV …

Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
System · Active

District Transfer Tracking

Centralizes, normalizes, and syncs district transfer data into a single Google Sheet for review and downstream reporting.

Reality Ingestion Canonical Storage Human Interfaces
Open project
Field Tool · Active

email_template_mailer

Send personalized email campaigns from a CSV-driven dataset while keeping an audit trail of what was sent. Load template + CSV, expand variables, optionally …

Human Interfaces Operational Adoption Canonical Storage
Open project
Component · Active

google-sheet-sync

Provide a consistent, modern CLI with subcommands and config support Support download, upload, and sync with predictable, auditable outcomes Ensure CLI options …

Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
Component · Active

gpt_kit

Scripts transform ticket EML exports into a normalized knowledge base with tagging and optional redaction. Make scripts executable, then run them with input EML …

Automation Engines Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
Component · Active

Integr8r

Provide a shared PowerShell framework for district integrations, so each vendor flow follows a consistent pattern for config loading, data transforms, and …

Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
Component · Active

Integr8r-rebase

Provide a rebase of Integr8r with consistent config-loading and reporting conventions for vendor integrations. Load PowerShell config files and module settings. …

Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
Field Tool · Maintenance

mssql_query_to_csv

The **MSSQL Query to CSV** program is a command-line tool written in Rust that connects to a Microsoft SQL Server database, executes a SQL query, and exports …

Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
Field Tool · Maintenance

mssql_query_to_google_sheet

Package description from Cargo.toml: A simple tool to fetch data from MSSQL using ODBC and export to a Google Sheet. It ingests TOML config, SQL Server via …

Canonical Storage Human Interfaces
Open project
Field Tool · Maintenance

mssql_to_csv

Run SQL files against MSSQL and export results to CSV, optionally through an SSH tunnel. It ingests TOML config, SQL file, MSSQL database and produces CSV …

Canonical Storage
Open project
System · Active

openhab-git-sync

Automated two-way Git synchronisation for openHAB deployments that keeps /etc/openhab and selected /var/lib/openhab subtrees version-controlled without …

Automation Engines Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
System · Maintenance

privateGPT

Expose a private, extensible RAG platform that works offline and keeps data inside the execution environment. Ingest documents from a local folder, splitting …

Automation Engines Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
Field Tool · Prototyping

PrivateGPTConf

Package the steps and configuration needed to get a local PrivateGPT instance running with custom documents. Install prerequisites and clone PrivateGPT to a …

Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
Component · Prototyping

PrivateGPTConf/env/default

Ship a known-good PrivateGPT configuration snapshot that the setup scripts can copy into a local installation. Provide default settings.yaml profiles and …

Automation Engines Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
System · Active

Project Atlas

Project Atlas is the documentation hub for AetherDev systems. Atlas and Showcase sections with canonical project schema. Taxonomy views for pipeline, domains, …

Automation Engines Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project
Experiment · Maintenance

SamsungTVSettings

Exported clone directories used to standardize Samsung TV configuration. It ingests exported clone files and produces clone archives for TV setup.

Canonical Storage
Open project
Experiment · Active

SQL

Centralize operational queries for reporting, audits, and data movement workflows. It ingests Database tables (Aeries and related systems) and produces Query …

Canonical Storage
Open project
Field Tool · Maintenance

sql_to_csv

DB Query to CSV** is a flexible command-line tool written in Rust that connects to SQL databases (such as MSSQL, PostgreSQL, or MySQL) using SQLx, executes a …

Reality Ingestion Human Interfaces Operational Adoption Canonical Storage
Open project