Text to SQLCode

CodeS

An early line of open text-to-SQL models starting at 1B, including variants fine-tuned for specific database schemas.

The last open version came out in Oct 2023. The family has not been updated for a long time: the model still works, but do not expect fixes or new sizes.

Developer
RUCKBReasoning, Renmin University of China, China
First release
Aug 2023
Latest release
Oct 2023
Sizes
1B – 15B
License
Commercial use allowedApache 2.0
Russian
Not supported
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

  • Turning an employee question into an SQL query
  • Drafting warehouse queries for a report
  • Embedding into a BI dashboard as a helper

Where it is used

Analytics and reportingFinance departmentsOnline stores

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
fits
ClusterServer with several GPUs — flagship versions
no versions

Versions

  1. CodeS для Spider и доменных баз
  2. CodeS для BIRD
  3. CodeS 1B – 15B (базовые)

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.

Frequently asked questions

Can CodeS 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 CodeS 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 CodeS support Russian?

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

Where can I download CodeS and what does it cost?

The CodeS 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 SQLOmniSQLRenmin University of China (RUC) · ChinaCommercial use allowed

Models for turning questions into SQL, trained on millions of synthetic query examples across different databases. Three sizes for different hardware.

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.

DetailsText to SQLXiYanSQL-QwenCoderAlibaba · ChinaCommercial use allowed

Alibaba models for turning questions into SQL, based on Qwen2.5-Coder. They work with different SQL dialects; a small 3B version suits modest hardware.

Details

Source: huggingface.co/seeklhy/codes-15b. Data checked against the model card on 22 Sep 2026. Have a lawyer review the license before commercial launch.