Data Storage & The Knowledge Core
ANDARTIS is designed with a strict "Zero Data Egress" mandate. All documents, extracted metadata, vector indices, and neural weights are stored locally on your machine.
The Knowledge Base (SQLite)
To guarantee high scalability, zero lock contention, and simple backup processes, ANDARTIS uses an Isolated Node Core design.
Rather than storing all user data in a single massive database, each added directory (Intelligence Node) gets its own isolated SQLite database file.
Main Database (main.sqlite)
Acts as a registry and orchestrator schema:
intelligence_nodes: Registry of directory paths, titles, and config states.capabilities: Definitions, active weights paths, and options for registered brains.projects: Visual group containers for grouping related intelligence nodes under project namespaces.node_capabilities: Pivot table mapping nodes to capabilities and tracking training/activation status.cross_reasoning_groups: Groups of nodes within a project namespace configured for cross-node reasoning.
Node Database (node_{id}/core.sqlite)
Stores the raw and structured representations of your documents:
documents: Reference metadata, unique file paths, hashes, and document-level metadata (containing schema extractions per file).document_chunks: Fragmented sections of document content (plain text) along with chunk-level metadata for fine-grained retrieval.
Neural Weights (.npz / .safetensors)
While textual metadata resides in SQLite, the weights representing trained models are stored in the local file system.
File Structure per Node
Each intelligence node has a corresponding directory in the storage folder:
storage/models/node_{id}/
├── weights.npz # Learned parameters of MLX models
├── index.npz # High-speed index for semantic navigation
└── metadata.json # Configuration file (vocab, tokenizers)weights.npz: Stores custom layers adjusted during training.index.npz: An optimized array for nearest-neighbor search, allowing sub-millisecond semantic matching.
NativePHP Directory Mapping
When packaged for production, directories follow standard operating system application support conventions:
macOS Application Storage
~/Library/Application Support/andartis/Windows Application Storage
%APPDATA%\andartis\Privacy & Security
IMPORTANT
ANDARTIS does not provide an internal network layer or cloud sync tool. All operations are local-only.
- Physical Isolation: ANDARTIS reads documents from folders you choose. It does not copy, upload, or move them.
- Encryption-at-Rest Compatibility: Because the backend uses standardized files (SQLite, safetensors, JSON), you can secure your intelligence nodes using native system-level utilities like macOS FileVault or Windows BitLocker.
- No Telemetry: There are no tracking scripts, telemetry calls, or remote metrics. The app functions entirely air-gapped.