SQLCoder 7B v2 on Apple M2 Pro (32 GB)
Can the Apple M2 Pro (32 GB) run SQLCoder 7B v2?
Yes, it runs well
Runs well. At Q3_K_M it needs about 9.9 GB of 21.4 GB usable, with an estimated speed of 40.5 tok/s.
- Best quant
Q3_K_M- Generation speed
- 40.5 tok/s
- Prompt processing
- 626 tok/s
- First token (1K prompt)
- 1.6 s
- Largest safe context
- 16K
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-2Original weights · Hugging Face
Full-precision files from Defog, for fine-tuning, vLLM, Transformers.
How the B grade is scored
Every result gets up to 100 points from four parts. The points decide the letter grade.
| Model quality | 11.3 / 45 | |
|---|---|---|
| Memory fit | 25.0 / 25 | |
| Speed | 15.0 / 15 | |
| Memory use | 10.7 / 15 | |
| Total | 62.0 / 100 | 62 ptsGood (B) · 62 of 100 points: Model quality 11.3/45, Memory fit 25.0/25, Speed 15.0/15, Memory use 10.7/15 |
Every quantization on the Apple M2 Pro (32 GB)
| Quant | Memory needed | Available | Speed | Fit | Grade · points | Download |
|---|---|---|---|---|---|---|
Q2_K | 9.3 GB | 21.4 GB | 51.5 tok/s | Runs well | 59 ptsGood (B) · 59 of 100 points: Model quality 9.5/45, Memory fit 25.0/25, Speed 15.0/15, Memory use 10.0/15 | GGUF files (opens in a new tab) |
Q3_K_M | 9.9 GB | 21.4 GB | 40.5 tok/s | Runs well | 62 ptsGood (B) · 62 of 100 points: Model quality 11.3/45, Memory fit 25.0/25, Speed 15.0/15, Memory use 10.7/15 | GGUF files (opens in a new tab) |
Q4_K_M | 10.7 GB | 21.4 GB | 31.4 tok/s | Runs well | 62 ptsGood (B) · 62 of 100 points: Model quality 12.8/45, Memory fit 25.0/25, Speed 13.3/15, Memory use 11.5/15 | GGUF files (opens in a new tab) |
Q5_K_M | 11.4 GB | 21.4 GB | 25.9 tok/s | Runs well | 62 ptsGood (B) · 62 of 100 points: Model quality 13.1/45, Memory fit 25.0/25, Speed 12.1/15, Memory use 12.3/15 | GGUF (opens in a new tab) |
Q6_K | 12.1 GB | 21.4 GB | 21.8 tok/s | Runs well | 62 ptsGood (B) · 62 of 100 points: Model quality 13.4/45, Memory fit 25.0/25, Speed 11.1/15, Memory use 13.1/15 | GGUF files (opens in a new tab) |
Q8_0 | 13.8 GB | 21.4 GB | 16.0 tok/s | Runs well | 62 ptsGood (B) · 62 of 100 points: Model quality 13.5/45, Memory fit 25.0/25, Speed 9.5/15, Memory use 14.8/15 | GGUF files (opens in a new tab) |
F16 | 20.1 GB | 21.4 GB | 7.4 tok/s | Tight fit | 58 ptsGood (B) · 58 of 100 points: Model quality 13.5/45, Memory fit 24.0/25, Speed 6.4/15, Memory use 15.0/15 | 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
- 68 ptsGood (B) · 68 of 100 points: Model quality 13.5/45, Memory fit 25.0/25, Speed 15.0/15, Memory use 15.0/15 AMD Radeon RX 9070 XT
- 68 ptsGood (B) · 68 of 100 points: Model quality 13.5/45, Memory fit 25.0/25, Speed 15.0/15, Memory use 15.0/15 NVIDIA GeForce RTX 4090
- 68 ptsGood (B) · 68 of 100 points: Model quality 13.5/45, Memory fit 25.0/25, Speed 15.0/15, Memory use 15.0/15 NVIDIA GeForce RTX 4070 Ti SUPER
- 68 ptsGood (B) · 68 of 100 points: Model quality 13.5/45, Memory fit 25.0/25, Speed 15.0/15, Memory use 15.0/15 NVIDIA GeForce RTX 4080 SUPER
- 68 ptsGood (B) · 68 of 100 points: Model quality 13.5/45, Memory fit 25.0/25, Speed 15.0/15, Memory use 15.0/15 NVIDIA GeForce RTX 5060 Ti 16GB
- 68 ptsGood (B) · 68 of 100 points: Model quality 13.5/45, Memory fit 25.0/25, Speed 15.0/15, Memory use 15.0/15 NVIDIA GeForce RTX 5070 Ti
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.