Instructions to use defog/sqlcoder-7b-2 with libraries, inference providers, notebooks, and local apps. Follow these links to get started.
- Libraries
- Transformers
How to use defog/sqlcoder-7b-2 with Transformers:
# Use a pipeline as a high-level helper from transformers import pipeline pipe = pipeline("text-generation", model="defog/sqlcoder-7b-2")# pip install -U transformers accelerate # Load model directly from transformers import AutoTokenizer, AutoModelForCausalLM tokenizer = AutoTokenizer.from_pretrained("defog/sqlcoder-7b-2") model = AutoModelForCausalLM.from_pretrained("defog/sqlcoder-7b-2", device_map="auto") - Inference
- Notebooks
- Google Colab
- Kaggle
- Local Apps Settings
- llama.cpp
How to use defog/sqlcoder-7b-2 with llama.cpp:
Install (macOS, Linux)
curl -LsSf https://llama.app/install.sh | sh # Start a local OpenAI-compatible server with a web UI: llama serve -hf defog/sqlcoder-7b-2:Q5_K_M # Run inference directly in the terminal: llama cli -hf defog/sqlcoder-7b-2:Q5_K_M
Install from WinGet (Windows)
winget install llama.cpp # Start a local OpenAI-compatible server with a web UI: llama serve -hf defog/sqlcoder-7b-2:Q5_K_M # Run inference directly in the terminal: llama cli -hf defog/sqlcoder-7b-2:Q5_K_M
Build from source code
git clone https://github.com/ggml-org/llama.cpp.git cd llama.cpp cmake -B build cmake --build build -j --target llama-app # Start a local OpenAI-compatible server with a web UI: ./build/bin/llama serve -hf defog/sqlcoder-7b-2:Q5_K_M # Run inference directly in the terminal: ./build/bin/llama cli -hf defog/sqlcoder-7b-2:Q5_K_M
Use Docker
docker model run hf.co/defog/sqlcoder-7b-2:Q5_K_M
- Llama new
- LM Studio
- Jan
- vLLM
How to use defog/sqlcoder-7b-2 with vLLM:
Install from pip and serve model
# Install vLLM from pip: pip install vllm # Start the vLLM server: vllm serve "defog/sqlcoder-7b-2" # Call the server using curl (OpenAI-compatible API): curl -X POST "http://localhost:8000/v1/completions" \ -H "Content-Type: application/json" \ --data '{ "model": "defog/sqlcoder-7b-2", "prompt": "Once upon a time,", "max_tokens": 512, "temperature": 0.5 }'Use Docker
docker model run hf.co/defog/sqlcoder-7b-2:Q5_K_M
- SGLang
How to use defog/sqlcoder-7b-2 with SGLang:
Install from pip and serve model
# Install SGLang from pip: pip install sglang # Start the SGLang server: python3 -m sglang.launch_server \ --model-path "defog/sqlcoder-7b-2" \ --host 0.0.0.0 \ --port 30000 # Call the server using curl (OpenAI-compatible API): curl -X POST "http://localhost:30000/v1/completions" \ -H "Content-Type: application/json" \ --data '{ "model": "defog/sqlcoder-7b-2", "prompt": "Once upon a time,", "max_tokens": 512, "temperature": 0.5 }'Use Docker images
docker run --gpus all \ --shm-size 32g \ -p 30000:30000 \ -v ~/.cache/huggingface:/root/.cache/huggingface \ --env "HF_TOKEN=<secret>" \ --ipc=host \ lmsysorg/sglang:latest \ python3 -m sglang.launch_server \ --model-path "defog/sqlcoder-7b-2" \ --host 0.0.0.0 \ --port 30000 # Call the server using curl (OpenAI-compatible API): curl -X POST "http://localhost:30000/v1/completions" \ -H "Content-Type: application/json" \ --data '{ "model": "defog/sqlcoder-7b-2", "prompt": "Once upon a time,", "max_tokens": 512, "temperature": 0.5 }' - Ollama
How to use defog/sqlcoder-7b-2 with Ollama:
ollama run hf.co/defog/sqlcoder-7b-2:Q5_K_M
- Unsloth Desktop
- Docker Model Runner
How to use defog/sqlcoder-7b-2 with Docker Model Runner:
docker model run hf.co/defog/sqlcoder-7b-2:Q5_K_M
- Lemonade
How to use defog/sqlcoder-7b-2 with Lemonade:
Pull the model
# Download Lemonade from https://lemonade-server.ai/ lemonade pull defog/sqlcoder-7b-2:Q5_K_M
Run and chat with the model
lemonade run user.sqlcoder-7b-2-Q5_K_M
List all available models
lemonade list
- Atomic Chat
model creating own column name
I used the following prompt:
prompt=f"""
Task
Generate a MSSQL query to answer the following question: What is the age of Smith?
Database Schema
This query will run on a database whose schema is represented in this string:
Table 'students' ##\n\nSchema:\n('StudentID', 'AutoField')\n('FirstName', 'TextField')\n('LastName', 'TextField')\n('Age', 'IntegerField')
SQL
Given the database schema, here is the SQL query that answers What is the age of Smith?:
"""
I am getting the following sql
SELECT s.age FROM students AS s WHERE s.last_name = 'Smith'
LastName ------------->> changed to ------------------->>last_name
Temp solution, Lower all the characters
LastName------->>lastname
@abeotttyy two things in the prompt are likely causing the invented columns.
First, the schema is passed as Django field tuples. sqlcoder expects CREATE TABLE statements, so give it DDL instead, for example: CREATE TABLE students (StudentID INT PRIMARY KEY, FirstName VARCHAR(100), LastName VARCHAR(100), Age INT);
Second, Smith is ambiguous between FirstName and LastName. Add a short hint such as "Smith is a last name" or a one-line comment on the column.
Also, sqlcoder-7b-2 was tuned mainly on PostgreSQL. For SQL Server, check the output for LIMIT versus TOP, or generate PostgreSQL and convert it with sqlglot.