Llama-2-7B-instruct-text2sql needs about 8.9 GB of memory at Q4_K_M (a 4.1 GB file) with an 8K context window, so it fits on a 12 GB GPU. This repository has 22 quants, from 1.7 GB (Q5_K_M) to 7.2 GB (Q8_0).
Fine‑tuned Llama‑2‑7B for text‑to‑SQL generation
Llama‑2‑7B‑instruct‑text2sql is a 6.74 billion‑parameter model fine‑tuned for converting natural language questions into SQL queries. It uses a 4096‑token context window and is trained on the bugdaryan/sql‑create‑context‑instruction dataset.
Good at
- Text‑to‑SQL conversion
- Schema‑aware query generation
- Natural language understanding
Limits
- No vision support
- No explicit license information
- Requires 8 k context for full performance
Best for
- Generating SQL from user queries
- Automating database query creation
- Assisting developers with schema‑based tasks
Who it’s for. Developers and data engineers needing a lightweight model to translate natural language into SQL. It is suitable for integration into chatbots or data‑analysis tools where a 4096‑token context is sufficient.
Quants & memory
| Quant | File | Est. memory | vs VRAM | Result | |
|---|---|---|---|---|---|
| Q5_K_M | 1.7 GB | 4.4 GB | Fits | Get file → | |
| Q2_K | 2.5 GB | 5.2 GB | Fits | Get file → | |
| IQ3_XS | 2.8 GB | 5.4 GB | Fits | Get file → | |
| IQ3_S | 2.9 GB | 5.6 GB | Fits | Get file → | |
| Q3_K_S | 2.9 GB | 5.6 GB | Fits | Get file → | |
| IQ3_M | 3.1 GB | 5.8 GB | Fits | Get file → | |
| Q3_K | 3.3 GB | 5.9 GB | Fits | Get file → | |
| Q3_K_M | 3.3 GB | 5.9 GB | Fits | Get file → | |
| Q5_K | 3.5 GB | 6.1 GB | Fits | Get file → | |
| Q3_K_L | 3.6 GB | 6.2 GB | Fits | Get file → | |
| IQ4_XS | 3.6 GB | 6.3 GB | Fits | Get file → | |
| Q4_0 | 3.8 GB | 6.5 GB | Fits | Get file → | |
| IQ4_NL | 3.8 GB | 6.5 GB | Fits | Get file → | |
| Q4_K_S | 3.9 GB | 6.5 GB | Fits | Get file → | |
| Q4_K | 4.1 GB | 6.7 GB | Fits | Get file → | |
| Q4_K_M | 4.1 GB | 6.7 GB | Fits | Get file → | |
| Q5_K_S | 4.1 GB | 6.7 GB | Fits | Get file → | |
| Q4_1 | 4.2 GB | 6.9 GB | Fits | Get file → | |
| Q5_0 | 4.7 GB | 7.3 GB | Tight | Get file → | |
| Q5_1 | 5.1 GB | 7.7 GB | Tight | Get file → | |
| Q6_K | 5.5 GB | 8.2 GB | Too big | Get file → | |
| Q8_0 | 7.2 GB | 9.8 GB | Too big | Get file → |
For 8 GB VRAM, Q5_K_M (1.75 GB file, 6.5 GB memory) is a good choice. If 12 GB VRAM is available, Q8_0 (7.16 GB file, 12 GB memory) offers higher precision. Smaller quants like Q2_K (2.53 GB file, 7.3 GB memory) fit 8 GB VRAM but use more memory than the file size suggests.
What GPU do you need for Llama-2-7B-instruct-text2sql?
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: no quant fits at an 8K context.
- 6 GB VRAM: no quant fits at an 8K context.
- 8 GB VRAM: the best quant that fits is IQ3_M (3.1 GB file, about 7.9 GB in use).
- 12 GB VRAM: the best quant that fits is Q8_0 (7.2 GB file, about 12.0 GB in use).
Which Llama-2-7B-instruct-text2sql quant should you choose?
Q4_K_M is the usual starting point for Llama-2-7B-instruct-text2sql: it balances file size and quality well. Here it is a 4.1 GB file.
The Q8_0 file is 7.2 GB, about 1.8 times the size of Q4_K_M. It keeps the weights closer to the original, which only matters if you have the memory to spare.
If memory is tight, the smallest file is Q5_K_M at 1.7 GB, with the quality trade-offs that come with fewer bits. Closer to the original model than 4-bit, for a moderate increase in size. A good pick when you have memory to spare.
New to quant names? Read GGUF quantization explained.
Specifications
Architecture from the GGUF header
Frequently asked questions about Llama-2-7B-instruct-text2sql
How much VRAM does Llama-2-7B-instruct-text2sql need?
About 8.9 GB at Q4_K_M with an 8K context window. That is the 4.1 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 Llama-2-7B-instruct-text2sql on an 8 GB GPU?
Yes, with IQ3_M: the 3.1 GB file needs about 7.9 GB at 8K context. Larger quants in this repository do not fit in 8 GB.
What is the file size of Llama-2-7B-instruct-text2sql GGUF?
It depends on the quant: Q5_K_M is 1.7 GB, Q2_K is 2.5 GB, IQ3_XS is 2.8 GB, IQ3_S is 2.9 GB, Q3_K_S is 2.9 GB, IQ3_M is 3.1 GB and 16 more.
What context length does Llama-2-7B-instruct-text2sql support?
The GGUF header lists a trained context length of 4,096 tokens (4K). The KV cache grows with the context you use: about 4.3 GB at 8K and 2.1 GB at 4K.
Where can I download Llama-2-7B-instruct-text2sql GGUF?
The files are on Hugging Face in the RichardErkhov/support-pvelocity_-_Llama-2-7B-instruct-text2sql-gguf repository. The download buttons on this page open the file on Hugging Face. ggufmodels.com does not host any model files.
Can I run Llama‑2‑7B‑instruct‑text2sql on 8 GB VRAM?
Yes, the Q5_K_M quant uses 6.5 GB memory at 8 k context, fitting within 8 GB VRAM.
What is the context length of this model?
The model supports 4096 tokens of context.
Does this model support vision tasks?
No, it is a text‑only model.