# Prem-1B-SQL Projects at AI Tinkerers

> Canonical HTML: https://aitinkerers.org/technologies/prem-1b-sql
> Markdown URL: https://aitinkerers.org/technologies/prem-1b-sql.md
> Technology record last updated: 2026-04-11T18:20:51Z
> Generated: 2026-09-21T00:45:45Z

Prem-1B-SQL is a 1.3B-parameter, open-source Small Language Model (SLM) for Text-to-SQL, engineered for local-first deployment and maximum data security.

This is your go-to model for secure, efficient natural language querying of databases. Prem-1B-SQL is a 1.3B-parameter SLM, fully fine-tuned from DeepSeek-1.3B, dedicated to the Text-to-SQL task. Its core value is its local-first architecture: it runs on low GPU or quantized CPU devices, ensuring your proprietary data never leaves your environment or touches a third-party API. The model integrates seamlessly with the open-source PremSQL library, which provides end-to-end pipelines, including robust executors, evaluators, and error handling for autonomous data analysis. It consistently delivers competitive execution accuracy on industry benchmarks like BirdBench, proving that a small, secure model can handle enterprise-grade data analysis.

- Official technology site: https://premai.io/docs/premsql/introduction
- Public AI Tinkerers demos and talks: 1
- Result page: 1 of 1

## Recent Public Talks and Demos

### [PremSQL: Towards Fully open source and private AI copilot for Data Analysis using natural language](https://bengaluru.aitinkerers.org/talks/rsvp_Z-MRoMs-YMY)

PremSQL is a fully open source project which aims for autonomous data analysis. Whether it is just data analysis for some personal project or from doing analysis around company data, it takes immense skill and time to analyse data. However, lot of cases, we might not be having the required skill to work on different analysis. So there comes PremSQL. With PremSQL, you can do the following: - connect databases (MySQL, Postgres, SQLite etc) and chat with it - connect with CSVs and do the same - import any kaggle dataset and do the same Analysis includes querying to databases, qna around the tables inside the DBs, plotting charts, all with natural language. Not only that it comes with Prem-1B-SQL which is a 1B parameter model. This runs locally (supports ollama / apple mlx also). Last but not the least premsql is a python library and you can fine-tune your own model for text to SQL and extend the provided functionalities according to your needs.

- Event context: AI Tinkerers Bangalore - November - RSVP REQUIRED — 2024-11-12 — Bengaluru
- Public talk page: https://bengaluru.aitinkerers.org/talks/rsvp_Z-MRoMs-YMY

## Related Technologies

- [Ollama](https://aitinkerers.org/technologies/ollama) ([Markdown](https://aitinkerers.org/technologies/ollama.md)) — 77 public demos
- [PostgreSQL](https://aitinkerers.org/technologies/postgresql) ([Markdown](https://aitinkerers.org/technologies/postgresql.md)) — 105 public demos
- [PremSQL](https://aitinkerers.org/technologies/premsql) ([Markdown](https://aitinkerers.org/technologies/premsql.md)) — 1 public demo
- [Python](https://aitinkerers.org/technologies/python) ([Markdown](https://aitinkerers.org/technologies/python.md)) — 662 public demos