Overview

Ollama version of https://huggingface.co/defog/llama-3-sqlcoder-8b with full template and example system prompt usage as DDL Statements.

Forked from https://ollama.com/mannix/defog-llama3-sqlcoder-8b:latest

Usage

ollama run pacozaa/defog-llama3-sqlcoder-8b
>>> /set system "[Your DDL Statements here]"

Template

Note that Output valid PostgreSQL SQL is there as an {instructions} in original template

TEMPLATE """
<|begin_of_text|><|start_header_id|>user<|end_header_id|>

Generate a SQL query to answer this question: `{{ .Prompt }}`
Output valid PostgreSQL SQL

DDL statements:
{{ .System }}<|eot_id|><|start_header_id|>assistant<|end_header_id|>

The following SQL query best answers the question `{{ .Prompt }}`:
```sql
"""

Model Info

• System Prompt

ollama show defog-llama3-sqlcoder-8b --system

• Template

 ollama show defog-llama3-sqlcoder-8b --template