NA

natural sql 7b i1

NaturalGGUF by mradermacherUpdated 2024-11-02
Download on Hugging Face
Parameters6.91B
Context4K
Layers30
Architecturellama
Smallest quant1.7 GB
Quick answer

natural sql 7b i1 needs about 8.7 GB of memory at Q4_K_M (a 4.2 GB file) with an 8K context window, so it fits on a 12 GB GPU. This repository has 24 quants, from 1.7 GB (IQ1_S) to 5.7 GB (Q6_K).

Natural-SQL-7B 7B LLaMA model for text‑to‑SQL

Natural-SQL-7B is a 6.91B parameter LLaMA model fine‑tuned for text‑to‑SQL tasks. It supports a 4096 token context window and is released under CC‑BY‑SA‑4.0. The model is available in multiple GGUF quantizations.

Good at

  • Text‑to‑SQL generation
  • Complex SQL query construction
  • Understanding natural language questions

Limits

  • No vision support
  • Requires 8k context for full memory estimates
  • CC‑BY‑SA‑4.0 license requires sharing changes

Best for

  • Generating SQL from natural language
  • Automating database query creation
  • Educational SQL tutoring

Who it’s for. Developers building database interfaces, data analysts needing automated query generation, and educators teaching SQL. The model can be run locally with llama.cpp using the provided GGUF files.

Quants & memory

QuantFileEst. memoryvs VRAMResultDownload
IQ1_S1.7 GB 4.2 GB
Fits Get file →
IQ1_M1.8 GB 4.4 GB
Fits Get file →
IQ2_XXS2.0 GB 4.6 GB
Fits Get file →
IQ2_XS2.2 GB 4.7 GB
Fits Get file →
IQ2_S2.4 GB 4.9 GB
Fits Get file →
IQ2_M2.5 GB 5.1 GB
Fits Get file →
Q2_K2.7 GB 5.2 GB
Fits Get file →
IQ3_XXS2.8 GB 5.3 GB
Fits Get file →
IQ3_XS3.0 GB 5.5 GB
Fits Get file →
IQ3_S3.1 GB 5.7 GB
Fits Get file →
Q3_K_S3.1 GB 5.7 GB
Fits Get file →
IQ3_M3.3 GB 5.8 GB
Fits Get file →
Q3_K_M3.5 GB 6.0 GB
Fits Get file →
Q3_K_L3.7 GB 6.3 GB
Fits Get file →
IQ4_XS3.8 GB 6.3 GB
Fits Get file →
Q4_04.0 GB 6.5 GB
Fits Get file →
Q4_04.0 GB 6.5 GB
Fits Get file →
Q4_04.0 GB 6.5 GB
Fits Get file →
Q4_04.0 GB 6.5 GB
Fits Get file →
Q4_K_S4.0 GB 6.5 GB
Fits Get file →
Q4_K_M4.2 GB 6.7 GB
Fits Get file →
Q5_K_S4.8 GB 7.3 GB
Tight Get file →
Q5_K_M4.9 GB 7.4 GB
Tight Get file →
Q6_K5.7 GB 8.2 GB
Too big Get file →

For 8 GB VRAM, use IQ1_S (1.73 GB file, 6.3 GB memory) or IQ1_M (1.85 GB, 6.4 GB). If 12 GB VRAM is available, Q4_K_M (4.22 GB, 8.7 GB) offers higher quality. For 16 GB VRAM, Q5_K_M (4.93 GB, 9.5 GB) or Q6_K (5.67 GB, 10.2 GB) are suitable. Memory estimates are approximate.

What GPU do you need for natural sql 7b i1?

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_M (3.5 GB file, about 8.0 GB in use).
  • 12 GB VRAM: the best quant that fits is Q6_K (5.7 GB file, about 10.2 GB in use).

Which natural sql 7b i1 quant should you choose?

Q4_K_M is the usual starting point for natural sql 7b i1: it balances file size and quality well. Here it is a 4.2 GB file.

If memory is tight, the smallest file is IQ1_S at 1.7 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.91B
Layers30
Trained context4,096 tokens
KV cache (fp16)480 KB per token

Source

Quantized bymradermacher
FamilyNatural
Downloads (HF)603
Last updated2024-11-02

Frequently asked questions about natural sql 7b i1

How much VRAM does natural sql 7b i1 need?

About 8.7 GB at Q4_K_M with an 8K context window. That is the 4.2 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 natural sql 7b i1 on an 8 GB GPU?

Yes, with Q3_K_M: the 3.5 GB file needs about 8.0 GB at 8K context. Larger quants in this repository do not fit in 8 GB.

What is the file size of natural sql 7b i1 GGUF?

It depends on the quant: IQ1_S is 1.7 GB, IQ1_M is 1.8 GB, IQ2_XXS is 2.0 GB, IQ2_XS is 2.2 GB, IQ2_S is 2.4 GB, IQ2_M is 2.5 GB and 18 more.

What context length does natural sql 7b i1 support?

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

Where can I download natural sql 7b i1 GGUF?

The files are on Hugging Face in the mradermacher/natural-sql-7b-i1-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 natural sql 7b i1 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 Natural‑SQL‑7B on 8 GB VRAM?

Yes, use IQ1_S or IQ1_M quantizations; they require about 6.3–6.4 GB of VRAM at 8k context.

What license does Natural‑SQL‑7B use?

The model is licensed under CC‑BY‑SA‑4.0, allowing commercial use with attribution and share‑alike for modifications.

Does the model support vision tasks?

No, Natural‑SQL‑7B is a text‑only model and does not process images.

Other GGUFs of natural-sql-7b

Similar models

Browse all →

More from mradermacher

All by mradermacher →

More Natural models

All Natural →

Other small models

All small models →