nsql llama 2 7B 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 12 quants, from 2.8 GB (Q2_K) to 7.2 GB (Q8_0).
NSQL Llama‑2 7B – a SQL‑focused Llama‑2 7B model
NSQL Llama‑2 7B is a 6.74 billion‑parameter Llama‑2 7B model fine‑tuned for SQL generation. It is available in GGUF format and supports 4096‑token context. The model is released under the llama2 license.
Good at
- SQL generation
- Complex query handling
- Privacy‑preserving local deployment
Limits
- No vision support
- Requires 8 k context for memory estimates
- License is llama2
Best for
- Generating SQL from natural language
- Evaluating complex database queries
- Local deployment on commodity GPUs
Who it’s for. Developers and data engineers needing a lightweight, local SQL generation model. The model is suitable for environments where data privacy is critical and GPU resources are limited.
Quants & memory
| Quant | File | Est. memory | vs VRAM | Result | |
|---|---|---|---|---|---|
| Q2_K | 2.8 GB | 5.5 GB | Fits | Get file → | |
| Q3_K_S | 2.9 GB | 5.6 GB | Fits | Get file → | |
| Q3_K_M | 3.3 GB | 5.9 GB | Fits | Get file → | |
| Q3_K_L | 3.6 GB | 6.2 GB | Fits | Get file → | |
| Q4_0 | 3.8 GB | 6.5 GB | Fits | Get file → | |
| Q4_K_S | 3.9 GB | 6.5 GB | Fits | Get file → | |
| Q4_K_M | 4.1 GB | 6.7 GB | Fits | Get file → | |
| Q5_0 | 4.7 GB | 7.3 GB | Tight | Get file → | |
| Q5_K_S | 4.7 GB | 7.3 GB | Tight | Get file → | |
| Q5_K_M | 4.8 GB | 7.4 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 use Q4_K or Q4_K_S (file size 3.83 GB, memory 8.6 GB). For 12 GB VRAM Q8_0 (file size 7.16 GB, memory 12 GB) offers higher precision. Lower‑bit quants such as Q2_K (file size 2.83 GB, memory 7.6 GB) fit on 6 GB VRAM but reduce accuracy.
What GPU do you need for nsql llama 2 7B?
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 Q3_K_S (2.9 GB file, about 7.7 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 nsql llama 2 7B quant should you choose?
Q4_K_M is the usual starting point for nsql llama 2 7B: 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 Q2_K at 2.8 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
Source
Frequently asked questions about nsql llama 2 7B
How much VRAM does nsql llama 2 7B 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 nsql llama 2 7B on an 8 GB GPU?
Yes, with Q3_K_S: the 2.9 GB file needs about 7.7 GB at 8K context. Larger quants in this repository do not fit in 8 GB.
What is the file size of nsql llama 2 7B GGUF?
It depends on the quant: Q2_K is 2.8 GB, Q3_K_S is 2.9 GB, Q3_K_M is 3.3 GB, Q3_K_L is 3.6 GB, Q4_0 is 3.8 GB, Q4_K_S is 3.9 GB and 6 more.
What context length does nsql llama 2 7B 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 nsql llama 2 7B GGUF?
The files are on Hugging Face in the TheBloke/nsql-llama-2-7B-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 nsql llama 2 7B use?
Hugging Face lists the license as llama2. 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 NSQL Llama‑2 7B on 8 GB VRAM?
Yes, use the Q4_K or Q4_K_S GGUF file which requires approximately 8.6 GB of VRAM at 8 k context.
Does the model support image input?
No, the model has no vision capabilities.
What license applies to this model?
The model is released under the llama2 license.