4 Downloads Updated 4 months ago
ollama run NiChr0/schemalytics-classification-agent
schemalytics-classification-agent classifies database tables as fact, dimension, bridge, or reference — the first step in building a dimensional data model (star schema).
It is Agent 3 in the Schemalytics pipeline, which transforms PostgreSQL databases into dbt projects and semantic layers for self-service analytics.
Fine-tune details
Base model: Qwen3.5-4B by Alibaba Cloud (Qwen License) Method: QLoRA (r=8, lora_alpha=16) via Unsloth on NVIDIA RTX 3060 Ti Training examples: 327 (train loss: 0.055 · eval loss: 0.058 — no overfitting) Schemas trained on: GLPI (441 tables), OpenEMR (282), PrestaShop (242), OpenCart (136), Icinga (66), Northwind, Sakila, Chinook, AdventureWorks, and 200+ Spider benchmark schemas Quantization: Q4_K_M (2.6 GB) Usage
ollama pull nichr0/schemalytics-classification-agent
SCHEMALYTICS_OLLAMA_MODEL=nichr0/schemalytics-classification-agent
schemalytics generate -c postgresql://… -o ./dbt_project
Attribution: Built on Qwen3.5 by Alibaba Cloud, licensed under the Qwen License.