LLM EXPLORER
 LLM Explorer: A Curated Large Language Model Directory and Analytics
Dark Theme
  LLM  List    LLM Hosting    LLM Leaderboards    Blog    Newsfeed    Advertise

Llama 3 Sqlcoder 8B AWQ by aspenita

 »  All LLMs  »  aspenita  »  Llama 3 Sqlcoder 8B AWQ   URL Share it on

  143   
  4-bit   Autoquant   Autotrain compatible   Awq   Code   Conversational   Endpoints compatible   Llama   Quantized   Region:us   Safetensors   Sharded   Tensorflow
Model Card on HF 🤗: https://huggingface.co/aspenita/llama-3-sqlcoder-8b-AWQ 

Llama 3 Sqlcoder 8B AWQ Benchmarks

LLME Score: 0.19514
nn.n% — How the model compares to the reference models: Anthropic Sonnet 3.5 ("so35"), GPT-4o ("gpt4o") or GPT-4 ("gpt4").
Llama 3 Sqlcoder 8B AWQ (aspenita/llama-3-sqlcoder-8b-AWQ)

Llama 3 Sqlcoder 8B AWQ Parameters and Internals

Model Type 
Text to SQL
Additional Notes 
This model is capable of generating SQL queries for Postgres, Redshift, and Snowflake and is on-par with generalist frontier models.
Input Output 
Input Format:
<|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 ```
Performance Tips:
Set temperature to 0, and do not do sampling.
LLM NameLlama 3 Sqlcoder 8B AWQ
Repository 🤗https://huggingface.co/aspenita/llama-3-sqlcoder-8b-AWQ 
Base Model(s)  Llama 3 Sqlcoder 8B MLX   ucalyptus/llama-3-sqlcoder-8b-MLX
Model Size8b
Required VRAM5.8 GB
Updated2025-02-22
Maintaineraspenita
Model Typellama
Model Files  4.7 GB: 1-of-2   1.1 GB: 2-of-2
AWQ QuantizationYes
Quantization Typeawq
Model ArchitectureLlamaForCausalLM
Licensecc-by-sa-4.0
Context Length8192
Model Max Length8192
Transformers Version4.38.2
Tokenizer ClassPreTrainedTokenizerFast
Vocabulary Size128256
Torch Data Typefloat16

Best Alternatives to Llama 3 Sqlcoder 8B AWQ

Best Alternatives
Context / RAM
Downloads
Likes
...8B Instruct Gradient 1048K AWQ1024K / 5.8 GB810
...radient 1048K AWQ 4bit Smashed1024K / 5.8 GB861
...Instruct 262K AWQ 4bit Smashed256K / 5.8 GB224
...ta Llama 3 8B Instruct 64K AWQ64K / 5.8 GB790
... Instruct 8B 32K V0.1 4bit AWQ64K / 5.8 GB840
Llama 3 8B Instruct AWQ8K / 5.8 GB1044722
Llama 3 ELYZA JP 8B AWQ8K / 5.8 GB18683
Meta Llama 3 8B Instruct AWQ8K / 5.8 GB7525
Meta Llama 3 8B Instruct AWQ8K / 5.8 GB790
Meta Llama 3 8B Instruct AWQ8K / 5.8 GB800
Note: green Score (e.g. "73.2") means that the model is better than aspenita/llama-3-sqlcoder-8b-AWQ.

Rank the Llama 3 Sqlcoder 8B AWQ Capabilities

🆘 Have you tried this model? Rate its performance. This feedback would greatly assist ML community in identifying the most suitable model for their needs. Your contribution really does make a difference! 🌟

Instruction Following and Task Automation  
Factuality and Completeness of Knowledge  
Censorship and Alignment  
Data Analysis and Insight Generation  
Text Generation  
Text Summarization and Feature Extraction  
Code Generation  
Multi-Language Support and Translation  

What open-source LLMs or SLMs are you in search of? 43470 in total.

Email us: info@extractum.io. Our Privacy Policy  | Terms and Conditions  | Suggest an improvement.
Our Social Media →  
Original data from HuggingFace, OpenCompass and various public git repos.
Release v20241227
  Support LLM Explorer