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 by defog

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

  8491   
  Autotrain compatible   Code   Conversational   Endpoints compatible   Instruct   Llama   Region:us   Safetensors   Sharded   Tensorflow
Model Card on HF 🤗: https://huggingface.co/defog/llama-3-sqlcoder-8b 

Llama 3 Sqlcoder 8B Benchmarks

LLME Score: 0.28855
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 (defog/llama-3-sqlcoder-8b)

Llama 3 Sqlcoder 8B Parameters and Internals

Model Type 
Text to SQL
Additional Notes 
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.
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|>
Output Format:
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
Repository 🤗https://huggingface.co/defog/llama-3-sqlcoder-8b 
Model Size8b
Required VRAM16.1 GB
Updated2024-12-22
Maintainerdefog
Model Typellama
Instruction-BasedYes
Model Files  5.0 GB: 1-of-4   5.0 GB: 2-of-4   4.9 GB: 3-of-4   1.2 GB: 4-of-4   0.0 GB
Model ArchitectureLlamaForCausalLM
Licensecc-by-sa-4.0
Context Length8192
Model Max Length8192
Transformers Version4.40.0
Tokenizer ClassPreTrainedTokenizerFast
Vocabulary Size128256
Torch Data Typebfloat16

Best Alternatives to Llama 3 Sqlcoder 8B

Best Alternatives
Context / RAM
Downloads
Likes
...a 3 8B Instruct Gradient 1048K1024K / 16.1 GB4850678
MrRoboto ProLong 8B V4b1024K / 16.1 GB940
...o ProLongBASE Pt6 Unaligned 8B1024K / 16.1 GB600
MrRoboto ProLong 8B V4c1024K / 16.1 GB790
MrRoboto ProLong 8B V1a1024K / 16.1 GB1070
MrRoboto ProLong 8B V2a1024K / 16.1 GB1010
...o ProLongBASE Pt2 Unaligned 8B1024K / 16.1 GB450
MrRoboto ProLong 8B V2f1024K / 16.1 GB740
MrRoboto ProLong 8B V4f1024K / 16.1 GB450
MrRoboto ProLong 8B V1l1024K / 16.1 GB670
Note: green Score (e.g. "73.2") means that the model is better than defog/llama-3-sqlcoder-8b.

Rank the Llama 3 Sqlcoder 8B 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? 40123 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 v20241217
  Support LLM Explorer