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

Sqlcoder 34B Alpha by defog

 »  All LLMs  »  defog  »  Sqlcoder 34B Alpha   URL Share it on

  1804   
  Autotrain compatible   En   Endpoints compatible   Llama   Pytorch   Region:us   Sharded
Model Card on HF 🤗: https://huggingface.co/defog/sqlcoder-34b-alpha 

Sqlcoder 34B Alpha Benchmarks

ARC: 54.18 vs 96.7 (so35)-44%
HellaSwag: 75.93 vs 95.3 (gpt4)-20.3%
MMLU: 54.42 vs 88.3 (so35)-38.4%
TruthfulQA: 40.63 vs 59 (gpt4)-31.1%
WinoGrande: 73.48 vs 87.5 (gpt4)-16%
GSM8K: 34.87 vs 96.4 (so35)-63.8%
LLME Score: 0.17372
nn.n% — How the model compares to the reference models: Anthropic Sonnet 3.5 ("so35"), GPT-4o ("gpt4o") or GPT-4 ("gpt4").
Sqlcoder 34B Alpha (defog/sqlcoder-34b-alpha)
🌟 Advertise your project 🚀

Sqlcoder 34B Alpha Parameters and Internals

Model Type 
text generation
Use Cases 
Areas:
Commercial applications
Applications:
Natural language to SQL conversion
Primary Use Cases:
Converting natural language questions to SQL queries
Supported Languages 
en (Fluent)
Training Details 
Data Sources:
More than 20,000 human-curated questions
Methodology:
Fine-tuning
Input Output 
Accepted Modalities:
text
Output Format:
SQL queries
Release Notes 
Version:
v1
Date:
2023-11-14
Notes:
Updated to reflect benchmarks for SQLCoder-34B
LLM NameSqlcoder 34B Alpha
Repository 🤗https://huggingface.co/defog/sqlcoder-34b-alpha 
Model Size34b
Required VRAM67.5 GB
Updated2025-09-15
Maintainerdefog
Model Typellama
Model Files  9.8 GB: 1-of-7   9.7 GB: 2-of-7   9.7 GB: 3-of-7   9.7 GB: 4-of-7   9.7 GB: 5-of-7   9.7 GB: 6-of-7   9.2 GB: 7-of-7
Supported Languagesen
Model ArchitectureLlamaForCausalLM
Licensecc-by-4.0
Context Length16384
Model Max Length16384
Transformers Version4.34.1
Tokenizer ClassCodeLlamaTokenizer
Vocabulary Size32000
Torch Data Typefloat16

Quantized Models of the Sqlcoder 34B Alpha

Model
Likes
Downloads
VRAM
Sqlcoder 34B Alpha GGUF1249714 GB
Sqlcoder 34B Alpha GPTQ101417 GB
Sqlcoder 34B Alpha AWQ52818 GB

Best Alternatives to Sqlcoder 34B Alpha

Best Alternatives
Context / RAM
Downloads
Likes
34B Beta195K / 69.2 GB967863
Bagel Hermes 34B Slerp195K / 68.9 GB96901
Yi 34B 200K195K / 68.9 GB13047321
Smaug 34B V0.1195K / 69.2 GB969962
Casual Magnum 34B195K / 68.8 GB71
Bagel 34B V0.2195K / 68.7 GB399841
Yi 34B 200K AEZAKMI V2195K / 69.2 GB179912
Smaug 34B V0.1 ExPO195K / 69.2 GB91160
Faro Yi 34B195K / 69.2 GB96976
Bagel DPO 34B V0.5195K / 68.7 GB911717
Note: green Score (e.g. "73.2") means that the model is better than defog/sqlcoder-34b-alpha.

Rank the Sqlcoder 34B Alpha 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? 51387 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 v20241124
  Support LLM Explorer