Skip to main content

STEWARD

Desktop personal assistant on Electron, FastAPI, and single-file SQLite vector storage, handling background tasks and overnight contradiction checks.
Autonomous Agents
Active Local System
CATEGORY
Autonomous Agents
STACK
Electron · Python 3.12 · SQLite-Vec
STATUS
Active Local System
Conflicting Notes
Stale Duplicates
Account Requirement
Cloud Sign-Up
Storage Footprint
Multi-DB Setup
Long Tasks
Blocked UI Thread
Voice Mode
Separate Utility
Model Routing
Cloud Required
Memory Hygiene
Never Pruned
Offline Posture
Unavailable
Conflicting Notes
Resolved w/ Log
Account Requirement
Zero Accounts
Storage Footprint
Single SQLite
Long Tasks
Async Python Core
Voice Mode
Native Audio
Model Routing
Local or Cloud
Memory Hygiene
Overnight Audit
Offline Posture
Local-First
MEDIA FORMAT NOTE

Promotional presentation: motion film showcasing Steward's overnight contradiction-resolution receipt and local architecture (reconstructed visuals).

Attribution: Joaquin Villarreal · Local Workstation Memory & Voice Assistant.

Overview & Problem Addressed

Steward is a local-first desktop assistant combining an Electron interface with a Python 3.12 FastAPI engine and unified SQLite + `sqlite-vec` memory storage. It runs long tasks, voice input, and scheduled consistency checks on the operator's own machine.

Capabilities & Workflow Execution

Note stores drift out of sync over months as travel dates change, vendor contacts move, and priorities shift. Steward runs background consolidation passes that surface conflicting records in plain language and log which value it kept.

Executive Assistant Support & Application

Keeps long-running executive preference notes consistent across quarters, preventing outdated location settings or superseded rules from creeping into daily prep while storing everything in one local file.

Configured Implementation

Desktop shell (`desktop/`), Python 3.12 FastAPI core with `aiosqlite` and `sqlite-vec` hybrid full-text and vector indexing, hardware firmware hooks, and Pydantic validation.

Operational State & Availability

Maintained on local workstation setups. The video is a reconstructed motion presentation focused on the contradiction-receipt behavior.

AVAILABILITY & DIRECT CONTACT

Want to discuss this project or set up a similar workflow? Write to jevillarreal170@gmail.com and I will gladly share what can be shown.

Public repository links stay unpublished while private configs, credentials, and environment records remain offline. No confidential company data or invented dates appear here.