LL

Text to Sql llama3.1 8B i1

LlamaGGUF by mradermacherUpdated 2025-03-03
Download on Hugging Face
Parameters8.03B
Context128K
Layers32
Architecturellama
Smallest quant2.0 GB
Quick answer

Text to Sql llama3.1 8B i1 needs about 6.5 GB of memory at Q4_K_M (a 4.9 GB file) with an 8K context window, so it fits on a 8 GB GPU. This repository has 24 quants, from 2.0 GB (IQ1_S) to 6.6 GB (Q6_K). Longer context needs more: at 32K tokens the KV cache alone adds about 4.3 GB.

Fine‑tuned Llama‑3.1 8B for Text‑to‑SQL

Text to Sql llama3.1 8B i1 is a fine‑tuned causal language model based on unsloth/Meta‑Llama‑3.1‑8B. It was trained on the first 5000 rows of the Clinton/Text‑to‑sql‑v1 dataset using LoRA adapters. The model is released under the apache‑2.0 license.

Good at

  • Text‑to‑SQL generation
  • English language queries
  • Causal language modeling

Limits

  • Limited to 131072 context tokens
  • May produce incorrect SQL for unclear prompts
  • No vision support

Best for

  • Generating SQL from natural language
  • Rapid prototyping of database queries
  • Educational demos

Who it’s for. Developers and researchers needing a lightweight Text‑to‑SQL model. The model is suitable for projects that can accommodate a 8.03B parameter size and the provided quantizations.

Quants & memory

QuantFileEst. memoryvs VRAMResultDownload
IQ1_S2.0 GB 3.6 GB
Fits Get file →
IQ1_M2.2 GB 3.7 GB
Fits Get file →
IQ2_XXS2.4 GB 4.0 GB
Fits Get file →
IQ2_XS2.6 GB 4.2 GB
Fits Get file →
IQ2_S2.8 GB 4.3 GB
Fits Get file →
IQ2_M2.9 GB 4.5 GB
Fits Get file →
Q2_K_S3.0 GB 4.6 GB
Fits Get file →
Q2_K3.2 GB 4.8 GB
Fits Get file →
IQ3_XXS3.3 GB 4.8 GB
Fits Get file →
IQ3_XS3.5 GB 5.1 GB
Fits Get file →
Q3_K_S3.7 GB 5.2 GB
Fits Get file →
IQ3_S3.7 GB 5.3 GB
Fits Get file →
IQ3_M3.8 GB 5.4 GB
Fits Get file →
Q3_K_M4.0 GB 5.6 GB
Fits Get file →
Q3_K_L4.3 GB 5.9 GB
Fits Get file →
IQ4_XS4.4 GB 6.0 GB
Fits Get file →
Q4_04.7 GB 6.2 GB
Fits Get file →
IQ4_NL4.7 GB 6.3 GB
Fits Get file →
Q4_K_S4.7 GB 6.3 GB
Fits Get file →
Q4_K_M4.9 GB 6.5 GB
Fits Get file →
Q4_15.1 GB 6.7 GB
Fits Get file →
Q5_K_S5.6 GB 7.2 GB
Fits Get file →
Q5_K_M5.7 GB 7.3 GB
Tight Get file →
Q6_K6.6 GB 8.2 GB
Too big Get file →

For 8 GB VRAM, use Q4_K_M (4.92 GB file, ~6.5 GB memory at 8k context). For 12 GB VRAM, Q5_K_M (5.73 GB file, ~7.3 GB memory). For 16 GB VRAM, Q6_K (6.6 GB file, ~8.2 GB memory). All estimates are approximate.

What GPU do you need for Text to Sql llama3.1 8B i1?

These figures add the file size, an fp16 KV cache at an 8K context window (worked out from this model’s own header) and about 0.5 GB for the runtime. They are estimates, so leave a little headroom, and expect to use less context or a smaller quant if you are right at the limit.

  • 4 GB VRAM: the best quant that fits is IQ2_XXS (2.4 GB file, about 4.0 GB in use).
  • 6 GB VRAM: the best quant that fits is IQ4_XS (4.4 GB file, about 6.0 GB in use).
  • 8 GB VRAM: the best quant that fits is Q5_K_M (5.7 GB file, about 7.3 GB in use).
  • 12 GB VRAM: the best quant that fits is Q6_K (6.6 GB file, about 8.2 GB in use).

Which Text to Sql llama3.1 8B i1 quant should you choose?

Q4_K_M is the usual starting point for Text to Sql llama3.1 8B i1: it balances file size and quality well. Here it is a 4.9 GB file.

If memory is tight, the smallest file is IQ1_S at 2.0 GB, with the quality trade-offs that come with fewer bits. Use it only when memory is very tight. Expect a clear drop in quality, which is usually worse on small models and easier to live with on large ones.

New to quant names? Read GGUF quantization explained.

Specifications

Architecture from the GGUF header

Architecturellama
Parameters8.03B
Layers32
Trained context131,072 tokens
KV cache (fp16)128 KB per token

Source

Quantized bymradermacher
FamilyLlama
Licenseapache-2.0
Downloads (HF)722
Last updated2025-03-03

Frequently asked questions about Text to Sql llama3.1 8B i1

How much VRAM does Text to Sql llama3.1 8B i1 need?

About 6.5 GB at Q4_K_M with an 8K context window. That is the 4.9 GB file, plus the KV cache and roughly 0.5 GB of runtime overhead. Smaller quants need less and longer context needs more.

Can I run Text to Sql llama3.1 8B i1 on an 8 GB GPU?

Yes, with Q5_K_M: the 5.7 GB file needs about 7.3 GB at 8K context. Larger quants in this repository do not fit in 8 GB.

What is the file size of Text to Sql llama3.1 8B i1 GGUF?

It depends on the quant: IQ1_S is 2.0 GB, IQ1_M is 2.2 GB, IQ2_XXS is 2.4 GB, IQ2_XS is 2.6 GB, IQ2_S is 2.8 GB, IQ2_M is 2.9 GB and 18 more.

What context length does Text to Sql llama3.1 8B i1 support?

The GGUF header lists a trained context length of 131,072 tokens (128K). The KV cache grows with the context you use: about 1.1 GB at 8K and 4.3 GB at 32K.

Where can I download Text to Sql llama3.1 8B i1 GGUF?

The files are on Hugging Face in the mradermacher/Text-to-Sql-llama3.1-8B-i1-GGUF repository. The download buttons on this page open the file on Hugging Face. ggufmodels.com does not host any model files.

What license does Text to Sql llama3.1 8B i1 use?

Hugging Face lists the license as apache-2.0. Licenses can differ between the quantized files and the original model, so check the repository and the base model before commercial use.

Can I run this model on 8 GB VRAM?

Yes, the Q4_K_M quant uses about 6.5 GB memory at 8k context, fitting within 8 GB VRAM.

Does the model support vision inputs?

No, the model is a text‑only causal language model.

What license applies to this model?

The model is released under the apache‑2.0 license.

Other GGUFs of Text-to-Sql-llama3.1-8B

Similar models

Browse all →

More from mradermacher

All by mradermacher →

More Llama models

All Llama →

Other small models

All small models →