4 4 months ago

schemalytics-classification-agent classifies database tables as fact, dimension, bridge, or reference — the first step in building a dimensional data model (star schema).

ollama run NiChr0/schemalytics-classification-agent

Details

4 months ago

06a789369041 · 2.7GB ·

qwen35
·
4.21B
·
Q4_K_M
{ "num_ctx": 12288, "num_predict": 2048, "temperature": 0 }

Readme

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.