Instructions to use defog/sqlcoder-70b-alpha with libraries, inference providers, notebooks, and local apps. Follow these links to get started.
- Libraries
- Transformers
How to use defog/sqlcoder-70b-alpha with Transformers:
# Use a pipeline as a high-level helper from transformers import pipeline pipe = pipeline("text-generation", model="defog/sqlcoder-70b-alpha")# Load model directly from transformers import AutoTokenizer, AutoModelForCausalLM tokenizer = AutoTokenizer.from_pretrained("defog/sqlcoder-70b-alpha") model = AutoModelForCausalLM.from_pretrained("defog/sqlcoder-70b-alpha") - Notebooks
- Google Colab
- Kaggle
- Local Apps Settings
- vLLM
How to use defog/sqlcoder-70b-alpha with vLLM:
Install from pip and serve model
# Install vLLM from pip: pip install vllm # Start the vLLM server: vllm serve "defog/sqlcoder-70b-alpha" # 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-70b-alpha", "prompt": "Once upon a time,", "max_tokens": 512, "temperature": 0.5 }'Use Docker
docker model run hf.co/defog/sqlcoder-70b-alpha
- SGLang
How to use defog/sqlcoder-70b-alpha 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-70b-alpha" \ --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-70b-alpha", "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-70b-alpha" \ --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-70b-alpha", "prompt": "Once upon a time,", "max_tokens": 512, "temperature": 0.5 }' - Docker Model Runner
How to use defog/sqlcoder-70b-alpha with Docker Model Runner:
docker model run hf.co/defog/sqlcoder-70b-alpha
running SQLCoder on M4 Max
Hi,
I am part way through my MSc project where I want to test some different approaches to prompt creation and knowledge retrieval in text-to-SQL systems.
I plan to test a few open source models and potentially have a Agentic setup to build concise prompt, so for running locally i was going to upgrade my m3 pro to an m4 max. I will have a dodgy internet conneciton for some of the time i will be researching so dont realy want to rely on cloud compute.
I know you say that this model does run on apple silicon but how is the performance on token generation?
Apologies if this is a noddy quesiton
Thanks in advance.
Hi @theglover , you can consider starting with the MLX code we have in our evaluation harness: https://github.com/defog-ai/sql-eval/?tab=readme-ov-file#mlx
We haven't used that code in awhile - you might need to update that based on the current state of the various libraries / dependencies.
Thank you - i will take a look