File size: 1,518 Bytes
677a10a f9cf143 677a10a 6f1d297 677a10a f9cf143 677a10a 6f1d297 677a10a 6f1d297 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 | ---
license: apache-2.0
language:
- en
tags:
- zen
- zenlm
- hanzo-ai
- sql
- database
- code-generation
pipeline_tag: text-generation
library_name: transformers
base_model: zenlm/zen4
---
# Zen Sql
> **Parameters**: 7B | **Architecture**: Zen 4 Architecture | **Context**: 32K | **License**: Apache 2.0 | **Released**: 2024-11-15
SQL specialist for complex query generation, schema design, query optimization, and database documentation.
Supports PostgreSQL, MySQL, SQLite, BigQuery, Snowflake, and more.
Base weights: [zenlm/zen4](https://huggingface.co/zenlm/zen4)
```python
from transformers import AutoModelForCausalLM, AutoTokenizer
model = AutoModelForCausalLM.from_pretrained("zenlm/zen4", torch_dtype="auto")
tokenizer = AutoTokenizer.from_pretrained("zenlm/zen4")
messages = [{"role": "user", "content": "Your domain-specific prompt here"}]
text = tokenizer.apply_chat_template(messages, tokenize=False, add_generation_prompt=True)
inputs = tokenizer(text, return_tensors="pt").to(model.device)
output = model.generate(**inputs, max_new_tokens=1024)
print(tokenizer.decode(output[0][inputs.input_ids.shape[-1]:], skip_special_tokens=True))
```
---
## The Zen LM Family
Joint research between **Hanzo AI** (Techstars '17), **Zoo Labs Foundation** (501c3), and **Lux Partners Limited**.
All weights Apache 2.0. Download, run locally, fine-tune, deploy commercially.
[HuggingFace](https://huggingface.co/zenlm) 路 [Chat](https://hanzo.chat) 路 [API](https://api.hanzo.ai) 路 [Docs](https://zenlm.org)
|