← Back to all models

sqlcoder 7b 2

Coding model by defog · 6.74B parameters

Runs Excellently

sqlcoder 7b 2 fits comfortably in your 24 GB Mac using Q8_0 quantization, using 33% of your RAM.

~21 tok/s

Q8_0 · 8.0 GB

Quantization Options

QuantizationMemorySpeedFits?
Q8_0 Recommended 8.0 GB~21 tok/s
Q6_K 6.3 GB~28 tok/s
Q5_K_M 5.5 GB~33 tok/s
Q4_K_M 4.9 GB~38 tok/s
Q3_K_M 4.2 GB~46 tok/s
Q2_K 3.4 GB~60 tok/s

Specifications

Parameters6.7B
Architecturellama
Context Length16K
CategoryCoding
Formatgguf
Minimum RAM3.8 GB
HuggingFace Downloads79,453

GGUF Sources

Which Mac Can Run sqlcoder 7b 2?

Minimum Mac

MacBook Air — M1 8GB

Q6_K · ~7 tok/s · 79% RAM

MacQuanttok/sRAM %
MacBook Air · M1 8GB Q6_K ~7 79%
MacBook Air · M2 8GB Q6_K ~10 79%
MacBook Air · M3 8GB Q6_K ~10 79%
Mac Mini · M1 8GB Q6_K ~7 79%
Mac Mini · M2 8GB Q6_K ~10 79%
iMac · M1 8GB Q6_K ~7 79%
iMac · M3 8GB Q6_K ~10 79%
MacBook Air · M1 16GB Q8_0 ~5 50%
MacBook Air · M2 16GB Q8_0 ~8 50%
MacBook Air · M3 16GB Q8_0 ~8 50%
MacBook Air · M4 16GB Q8_0 ~9 50%
MacBook Air · M5 16GB Q8_0 ~12 50%
MacBook Air · M6 16GB Q8_0 ~16 50%
MacBook Pro 14" · M1 Pro 16GB Q8_0 ~16 50%
MacBook Pro 14" · M2 Pro 16GB Q8_0 ~16 50%
MacBook Pro 14" · M5 16GB Q8_0 ~12 50%
MacBook Pro 14" · M6 16GB Q8_0 ~16 50%
MacBook Pro 16" · M1 Pro 16GB Q8_0 ~16 50%
MacBook Pro 16" · M2 Pro 16GB Q8_0 ~16 50%
Mac Mini · M1 16GB Q8_0 ~5 50%
Mac Mini · M2 16GB Q8_0 ~8 50%
Mac Mini · M2 Pro 16GB Q8_0 ~16 50%
Mac Mini · M4 16GB Q8_0 ~9 50%
Mac Mini · M6 16GB Q8_0 ~16 50%
iMac · M1 16GB Q8_0 ~5 50%
iMac · M3 16GB Q8_0 ~8 50%
iMac · M4 16GB Q8_0 ~9 50%
iMac · M6 16GB Q8_0 ~16 50%
MacBook Pro 14" · M3 Pro 18GB Q8_0 ~12 45%
MacBook Pro 16" · M3 Pro 18GB Q8_0 ~12 45%
MacBook Air · M2 24GB Q8_0 ~8 33%
MacBook Air · M3 24GB Q8_0 ~8 33%
MacBook Air · M4 24GB Q8_0 ~9 33%
MacBook Air · M5 24GB Q8_0 ~12 33%
MacBook Air · M6 24GB Q8_0 ~16 33%
MacBook Pro 14" · M4 Pro 24GB Q8_0 ~21 33%
MacBook Pro 14" · M5 24GB Q8_0 ~12 33%
MacBook Pro 14" · M5 Pro 24GB Q8_0 ~24 33%
MacBook Pro 14" · M6 24GB Q8_0 ~16 33%
MacBook Pro 14" · M6 Pro 24GB Q8_0 ~32 33%
MacBook Pro 16" · M4 Pro 24GB Q8_0 ~21 33%
MacBook Pro 16" · M5 Pro 24GB Q8_0 ~24 33%
MacBook Pro 16" · M6 Pro 24GB Q8_0 ~32 33%
Mac Mini · M2 24GB Q8_0 ~8 33%
Mac Mini · M4 24GB Q8_0 ~9 33%
Mac Mini · M4 Pro 24GB Q8_0 ~21 33%
Mac Mini · M6 24GB Q8_0 ~16 33%
Mac Mini · M6 Pro 24GB Q8_0 ~32 33%
iMac · M3 24GB Q8_0 ~8 33%
iMac · M4 24GB Q8_0 ~9 33%
iMac · M6 24GB Q8_0 ~16 33%
MacBook Air · M4 32GB Q8_0 ~9 25%
MacBook Air · M5 32GB Q8_0 ~12 25%
MacBook Air · M6 32GB Q8_0 ~16 25%
MacBook Pro 14" · M1 Pro 32GB Q8_0 ~16 25%
MacBook Pro 14" · M2 Pro 32GB Q8_0 ~16 25%
MacBook Pro 14" · M5 32GB Q8_0 ~12 25%
MacBook Pro 14" · M6 32GB Q8_0 ~16 25%
MacBook Pro 16" · M1 Pro 32GB Q8_0 ~16 25%
MacBook Pro 16" · M1 Max 32GB Q8_0 ~31 25%
MacBook Pro 16" · M2 Pro 32GB Q8_0 ~16 25%
MacBook Pro 16" · M2 Max 32GB Q8_0 ~31 25%
Mac Mini · M2 Pro 32GB Q8_0 ~16 25%
Mac Mini · M4 32GB Q8_0 ~9 25%
Mac Mini · M6 32GB Q8_0 ~16 25%
Mac Studio · M1 Max 32GB Q8_0 ~31 25%
Mac Studio · M2 Max 32GB Q8_0 ~31 25%
iMac · M4 32GB Q8_0 ~9 25%
iMac · M6 32GB Q8_0 ~16 25%
MacBook Pro 14" · M3 Pro 36GB Q8_0 ~12 22%
MacBook Pro 14" · M5 Max 36GB Q8_0 ~48 22%
MacBook Pro 16" · M3 Pro 36GB Q8_0 ~12 22%
MacBook Pro 16" · M3 Max 36GB Q8_0 ~31 22%
MacBook Pro 16" · M4 Max 36GB Q8_0 ~42 22%
MacBook Pro 16" · M5 Max 36GB Q8_0 ~48 22%
Mac Studio · M4 Max 36GB Q8_0 ~42 22%
MacBook Pro 14" · M4 Pro 48GB Q8_0 ~21 17%
MacBook Pro 14" · M5 Pro 48GB Q8_0 ~24 17%
MacBook Pro 14" · M5 Max 48GB Q8_0 ~48 17%
MacBook Pro 14" · M6 Pro 48GB Q8_0 ~32 17%
MacBook Pro 14" · M6 Max 48GB Q8_0 ~72 17%
MacBook Pro 16" · M3 Max 48GB Q8_0 ~31 17%
MacBook Pro 16" · M4 Pro 48GB Q8_0 ~21 17%
MacBook Pro 16" · M4 Max 48GB Q8_0 ~42 17%
MacBook Pro 16" · M5 Pro 48GB Q8_0 ~24 17%
MacBook Pro 16" · M5 Max 48GB Q8_0 ~48 17%
MacBook Pro 16" · M6 Pro 48GB Q8_0 ~32 17%
MacBook Pro 16" · M6 Max 48GB Q8_0 ~72 17%
Mac Mini · M4 Pro 48GB Q8_0 ~21 17%
Mac Mini · M6 Pro 48GB Q8_0 ~32 17%
Mac Studio · M6 Max 48GB Q8_0 ~72 17%
MacBook Pro 14" · M5 Pro 64GB Q8_0 ~24 13%
MacBook Pro 14" · M5 Max 64GB Q8_0 ~48 13%
MacBook Pro 14" · M6 Pro 64GB Q8_0 ~32 13%
MacBook Pro 14" · M6 Max 64GB Q8_0 ~72 13%
MacBook Pro 16" · M1 Max 64GB Q8_0 ~31 13%
MacBook Pro 16" · M2 Max 64GB Q8_0 ~31 13%
MacBook Pro 16" · M3 Max 64GB Q8_0 ~31 13%
MacBook Pro 16" · M4 Max 64GB Q8_0 ~42 13%
MacBook Pro 16" · M5 Max 64GB Q8_0 ~48 13%
MacBook Pro 16" · M6 Pro 64GB Q8_0 ~32 13%
MacBook Pro 16" · M6 Max 64GB Q8_0 ~72 13%
Mac Mini · M6 Pro 64GB Q8_0 ~32 13%
Mac Studio · M1 Max 64GB Q8_0 ~31 13%
Mac Studio · M1 Ultra 64GB Q8_0 ~62 13%
Mac Studio · M2 Max 64GB Q8_0 ~31 13%
Mac Studio · M2 Ultra 64GB Q8_0 ~62 13%
Mac Studio · M4 Max 64GB Q8_0 ~42 13%
Mac Studio · M6 Max 64GB Q8_0 ~72 13%
MacBook Pro 16" · M2 Max 96GB Q8_0 ~31 8%
MacBook Pro 16" · M3 Max 96GB Q8_0 ~31 8%
Mac Studio · M2 Max 96GB Q8_0 ~31 8%
Mac Studio · M2 Ultra 96GB Q8_0 ~62 8%
Mac Pro · M2 Ultra 96GB Q8_0 ~62 8%
MacBook Pro 14" · M5 Max 128GB Q8_0 ~48 6%
MacBook Pro 14" · M6 Max 128GB Q8_0 ~72 6%
MacBook Pro 16" · M3 Max 128GB Q8_0 ~31 6%
MacBook Pro 16" · M4 Max 128GB Q8_0 ~42 6%
MacBook Pro 16" · M5 Max 128GB Q8_0 ~48 6%
MacBook Pro 16" · M6 Max 128GB Q8_0 ~72 6%
Mac Studio · M1 Ultra 128GB Q8_0 ~62 6%
Mac Studio · M2 Ultra 128GB Q8_0 ~62 6%
Mac Studio · M4 Max 128GB Q8_0 ~42 6%
Mac Studio · M4 Ultra 128GB Q8_0 ~64 6%
Mac Studio · M6 Max 128GB Q8_0 ~72 6%
Mac Pro · M2 Ultra 128GB Q8_0 ~62 6%
Mac Pro · M4 Ultra 128GB Q8_0 ~64 6%
MacBook Pro 14" · M6 Max 192GB Q8_0 ~72 4%
MacBook Pro 16" · M6 Max 192GB Q8_0 ~72 4%
MacBook Pro 16" · M6 Ultra 192GB Q8_0 ~143 4%
Mac Studio · M2 Ultra 192GB Q8_0 ~62 4%
Mac Studio · M4 Ultra 192GB Q8_0 ~64 4%
Mac Studio · M6 Max 192GB Q8_0 ~72 4%
Mac Studio · M6 Ultra 192GB Q8_0 ~143 4%
Mac Pro · M2 Ultra 192GB Q8_0 ~62 4%
Mac Pro · M4 Ultra 192GB Q8_0 ~64 4%
Mac Pro · M6 Ultra 192GB Q8_0 ~143 4%
MacBook Pro 16" · M6 Ultra 256GB Q8_0 ~143 3%
Mac Studio · M4 Ultra 256GB Q8_0 ~64 3%
Mac Studio · M6 Ultra 256GB Q8_0 ~143 3%
Mac Pro · M4 Ultra 256GB Q8_0 ~64 3%
Mac Pro · M6 Ultra 256GB Q8_0 ~143 3%
MacBook Pro 16" · M6 Ultra 384GB Q8_0 ~143 2%
Mac Studio · M6 Ultra 384GB Q8_0 ~143 2%
Mac Pro · M6 Ultra 384GB Q8_0 ~143 2%

Run sqlcoder 7b 2 locally on your Mac

ToolPiper downloads, manages, and runs models with one click. Apple Silicon optimized.

Get ToolPiper — Free