Skip to content
Language models

InfoFrota Text-to-SQL LoRA

учит Llama 3.1 8B писать SQLite-запросы по-португальски

1 min readupdated

Это LoRA-адаптер для unsloth/Llama-3.1-8B-Instruct, который превращает вопросы на португальском в SQLite-запросы к синтетической базе проекта InfoFrota: занятость автобусов, оповещения о переполнении, линии и остановки. Обучен через QLoRA в 4-bit nf4 без retrieval-контекста.

Ключевые особенности

  • LoRA: r=16, alpha=32, dropout 0,05; модули q, k, v, o, gate, up и down.
  • Данные синтетические: 738 примеров (679 тренировка, 59 валидация), 8% отказов для вопросов вне домена или запросов на запись.
  • Обучение: 3 эпохи, эффективный batch 16, lr 2e-4 с косинусом, GPU T4 в Kaggle.
  • В карточке есть код загрузки и указание на промпты в режиме compacto.
  • Сгенерированный SQL должен проходить read-only guard в три слоя; авторы прямо запрещают продакшен.

Пример

from transformers import AutoModelForCausalLM, AutoTokenizer, BitsAndBytesConfig
from peft import PeftModel
base = 'unsloth/Llama-3.1-8B-Instruct'
tok = AutoTokenizer.from_pretrained(base)
model = AutoModelForCausalLM.from_pretrained(base, device_map='auto',
    quantization_config=BitsAndBytesConfig(load_in_4bit=True, bnb_4bit_quant_type='nf4'))
model = PeftModel.from_pretrained(model, 'David-Evora/infofrota-text2sql-lora')
ПодробнееБенчмарк v2.1, 56 вопросов zero-shot: база 19/56 (33,9%), адаптер 36/56 (64,3%).
Авторы предупреждают: данные синтетические, сложный уровень остаётся низким, у вопроса D06 известен дефект эталона.
Лицензия — Llama 3.1 Community License; PEFT 0.21.2.
Discuss Telegram 0 31

Will it run?

Working out the memory needs

The bot is still collecting this model's weight sizes; the estimate will appear here in a few minutes. Meanwhile you can rent a GPU with headroom.

Massed ComputeOpen Massed Compute

Run it on Massed Compute

The script downloads the model to the rented machine. How to run it is in the model card.

  1. 1. Rent a machine with a fitting GPU

    Open Massed Compute
  2. 2. Paste the script into the machine's terminal

    Connect over SSH (the Massed Compute panel shows the command) or open a terminal on the machine's desktop.

    HF_TOKEN / CIVITAI_TOKENThe script starts with token lines: paste yours between the quotes. The Hugging Face token is for gated models, the Civitai one for Civitai models.

    # David-Evora/infofrota-text2sql-lora
    mkdir -p ~/models
    curl -LsSf https://astral.sh/uv/install.sh | sh
    source "$HOME/.local/bin/env"
    uv tool install "huggingface_hub[cli]"
    hf download David-Evora/infofrota-text2sql-lora --local-dir ~/models/infofrota-text2sql-lora
    # The model is in ~/models. How to run it is in the model card (link above).
  3. 3. Use it

    The model is in ~/models. How to run it is in the model card (link above).

Stop the machine in the panel when you are done: it bills by the minute while it runs.

How to speed it up

Picked for this model type. Choose your hardware above to see what fits you exactly.

  • FlashAttention 44.0.0b40from November 18, 2026new release

    fastest exact attention on B200

    Kernels for Blackwell (beta). Exact attention without quantisation — fine for everything, LLMs included.

    How to enable: pip install flash-attn-4; vLLM and SGLang pick it up themselves.

    Earlier generations (2)
    • FlashAttention 3 — The Hopper (H100/H200) version with FP8.
    • FlashAttention 2 — The standard for RTX 30/40/50 and A100: exact attention without the memory cost of long contexts.
  • torch.compile2.15.0from October 28, 2026new release

    10–30% for free

    Compiles the model for your GPU. Slower first run, faster afterwards.

    How to enable: model = torch.compile(model); in ComfyUI the TorchCompileModel node.

  • MTP (multi-token prediction)0.34.0from November 16, 2026new release

    1.5–2× generation speed

    If the model has MTP layers (DeepSeek-V3/R1, Qwen3-Next, GLM, MiMo and others), it predicts several tokens per step itself.

    How to enable: vLLM / SGLang: --speculative-config '{"method": "mtp", "num_speculative_tokens": 1}'. Check the model card.

    Earlier generations (2)
    • EAGLE-3 — Speculative decoding with a small draft head. For models without their own MTP layers.
    • EAGLE-2 / Medusa — Earlier draft-head generations. Still work if that is all you find.
  • FP8 KV cache0.34.0from November 16, 2026new release

    2× more context in the same memory

    Keeps the attention cache in 8 bits, so long contexts fit where they did not.

    How to enable: vLLM: --kv-cache-dtype fp8; llama.cpp: -ctk q8_0 -ctv q8_0.

  • vLLM / SGLang0.34.0from November 16, 2026new release

    many times more tokens/s on a server

    Server engines: batching, FlashAttention, FP8 and speculative decoding out of the box.

    How to enable: vllm serve <model> — an OpenAI-compatible API.

    Earlier generations (1)
    • llama.cpp — GGUF models on any GPU, Mac or even CPU; some layers can stay in RAM.

Model family

New posts about versions of infofrota-text2sql-lora (quants, finetunes, LoRAs) will show up under the bell.

No known relatives of this model yet. All derivatives on Hugging Face

About the model

David-Evora/infofrota-text2sql-lora
Author
David-Evora
Category
Language models
Released
Posted

On NeyroLearn

Hugging Face

310

Ask AI about this model

Answered by Gemini 4 · the chat is kept only in this tab

Comments