Instructions to use defog/sqlcoder with libraries, inference providers, notebooks, and local apps. Follow these links to get started.
- Libraries
- Transformers
How to use defog/sqlcoder with Transformers:
# Use a pipeline as a high-level helper from transformers import pipeline pipe = pipeline("text-generation", model="defog/sqlcoder")# pip install -U transformers accelerate # Load model directly from transformers import AutoTokenizer, AutoModelForCausalLM tokenizer = AutoTokenizer.from_pretrained("defog/sqlcoder") model = AutoModelForCausalLM.from_pretrained("defog/sqlcoder", device_map="auto") - Notebooks
- Google Colab
- Kaggle
- Local Apps Settings
- vLLM
How to use defog/sqlcoder with vLLM:
Install from pip and serve model
# Install vLLM from pip: pip install vllm # Start the vLLM server: vllm serve "defog/sqlcoder" # 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", "prompt": "Once upon a time,", "max_tokens": 512, "temperature": 0.5 }'Use Docker
docker model run hf.co/defog/sqlcoder
- SGLang
How to use defog/sqlcoder 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" \ --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", "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" \ --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", "prompt": "Once upon a time,", "max_tokens": 512, "temperature": 0.5 }' - Docker Model Runner
How to use defog/sqlcoder with Docker Model Runner:
docker model run hf.co/defog/sqlcoder
Commit History
-
Add more precise license metadata (UI will be cleaner!)
Part of hacktoberfest_challenge -> [Hugging Face hub-docs] (https://github.com/huggingface/hub-docs/blob/main/hacktoberfest_challenges/model_license_other.md)9453517
-
Update README.md
bef4bcd
-
Create inference.py
3741f67
-
Update README.md
ed1b417 -
Create LICENSE
d869c0f -
Update README.md
2032253 -
Update README.md
9a36d6b -
Update README.md
ddff439 -
Update README.md
cce7e2e
-
Update README.md
227a423
-
Update README.md
Wendy7ce698c -
Slight corrections in README
Wendy4cb94f8 -
Update README.md
5482a98 -
Create README.md
# Defog SQLCoder Defog's SQLCoder is a state of the art LLM for converting natural language questions to SQL queries. [🤗 HF Repo](https://huggingface.co/defog/sqlcoder) | [♾️ Colab](https://drive.google.com/file/d/13BIKsqHnPOBcQ-ba2p77L5saiepTIwu0/view?usp=sharing) | [🐦 Twitter](https://twitter.com/defogdata) ## TL;DR SQLCoder is a 15B parameter model that slightly outperforms gpt-3.5-turbo for natural language to SQL generation tasks on our [sql-eval](https://github.com/defog-ai/sql-eval) framework, and significantly outperforms all popular open-source models. It also significantly outperforms `text-davinci-003`, a model that's more than 10 times its size. SQLCoder is fine-tuned on a base StarCoder model. ## Results | model | perc_correct | |-|-| | gpt-4 | 74.3 | | defog-sqlcoder | 64.6 | | gpt-3.5-turbo | 60.6 | | defog-easysql | 57.1 | | text-davinci-003 | 54.3 | | wizardcoder | 52.0 | | starcoder | 45.1 | ## Training Defog was trained on…8e7a9db
-
Upload tokenizer
4298176 -
Upload GPTBigCodeForCausalLM
dc127ec -
initial commit
b7391e2