SQLCoder 7B v2 on NVIDIA GeForce RTX 4070 SUPER

Can the NVIDIA GeForce RTX 4070 SUPER run SQLCoder 7B v2?

Yes, it runs great

Runs great. At Q4_K_M it needs about 9.6 GB of 12.0 GB usable, with an estimated speed of 91.8 tok/s.

Best quant: Q4_K_M
Generation speed: 91.8 tok/s
Prompt processing: 3,792 tok/s
First token (1K prompt): 0.3 s
Largest safe context: 12K

Best app to run it on the NVIDIA GeForce RTX 4070 SUPER

On Windows

LM Studio

Desktop app · runs on llama.cpp, MLX

Point-and-click: search, download and chat in one window.

Open SQLCoder 7B v2 in LM Studio

llama.cpp Usually the first to support new model architectures.
Ollama Runs the Hugging Face GGUF with ollama run hf.co/…

On Linux

LM Studio

Desktop app · runs on llama.cpp, MLX

Point-and-click: search, download and chat in one window.

Open SQLCoder 7B v2 in LM Studio

llama.cpp Usually the first to support new model architectures.
Ollama Runs the Hugging Face GGUF with ollama run hf.co/…

Want an agent? SQLCoder 7B v2 supports tool use, so you can pair a llama.cpp or MLX LM server with one of these. Apps that run on this computer come first.

Coding agents

Personal assistants

How we choose: the files published for this model, your operating system and GPU, whether it fits fully in memory, and published speed tests (MLX vs llama.cpp on Apple silicon, vLLM vs llama.cpp vs Ollama on NVIDIA). Details.

Download SQLCoder 7B v2

Quantized files · GGUF

Works in LM Studio, llama.cpp, Jan and Ollama. No sign-in needed.

huggingface.co/defog/sqlcoder-7b-2 (opens in a new tab)

ollama run hf.co/defog/sqlcoder-7b-2

Original weights · Hugging Face

Full-precision files from Defog, for fine-tuning, vLLM, Transformers.

huggingface.co/defog/sqlcoder-7b-2 (opens in a new tab)

No sign-in needed.

Links checked 1 day ago against Hugging Face, Ollama and GitHub.

How it’s rated

Quality 28Basic quality (D) · 28 of 100: how capable the model is at Q4_K_M, whatever it runs on. Match score 67/100 (quality, fit, speed and memory use) sets the ranking.: How capable the model itself is at Q4_K_M, from its editorial quality tier scaled by the quantization or precision. It’s the same on any hardware that runs this variant. Scale: A+ 85+ · A 70+ · B 55+ · C 40+ · D under 40.
Runs Runs great: How well it runs on the NVIDIA GeForce RTX 4070 SUPER: speed, capped by how well it fits in memory. Runs great: 30+ tokens/s (or near the image, video or decision speed target) · Runs well: 10+ tokens/s · Slow: 3+ tokens/s · Very slow: under 3 · Won’t run: doesn’t fit even with offload. A tight fit or RAM offload caps it at Runs well; heavy offload caps it at Slow.

Match score

To order lists, each result also gets a match score out of 100 from four parts. It favors the most capable model that still runs well.

Model qualityEditorial quality tier of the model, scaled by the quantization or precision used.	12.8 / 45
Memory fitFull marks when everything sits in GPU memory; fewer when part spills to system RAM.	25.0 / 25
SpeedGeneration speed against a 40 tokens/s target for LLMs, or render time against a target for image and video.	15.0 / 15
Memory useRewards using the memory you have, so a bigger, better variant beats a tiny one that leaves most memory idle.	15.0 / 15
Match score	67.8 / 100

The match score orders results; it is not shown as a grade. Quality and Runs are the two ratings in the tables.

Every quantization on the NVIDIA GeForce RTX 4070 SUPER

