Code-Llama-2-13B-instruct-text2sql needs about 15.1 GB of memory at Q4_K_M (a 7.9 GB file) with an 8K context window, so it fits on a 16 GB GPU. This repository has 14 quants, from 4.9 GB (Q2_K) to 13.8 GB (Q8_0).
Code‑Llama‑2‑13B‑instruct‑text2sql – fine‑tuned for text‑to‑SQL
This 13‑billion‑parameter model is a fine‑tuned version of Code‑Llama‑2 for generating SQL queries from natural language. It was trained on a dedicated text‑to‑SQL dataset and runs with llama.cpp. The model supports English only and is licensed under a custom commercial license.
Good at
- Text‑to‑SQL generation
- SQL code completion
- Instruction following
Limits
- No vision support
- Requires 8‑k context
- Commercial license only
Best for
- Building database query assistants
- Automating report generation
- Teaching SQL concepts
Who it’s for. Developers and data scientists needing an on‑premise text‑to‑SQL solution. The model is suitable for commercial and research use in English environments.
Quants & memory
| Quant | File | Est. memory | vs VRAM | Result | |
|---|---|---|---|---|---|
| Q2_K | 4.9 GB | 12.1 GB | Too big | Get file → | |
| IQ3_XS | 5.4 GB | 12.6 GB | Too big | Get file → | |
| IQ3_S | 5.7 GB | 12.9 GB | Too big | Get file → | |
| Q3_K_S | 5.7 GB | 12.9 GB | Too big | Get file → | |
| IQ3_M | 6.0 GB | 13.2 GB | Too big | Get file → | |
| Q3_K_M | 6.3 GB | 13.5 GB | Too big | Get file → | |
| Q3_K_L | 6.9 GB | 14.1 GB | Too big | Get file → | |
| IQ4_XS | 7.0 GB | 14.2 GB | Too big | Get file → | |
| Q4_K_S | 7.4 GB | 14.6 GB | Too big | Get file → | |
| Q4_K_M | 7.9 GB | 15.1 GB | Too big | Get file → | |
| Q5_K_S | 9.0 GB | 16.2 GB | Too big | Get file → | |
| Q5_K_M | 9.2 GB | 16.4 GB | Too big | Get file → | |
| Q6_K | 10.7 GB | 17.9 GB | Too big | Get file → | |
| Q8_0 | 13.8 GB | 21.0 GB | Too big | Get file → |
For 8‑GB VRAM, use Q4_K_S (file size 7.42 GB, estimated 14.6 GB RAM). For 16‑GB VRAM, Q5_K_S (8.97 GB, 16.2 GB RAM) is a good balance. If more memory is available, Q6_K (10.68 GB, 17.9 GB RAM) offers higher precision.
What GPU do you need for Code-Llama-2-13B-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: no quant fits at an 8K context.
- 12 GB VRAM: no quant fits at an 8K context.
- 16 GB VRAM: the best quant that fits is Q4_K_M (7.9 GB file, about 15.1 GB in use).
- 24 GB VRAM: the best quant that fits is Q8_0 (13.8 GB file, about 21.0 GB in use).
Which Code-Llama-2-13B-instruct-text2sql quant should you choose?
Q4_K_M is the usual starting point for Code-Llama-2-13B-instruct-text2sql: it balances file size and quality well. Here it is a 7.9 GB file.
The Q8_0 file is 13.8 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 4.9 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
Frequently asked questions about Code-Llama-2-13B-instruct-text2sql
How much VRAM does Code-Llama-2-13B-instruct-text2sql need?
About 15.1 GB at Q4_K_M with an 8K context window. That is the 7.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 Code-Llama-2-13B-instruct-text2sql on an 8 GB GPU?
Not at an 8K context. The smallest file needs about 12.1 GB, so you would need a larger GPU or CPU offloading.
What is the file size of Code-Llama-2-13B-instruct-text2sql GGUF?
It depends on the quant: Q2_K is 4.9 GB, IQ3_XS is 5.4 GB, IQ3_S is 5.7 GB, Q3_K_S is 5.7 GB, IQ3_M is 6.0 GB, Q3_K_M is 6.3 GB and 8 more.
What context length does Code-Llama-2-13B-instruct-text2sql support?
The GGUF header lists a trained context length of 16,384 tokens (16K). The KV cache grows with the context you use: about 6.7 GB at 8K and 13.4 GB at 16K.
Where can I download Code-Llama-2-13B-instruct-text2sql GGUF?
The files are on Hugging Face in the mradermacher/Code-Llama-2-13B-instruct-text2sql-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 Code-Llama-2-13B-instruct-text2sql 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 this model on 8 GB VRAM?
Yes, with the Q4_K_S quant, which requires about 14.6 GB of RAM at 8‑k context.
Does this model support other languages?
No, it is trained and intended for English only.
What license applies to this model?
It is governed by a custom commercial license from Code Llama.