Text to SQLCode

Prem-1B-SQL

A text-to-SQL model of just 1B parameters, designed to run locally so the database never leaves for external services.

Developer
Prem AI, UK
First release
Aug 2024
Latest release
Sep 2025
Sizes
1B
License
Commercial use allowedApache 2.0
Russian
Not supported
Ready-made builds
GGUF
Running
On your own serverAlso runs without a GPU
Industries
Finance, Retail and marketplaces, Software development
Deploy on your server Hugging Face GitHub

What it does

  • Local translation of questions into SQL with no internet access
  • Query hints on modest hardware
  • Embedding into internal analytics tools

Where it is used

Analytics and reportingCompanies with strict data-protection requirementsDevelopment

Hardware requirements

LaptopLaptop or regular PC, up to 8 GB of VRAM — smaller versions
fits
1 GPUOne GPU with 16–80 GB — mid-size versions
no versions
ClusterServer with several GPUs — flagship versions
no versions

Versions

  1. Обновление карточки и библиотеки PremSQL
  2. Prem-1B-SQL

How to run it

On your own serverWeights are downloaded from Hugging Face and served with vLLM (load and API) or llama.cpp (modest hardware). The model then runs in a closed network with no per-request fees.Hugging Face
How much hardware you needCalculate the VRAM for the model size, context length and number of concurrent requests.Open the hardware calculator

I can set this up end to end: pick the model size, deploy it on your server and connect it to your systems. Quantization compresses a model so it takes less video memory and runs on more modest hardware. Answers change slightly, so quality is checked on your own examples.

Frequently asked questions

Can Prem-1B-SQL be used in a commercial project?

Yes. License: Apache 2.0. It allows commercial use, but it is still worth having a lawyer review the license before launch.

What hardware does Prem-1B-SQL need?

At minimum: Laptop or regular PC, up to 8 GB of VRAM — smaller versions. Some versions also run on an ordinary CPU, without a GPU. You can calculate the exact VRAM for your model size and context in the hardware calculator.

Does Prem-1B-SQL support Russian?

No. The developer documentation lists the supported languages and Russian is not among them.

Where can I download Prem-1B-SQL and what does it cost?

The Prem-1B-SQL weights are open and free to download. You only pay for the hardware it runs on and for the setup. Source links are at the bottom of this page.

How I deploy it for clients

  1. SelectionI pick the model size for your task and hardware and test it on your examples.
  2. DeploymentI deploy it on your server or in a closed network and provide an API.
  3. Fine-tuningI fine-tune it on your data (LoRA) or connect a knowledge base — whichever is cheaper for the task.
  4. IntegrationI connect it to your CRM, ERP, bot, website or team chat and set up monitoring.

Similar models

Text to SQLDuckDB-NSQLMotherDuck and Numbers Station · USACommercial use with conditions

A model for turning questions into SQL, built for the embedded analytics database DuckDB. Available in Ollama, convenient for working with CSV and Parquet locally.

DetailsText to SQLNSQLNumbers Station · USACommercial use with conditions

One of the first open text-to-SQL lines, including very small versions from 350M that run on an ordinary PC.

DetailsText to SQLSQLCoderDefog · USACommercial use with conditions

One of the first open models that turn a plain-language question into an SQL query against a database. Available in Ollama, but newer competitors are already stronger.

Details

Source: huggingface.co/prem-research/prem-1B-SQL. Data checked against the model card on 22 Sep 2026. Have a lawyer review the license before commercial launch.