SQ

sqlcoder 7b 2

SqlcoderGGUF by MaziyarPanahiUpdated 2024-02-13
Download on Hugging Face
Parameters6.74B
Context16K
Layers32
Architecturellama
Smallest quant2.5 GB
Quick answer

sqlcoder 7b 2 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 11 quants, from 2.5 GB (Q2_K) to 13.5 GB.

SQLCoder 7B‑2: A 7‑billion‑parameter model for natural‑language to SQL conversion

SQLCoder 7B‑2 is a 7‑billion‑parameter Llama‑based model fine‑tuned for translating natural language queries into SQL. It supports a 16,384‑token context window and is released under a CC‑BY‑SA‑4.0 license. The model is optimized for read‑only database analytics.

Good at

  • Natural‑language to SQL generation
  • SQL query optimization
  • Read‑only database analytics

Limits

  • No vision support
  • Requires read‑only database access
  • Large VRAM needed for higher quants

Best for

  • Generating SQL from plain English queries
  • Automating data analysis tasks
  • Building analytics chatbots

Who it’s for. Developers and analysts who need to convert natural language questions into SQL for read‑only databases. The model is suitable for building analytics tools and chat interfaces that query existing data stores.

Quants & memory

QuantFileEst. memoryvs VRAMResultDownload
Q2_K2.5 GB 7.3 GB
Tight Get file →
Q3_K_S2.9 GB 7.7 GB
Tight Get file →
Q3_K_M3.3 GB 8.1 GB
Too big Get file →
Q3_K_L3.6 GB 8.4 GB
Too big Get file →
Q4_K_S3.9 GB 8.7 GB
Too big Get file →
Q4_K_M4.1 GB 8.9 GB
Too big Get file →
Q5_K_S4.7 GB 9.4 GB
Too big Get file →
Q5_K_M4.8 GB 9.6 GB
Too big Get file →
Q6_K5.5 GB 10.3 GB
Too big Get file →
Q8_07.2 GB 12.0 GB
Too big Get file →
—13.5 GB 18.3 GB
Too big Get file →

For 8 GB VRAM, use Q4_K_M (≈4.08 GB file, ~8.9 GB VRAM). For 12 GB VRAM, Q4_K_S or Q5_K_S are suitable. For 18 GB VRAM, Q8_0 (≈7.16 GB file, ~12 GB VRAM) offers higher precision. Memory estimates are approximate.

What GPU do you need for sqlcoder 7b 2?

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).
  • 16 GB VRAM: the best quant that fits is Q8_0 (7.2 GB file, about 12.0 GB in use).
  • 24 GB VRAM: the best quant that fits is the main file (13.5 GB file, about 18.3 GB in use).

Which sqlcoder 7b 2 quant should you choose?

Q4_K_M is the usual starting point for sqlcoder 7b 2: 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.5 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
Parameters6.74B
Layers32
Trained context16,384 tokens
KV cache (fp16)512 KB per token

Source

Quantized byMaziyarPanahi
FamilySqlcoder
Downloads (HF)46,069
Last updated2024-02-13

Frequently asked questions about sqlcoder 7b 2

How much VRAM does sqlcoder 7b 2 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 sqlcoder 7b 2 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 sqlcoder 7b 2 GGUF?

It depends on the quant: Q2_K is 2.5 GB, Q3_K_S is 2.9 GB, Q3_K_M is 3.3 GB, Q3_K_L is 3.6 GB, Q4_K_S is 3.9 GB, Q4_K_M is 4.1 GB and 5 more.

What context length does sqlcoder 7b 2 support?

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

Where can I download sqlcoder 7b 2 GGUF?

The files are on Hugging Face in the MaziyarPanahi/sqlcoder-7b-2-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 sqlcoder 7b 2 use?

Hugging Face lists the license as cc-by-sa-4.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 SQLCoder 7B‑2 on 8 GB VRAM?

Yes, using the Q4_K_M quantization which requires about 8.9 GB VRAM at 8k context.

Does SQLCoder 7B‑2 support image inputs?

No, the model has no vision capabilities.

Other GGUFs of sqlcoder-7b-2

Similar models

Browse all →

More from MaziyarPanahi

All by MaziyarPanahi →

More Sqlcoder models

All Sqlcoder →

Other small models

All small models →