---
tags:
- merge
- mergekit
- mistralai/Mistral-7B-v0.1
- defog/sqlcoder-7b-2
base_model:
- mistralai/Mistral-7B-v0.1
- defog/sqlcoder-7b-2
---

# mistral-sql-coder

mistral-sql-coder is a merge of the following models:
* [mistralai/Mistral-7B-v0.1](https://huggingface.co/mistralai/Mistral-7B-v0.1)
* [defog/sqlcoder-7b-2](https://huggingface.co/defog/sqlcoder-7b-2)

## 🧩 Configuration

```yaml
models:
  - model: mistralai/Mistral-7B-v0.1
    parameters:
      density: 0.5
      weight: 1.0
  - model: defog/sqlcoder-7b-2
    parameters:
      density: 0.33
      weight: 1.0
merge_method: ties
base_model: mistralai/Mistral-7B-v0.1
parameters:
  normalize: true
  int8_mask: true
dtype: float16
```

## 💻 Usage

```python
!pip install -qU transformers accelerate

from transformers import AutoTokenizer
import transformers
import torch

model = "anupkashyap7/mistral-sql-coder"
messages = [{"role": "user", "content": "What is a large language model?"}]

tokenizer = AutoTokenizer.from_pretrained(model)
prompt = tokenizer.apply_chat_template(messages, tokenize=False, add_generation_prompt=True)
pipeline = transformers.pipeline(
    "text-generation",
    model=model,
    torch_dtype=torch.float16,
    device_map="auto",
)

outputs = pipeline(prompt, max_new_tokens=256, do_sample=True, temperature=0.7, top_k=50, top_p=0.95)
print(outputs[0]["generated_text"])
```