BUILTSYSTEMS2026

CORE

The evidence layer behind the company.

Internal prototype — architecture proven locally, not exposed publicly.

PythonFlaskSQLiteHTMLJavaScript
Aethelion website
A

Overview

Aethelion Core is the internal business-system prototype: a SQLite database, a Flask API over it, and a dashboard that refuses to display anything unverified.

It holds agents, projects, tasks, executions, and evidence — the entire operational audit trail in one place.

B

Problem

A company that sells automation should run on automation, and its claims should be inspectable. Core was built to persist and serve that evidence.

C

Approach

  • SQLite schema with six tables: agents, audit, projects, tasks, executions, evidence.
  • Flask API with parameterized queries and a health root returning real status.
  • Dashboard labeled REAL DATA ONLY — no fabricated figures.
D

Architecture

ArchitectureTRIGGER → PROCESS → AI → DATA → ACTION

INTENT: this is the actual design the system was built against — not a decorative diagram.

E

Implementation

  • Database schema created and populated with real rows: one active orchestrator agent, completed projects/tasks, an execution record with exit code 0, and an evidence row.
  • Flask endpoints for each shared entity — agents, projects, tasks, executions, evidence, audit.
  • Static dashboard rendering the live counts and statuses.
F

Technology

PythonFlaskSQLiteHTMLJavaScript
G

Workflow

  • Every operation writes to SQLite first.
  • The API serves only what the database actually contains.
  • The dashboard renders only served data — nothing is hardcoded as a success story.
H

My Role

  • Designed the schema, built the API, built the dashboard, and loaded the initial verified records.
I

Demo

Inspectable on request

The database, API, and dashboard can be demonstrated live by request.

K

Source

  • AETHELION/core/db.sqlite — verified real file.
  • AETHELION/core/api/app.py — Flask API source.
  • AETHELION/core/dashboard/index.html — operations dashboard.
L

Status

Verified

  • SQLite database exists with 6 tables and real rows.
  • Flask API responds with verified database status.
  • Dashboard exists and displays only real counts.
  • Parameterized queries — no raw string interpolation into SQL.

Planned / Out of scope

  • Public hosting of the dashboard.
  • Additional automation around CRUD and reporting.

Separating verified from planned is a design principle of this portfolio — not a footnote.

No live URL is shown because this project is not publicly deployed. If that changes, the link appears here automatically.