CORE
The evidence layer behind the company.
Internal prototype — architecture proven locally, not exposed publicly.

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.
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.
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.
Architecture
INTENT: this is the actual design the system was built against — not a decorative diagram.
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.
Technology
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.
My Role
- Designed the schema, built the API, built the dashboard, and loaded the initial verified records.
Demo
Inspectable on request
The database, API, and dashboard can be demonstrated live by request.
Source
- AETHELION/core/db.sqlite — verified real file.
- AETHELION/core/api/app.py — Flask API source.
- AETHELION/core/dashboard/index.html — operations dashboard.
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.