Downloads · 30 days
278
2% of all-time downloads
defog_-_llama-3-sqlcoder-8b-gguf
RichardErkhov/defog_-_llama-3-sqlcoder-8b-gguf
defog_-_llama-3-sqlcoder-8b-gguf is a machine learning model from RichardErkhov. Use it for the machine learning task on the model card, and read the license before you ship it in a product.
All-time downloads
12.3K
Public
Repo size
92.9 GB
Likes
0
Public
Repo makeup
Click a slice to open those files.
.gguf108 GB · 100%
At a glance
- Access
- Public
- Created
- Jun 14, 2024
- Updated
- Jun 14, 2024
- SHA
- 6735e418
Model card
From the Hugging Face model README
Quantization made by Richard Erkhov.
llama-3-sqlcoder-8b - GGUF
- Model creator: https://huggingface.co/defog/
- Original model: https://huggingface.co/defog/llama-3-sqlcoder-8b/
| Name | Quant method | Size |
|---|---|---|
| llama-3-sqlcoder-8b.Q2_K.gguf | Q2_K | 2.96GB |
| llama-3-sqlcoder-8b.IQ3_XS.gguf | IQ3_XS | 3.28GB |
| llama-3-sqlcoder-8b.IQ3_S.gguf | IQ3_S | 3.43GB |
| llama-3-sqlcoder-8b.Q3_K_S.gguf | Q3_K_S | 3.41GB |
| llama-3-sqlcoder-8b.IQ3_M.gguf | IQ3_M | 3.52GB |
| llama-3-sqlcoder-8b.Q3_K.gguf | Q3_K | 3.74GB |
| llama-3-sqlcoder-8b.Q3_K_M.gguf | Q3_K_M | 3.74GB |
| llama-3-sqlcoder-8b.Q3_K_L.gguf | Q3_K_L | 4.03GB |
| llama-3-sqlcoder-8b.IQ4_XS.gguf | IQ4_XS | 4.18GB |
| llama-3-sqlcoder-8b.Q4_0.gguf | Q4_0 | 4.34GB |
| llama-3-sqlcoder-8b.IQ4_NL.gguf | IQ4_NL | 4.38GB |
| llama-3-sqlcoder-8b.Q4_K_S.gguf | Q4_K_S | 4.37GB |
| llama-3-sqlcoder-8b.Q4_K.gguf | Q4_K | 4.58GB |
| llama-3-sqlcoder-8b.Q4_K_M.gguf | Q4_K_M | 4.58GB |
| llama-3-sqlcoder-8b.Q4_1.gguf | Q4_1 | 4.78GB |
| llama-3-sqlcoder-8b.Q5_0.gguf | Q5_0 | 5.21GB |
| llama-3-sqlcoder-8b.Q5_K_S.gguf | Q5_K_S | 5.21GB |
| llama-3-sqlcoder-8b.Q5_K.gguf | Q5_K | 5.34GB |
| llama-3-sqlcoder-8b.Q5_K_M.gguf | Q5_K_M | 5.34GB |
| llama-3-sqlcoder-8b.Q5_1.gguf | Q5_1 | 5.65GB |
| llama-3-sqlcoder-8b.Q6_K.gguf | Q6_K | 6.14GB |
| llama-3-sqlcoder-8b.Q8_0.gguf | Q8_0 | 7.95GB |
Original model description:
license: cc-by-sa-4.0 metrics:
- accuracy pipeline_tag: text-generation tags:
- code
A capable language model for text to SQL generation for Postgres, Redshift and Snowflake that is on-par with the most capable generalist frontier models.
Model Description
Developed by: Defog, Inc Model type: [Text to SQL] License: [CC-by-SA-4.0] Finetuned from model: [Meta-Llama-3-8B-Instruct]
Demo Page
https://defog.ai/sqlcoder-demo/
Ideal prompt and inference parameters
Set temperature to 0, and do not do sampling.
Prompt
<|begin_of_text|><|start_header_id|>user<|end_header_id|>
Generate a SQL query to answer this question: `{user_question}`
{instructions}
DDL statements:
{create_table_statements}<|eot_id|><|start_header_id|>assistant<|end_header_id|>
The following SQL query best answers the question `{user_question}`:
```sql
Evaluation
This model was evaluated on SQL-Eval, a PostgreSQL based evaluation framework developed by Defog for testing and alignment of model capabilities.
You can read more about the methodology behind SQLEval here.
Contact
Contact us on X at @defogdata, or on email at [email protected]
- Created
- Jun 14, 2024
- Updated
- Jun 14, 2024