Llama 3 Sqlcoder 8b

🚀 SQLCoder: A Powerful Text-to-SQL Language Model

SQLCoder is a highly capable language model designed for text-to-SQL generation for Postgres, Redshift, and Snowflake. It performs on par with the most advanced generalist frontier models, offering accurate and efficient SQL query generation.

🚀 Quick Start

SQLCoder is a powerful language model that can generate SQL queries from text for Postgres, Redshift, and Snowflake. It is comparable to the most capable generalist frontier models.

✨ Features

• Text-to-SQL Generation: Convert natural language text into SQL queries for Postgres, Redshift, and Snowflake.
• High Performance: On-par with the most capable generalist frontier models.

📦 Installation

No specific installation steps are provided in the original document.

💻 Usage Examples

Basic Usage

To use SQLCoder, set the temperature to 0 and do not perform sampling. Here is the ideal prompt structure:

<|begin_of_text|><|start_header_id|>user<|end_header_id|>

Generate a SQL query to answer this question: `{user_question}`
{instructions}

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

The following SQL query best answers the question `{user_question}`:
```sql

📚 Documentation

Model Description

• Developed by: Defog, Inc
• Model type: [Text to SQL]
• License: [CC-by-SA-4.0]
• Finetuned from model: [Meta-Llama-3-8B-Instruct]

Demo Page

You can try out SQLCoder on the demo page.

Ideal prompt and inference parameters

• Set temperature to 0, and do not do sampling.

Evaluation

This model was evaluated on SQL-Eval, a PostgreSQL based evaluation framework developed by Defog for testing and alignment of model capabilities. You can read more about the methodology behind SQLEval here.

Contact

Contact us on X at @defogdata, or on email at founders@defog.ai

🔧 Technical Details

No technical details are provided in the original document.

📄 License

The model is released under the [CC-by-SA-4.0] license.