| license: other | |
| language: | |
| - en | |
| pipeline_tag: text-generation | |
| inference: false | |
| tags: | |
| - transformers | |
| - gguf | |
| - imatrix | |
| - sqlcoder-7b-2 | |
| Quantizations of https://huggingface.co/defog/sqlcoder-7b-2 | |
| # From original readme | |
| ## Uses | |
| This model is intended to be used by non-technical users to understand data inside their SQL databases. It is meant as an analytics tool, and not as a database admin tool. | |
| This model has not been trained to reject malicious requests from users with write access to databases, and should only be used by users with read-only access. | |
| ## How to Get Started with the Model | |
| Use the code [here](https://github.com/defog-ai/sqlcoder/blob/main/inference.py) to get started with the model. | |
| ## Prompt | |
| Please use the following prompt for optimal results. Please remember to use `do_sample=False` and `num_beams=4` for optimal results. | |
| ``` | |
| ### Task | |
| Generate a SQL query to answer [QUESTION]{user_question}[/QUESTION] | |
| ### Database Schema | |
| The query will run on a database with the following schema: | |
| {table_metadata_string_DDL_statements} | |
| ### Answer | |
| Given the database schema, here is the SQL query that [QUESTION]{user_question}[/QUESTION] | |
| [SQL] | |
| ``` |