Instructions to use juierror/flan-t5-text2sql-with-schema-v2 with libraries, inference providers, notebooks, and local apps. Follow these links to get started.

Libraries

How to use juierror/flan-t5-text2sql-with-schema-v2 with Transformers:

# Use a pipeline as a high-level helper
from transformers import pipeline

pipe = pipeline("text-generation", model="juierror/flan-t5-text2sql-with-schema-v2")

# Load model directly
from transformers import AutoTokenizer, AutoModelForSeq2SeqLM

tokenizer = AutoTokenizer.from_pretrained("juierror/flan-t5-text2sql-with-schema-v2")
model = AutoModelForSeq2SeqLM.from_pretrained("juierror/flan-t5-text2sql-with-schema-v2")

Notebooks
Google Colab
Kaggle
Local Apps

vLLM

How to use juierror/flan-t5-text2sql-with-schema-v2 with vLLM:

Install from pip and serve model

# Install vLLM from pip:
pip install vllm
# Start the vLLM server:
vllm serve "juierror/flan-t5-text2sql-with-schema-v2"
# Call the server using curl (OpenAI-compatible API):
curl -X POST "http://localhost:8000/v1/completions" \
	-H "Content-Type: application/json" \
	--data '{
		"model": "juierror/flan-t5-text2sql-with-schema-v2",
		"prompt": "Once upon a time,",
		"max_tokens": 512,
		"temperature": 0.5
	}'

Use Docker

docker model run hf.co/juierror/flan-t5-text2sql-with-schema-v2

SGLang

How to use juierror/flan-t5-text2sql-with-schema-v2 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 "juierror/flan-t5-text2sql-with-schema-v2" \
    --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": "juierror/flan-t5-text2sql-with-schema-v2",
		"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 "juierror/flan-t5-text2sql-with-schema-v2" \
        --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": "juierror/flan-t5-text2sql-with-schema-v2",
		"prompt": "Once upon a time,",
		"max_tokens": 512,
		"temperature": 0.5
	}'

Docker Model Runner
How to use juierror/flan-t5-text2sql-with-schema-v2 with Docker Model Runner:
```
docker model run hf.co/juierror/flan-t5-text2sql-with-schema-v2
```

How do I specify foreign key relationships?

by tirtohadi - opened May 27, 2024

Discussion

tirtohadi

May 27, 2024

Hi there, thank you for the work. How do we specify FK relationship? Or it is not possible?

juierror

Owner May 28, 2024

@tirtohadi Hi, If I still remember correctly, the dataset that I used to train the model don't have FK relationship, so the model is not support that.

If we want to support it, you need to train the model with the dataset that have FK relationship example.

FYI. this project purpose is for learning, so the result might not good.

Upload images, audio, and videos by dragging in the text input, pasting, or clicking here.

Tap or paste here to upload images

· Sign up or log in to comment