LL

sepctrum ties sqlcoder 8b

LlamaGGUF by QuantFactoryUpdated 2024-08-25
Download on Hugging Face
Parameters8.03B
Context8K
Layers32
Architecturellama
Smallest quant3.2 GB
Quick answer

sepctrum ties sqlcoder 8b 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 14 quants, from 3.2 GB (Q2_K) to 8.5 GB (Q8_0).

8B Llama model fine‑tuned for SQL generation

sepctrum ties sqlcoder 8b is a 8.03B‑parameter Llama model trained for text‑to‑SQL tasks. It supports PostgreSQL, Redshift and Snowflake. The model is available in multiple GGUF quantizations.

Good at

  • SQL generation
  • PostgreSQL queries
  • Redshift and Snowflake support

Limits

  • No vision support
  • No license information provided
  • Context length limited to 8192 tokens

Best for

  • Generating SQL from natural language
  • Automating database queries
  • Testing SQL scripts

Who it’s for. Developers and data analysts who need accurate SQL from plain language. It is suitable for projects requiring PostgreSQL, Redshift or Snowflake compatibility.

Quants & memory

QuantFileEst. memoryvs VRAMResultDownload
Q2_K3.2 GB 4.8 GB
Fits Get file →
Q3_K_S3.7 GB 5.2 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 →
Q4_04.7 GB 6.2 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_05.6 GB 7.2 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 →
Q5_16.1 GB 7.6 GB
Tight Get file →
Q6_K6.6 GB 8.2 GB
Too big Get file →
Q8_08.5 GB 10.1 GB
Too big Get file →

For 8 GB VRAM, Q4_0 (4.66 GB, 6.2 GB memory) or Q4_K_S (4.69 GB, 6.3 GB memory) are suitable. For 12 GB VRAM, Q5_0 (5.6 GB, 7.2 GB memory) or Q5_K_M (5.73 GB, 7.3 GB memory) provide better quality. Larger models like Q6_K or Q8_0 require more than 10 GB memory.

What GPU do you need for sepctrum ties sqlcoder 8b?

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: the best quant that fits is Q3_K_L (4.3 GB file, about 5.9 GB in use).
  • 8 GB VRAM: the best quant that fits is Q5_1 (6.1 GB file, about 7.6 GB in use).
  • 12 GB VRAM: the best quant that fits is Q8_0 (8.5 GB file, about 10.1 GB in use).

Which sepctrum ties sqlcoder 8b quant should you choose?

Q4_K_M is the usual starting point for sepctrum ties sqlcoder 8b: it balances file size and quality well. Here it is a 4.9 GB file.

The Q8_0 file is 8.5 GB, about 1.7 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 3.2 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 context8,192 tokens
KV cache (fp16)128 KB per token

Source

Quantized byQuantFactory
FamilyLlama
Downloads (HF)747
Last updated2024-08-25

Frequently asked questions about sepctrum ties sqlcoder 8b

How much VRAM does sepctrum ties sqlcoder 8b 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 sepctrum ties sqlcoder 8b on an 8 GB GPU?

Yes, with Q5_1: the 6.1 GB file needs about 7.6 GB at 8K context. Larger quants in this repository do not fit in 8 GB.

What is the file size of sepctrum ties sqlcoder 8b GGUF?

It depends on the quant: Q2_K is 3.2 GB, Q3_K_S is 3.7 GB, Q3_K_M is 4.0 GB, Q3_K_L is 4.3 GB, Q4_0 is 4.7 GB, Q4_K_S is 4.7 GB and 8 more.

What context length does sepctrum ties sqlcoder 8b support?

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

Where can I download sepctrum ties sqlcoder 8b GGUF?

The files are on Hugging Face in the QuantFactory/sepctrum-ties-sqlcoder-8b-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 this model on 8 GB VRAM?

Yes, use Q4_0 or Q4_K_S quantizations; they require about 6.2–6.3 GB memory at 8k context.

What context length does this model support?

The model supports up to 8192 tokens of context.

Does this model support vision tasks?

No, the model is text‑only and does not support vision.

Other GGUFs of llama-3-sqlcoder-8b

Similar models

Browse all →

More from QuantFactory

All by QuantFactory →

More Llama models

All Llama →

Other small models

All small models →