Skip to content
Other

Qwen3.5-2B Text-to-SQL LoRA v2

второй адаптер для точного SQL

2 min readupdated

Это второй LoRA-адаптер для Qwen/Qwen3.5-2B в thinking mode. Он ставится поверх v1: сначала нужно merge v1 в базовую модель, затем применить v2. v1 учил короткому структурированному reasoning на 10 тыс. execution-verified примеров SynSQL-2.5M, а v2 — rejection-sampled self-distillation на реальных базах BIRD.

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

  • Ставится поверх v1: сначала merge v1 в базу, затем v2.
  • Обучен на 5 026 вопросах BIRD train: по 4 попытки, 2 349 execution-correct ответов, shortest correct в среднем 429 токенов, плюс 3 000 новых строк SynSQL.
  • В harness vote@8 + execution repair даёт 42.07% на BIRD dev и 72.44% на Spider dev.
  • Только английский и SQLite; один sample слабее base на BIRD — нужен цикл sample → repair → vote.
  • LoRA r=16, alpha=32, dropout 0.05 на attention, linear-attention и MLP всех 24 слоёв; 0.7 GPU-hours на RTX PRO 6000.

Пример

from peft import PeftModel
from transformers import AutoModelForImageTextToText, AutoTokenizer
base = AutoModelForImageTextToText.from_pretrained("Qwen/Qwen3.5-2B", dtype="bfloat16")
v1 = PeftModel.from_pretrained(base, "Thegame1161/qwen35-2b-text2sql-lora-v1").merge_and_unload()
model = PeftModel.from_pretrained(v1, "Thegame1161/qwen35-2b-text2sql-lora-v2").merge_and_unload()
tok = AutoTokenizer.from_pretrained("Qwen/Qwen3.5-2B")
ПодробнееBIRD dev: 42.07%, Spider dev: 72.44% в режиме vote@8 + execution repair.
Один sample даёт 29.09% на BIRD dev — ниже base с длинным thinking.
Обучение: 343 шага, 5 046 примеров, 0.7 GPU-hours на одной RTX PRO 6000.
Ограничения: английский и SQLite; ниже XiYanSQL-QwenCoder-3B (52.19% / 85.20%).
Discuss Telegram 0 20

Will it run?

Runs in BF16

Fits without quantisation.

  • BF16weights 4.3 GB · ready files5.2 GB
  • FP8 / INT8recommendedweights 2.2 GB2.9 GB
  • 4-bitweights 1.2 GB1.9 GB

Tip: go 8-bit.FP8 / INT8 is within about a percent of full precision in quality, takes half the memory and runs faster on RTX 40/50 and H100. Full precision only pays off for fine-tuning.

What to get for this model

Massed ComputeOpen Massed Compute

Your own GPU: FP8 / INT8 — from RTX 2060 · BF16 — from RTX 2060

Massed Compute hourly prices, November 2026. The discounted price applies with the coupon at checkout.

This is a LoRA: counted together with its base model Qwen3.5-2B.

Estimate: weights plus working memory. Long videos, high resolutions and long contexts need more.

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.

    # Thegame1161/qwen35-2b-text2sql-lora-v2
    # ===== Tokens: paste yours between the quotes =====
    export HF_TOKEN=""        # huggingface.co/settings/tokens, for gated models
    # ==========================================
    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 Qwen/Qwen3.5-2B --local-dir ~/models/Qwen3.5-2B
    hf download Thegame1161/qwen35-2b-text2sql-lora-v2 --local-dir ~/models/qwen35-2b-text2sql-lora-v2
    # The model is in ~/models. How to run it is in the model card (link above).
    Add more LoRAs to Qwen3.5-2B
  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.

Model family

Requires the base model

Qwen/Qwen3.5-2B

This model is a LoRA / adapter. Download the base model first, then load this one on top.

  1. Qwen3.5-2B-Basefamily root
  2. Qwen3.5-2B
  3. qwen35-2b-text2sql-lora-v2

New posts about versions of Qwen3.5-2B-Base (quants, finetunes, LoRAs) will show up under the bell.

Quantised versions 12All on Hugging Face
Fine-tunes 12All on Hugging Face
LoRAs and adapters 10All on Hugging Face
Merges 2All on Hugging Face

About the model

Thegame1161/qwen35-2b-text2sql-lora-v2
Author
Thegame1161
Category
Other
Released
Posted

On NeyroLearn

Hugging Face

200

Ask AI about this model

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

Comments