Quant	Memory needed	Available	Speed	Runs	Quality	Download
`Q2_K`	8.2 GB	12.0 GB	151 tok/s	Runs great	21Basic quality (D) · 21 of 100: how capable the model is at Q2_K, whatever it runs on. Match score 64/100 (quality, fit, speed and memory use) sets the ranking.	GGUF files (opens in a new tab)
`Q3_K_M`	8.8 GB	12.0 GB	119 tok/s	Runs great	25Basic quality (D) · 25 of 100: how capable the model is at Q3_K_M, whatever it runs on. Match score 66/100 (quality, fit, speed and memory use) sets the ranking.	GGUF files (opens in a new tab)
`Q4_K_M`	9.6 GB	12.0 GB	91.8 tok/s	Runs great	28Basic quality (D) · 28 of 100: how capable the model is at Q4_K_M, whatever it runs on. Match score 67/100 (quality, fit, speed and memory use) sets the ranking.	GGUF files (opens in a new tab)
`Q5_K_M`	10.3 GB	12.0 GB	75.8 tok/s	Runs welltight fit	29Basic quality (D) · 29 of 100: how capable the model is at Q5_K_M, whatever it runs on. Match score 67/100 (quality, fit, speed and memory use) sets the ranking.	GGUF (opens in a new tab)
`Q6_K`	11.0 GB	12.0 GB	63.7 tok/s	Runs welltight fit	29Basic quality (D) · 29 of 100: how capable the model is at Q6_K, whatever it runs on. Match score 67/100 (quality, fit, speed and memory use) sets the ranking.	GGUF files (opens in a new tab)
`Q8_0`	12.6 GB	12.0 GB	29.4 tok/s	Runs welloffloads to RAM	30Basic quality (D) · 30 of 100: how capable the model is at Q8_0, whatever it runs on. Match score 51/100 (quality, fit, speed and memory use) sets the ranking.	GGUF files (opens in a new tab)
`F16`	19.0 GB	12.0 GB	4.9 tok/s	Slowheavy RAM offload	30Basic quality (D) · 30 of 100: how capable the model is at F16, whatever it runs on. Match score 37/100 (quality, fit, speed and memory use) sets the ranking.	Original weights (opens in a new tab)

Memory figures assume 8K of context. Longer conversations or documents grow the KV cache.

Other hardware that runs it

30Basic quality (D) · 30 of 100: how capable the model is at Q8_0, whatever it runs on. Match score 68/100 (quality, fit, speed and memory use) sets the ranking. AMD Radeon RX 9070 XT Q8_0 · 51.1 tok/s · Runs great
30Basic quality (D) · 30 of 100: how capable the model is at Q8_0, whatever it runs on. Match score 68/100 (quality, fit, speed and memory use) sets the ranking. NVIDIA GeForce RTX 4070 Ti SUPER Q8_0 · 62.3 tok/s · Runs great
30Basic quality (D) · 30 of 100: how capable the model is at Q8_0, whatever it runs on. Match score 68/100 (quality, fit, speed and memory use) sets the ranking. NVIDIA GeForce RTX 4080 SUPER Q8_0 · 68.2 tok/s · Runs great
30Basic quality (D) · 30 of 100: how capable the model is at F16, whatever it runs on. Match score 68/100 (quality, fit, speed and memory use) sets the ranking. NVIDIA GeForce RTX 4090 F16 · 43.1 tok/s · Runs great
30Basic quality (D) · 30 of 100: how capable the model is at Q8_0, whatever it runs on. Match score 68/100 (quality, fit, speed and memory use) sets the ranking. NVIDIA GeForce RTX 5060 Ti 16GB Q8_0 · 41.5 tok/s · Runs great
30Basic quality (D) · 30 of 100: how capable the model is at Q8_0, whatever it runs on. Match score 68/100 (quality, fit, speed and memory use) sets the ranking. NVIDIA GeForce RTX 5070 Ti Q8_0 · 83.1 tok/s · Runs great

Quick answers

How much memory does SQLCoder 7B v2 need on the RTX 4070 SUPER 12GB?

At Q4_K_M it needs about 9.6 GB. The RTX 4070 SUPER 12GB has 12.0 GB usable.

How fast is SQLCoder 7B v2 on the RTX 4070 SUPER 12GB?

About 91.8 tok/s at Q4_K_M, an estimate from the hardware’s memory bandwidth and the size of the model.

Which quantization of SQLCoder 7B v2 should I use on the RTX 4070 SUPER 12GB?

Q4_K_M. Of the versions that fit, it is the one that runs best; when two run equally well, the check prefers the higher-rated one.

Estimates come from published hardware specs and our open formulas, not from running the model on your machine. Real speed varies with runtime, drivers and settings. Numbers marked “Measured” come from a linked benchmark.