github-starred/ollama
2
0
Fork 0
mirror of https://github.com/ollama/ollama.git synced 2026-05-07 00:22:43 -05:00
Code Issues 14.5k Packages Projects Releases 120 Wiki Activity

[GH-ISSUE #2193] 🦆 Publish DuckDB-NSQL-7B on ollama #63291

New Issue
Closed
opened 2026-05-03 12:52:55 -05:00 by GiteaMirror · 5 comments
GiteaMirror commented 2026-05-03 12:52:55 -05:00
Owner
Copy Link

Originally created by @adriens on GitHub (Jan 25, 2024).
Original GitHub issue: https://github.com/ollama/ollama/issues/2193

❔ About

DuckDB-NSQL-7B, A LLM for duckdb has been released.

It would be very useful to add it to ollama so anyone could build new experiences on top if it.

🔖 Resources

Originally created by @adriens on GitHub (Jan 25, 2024). Original GitHub issue: https://github.com/ollama/ollama/issues/2193 # :grey_question: About [`DuckDB-NSQL-7B`](https://motherduck.com/blog/duckdb-text2sql-llm/), A LLM for [duckdb](https://github.com/duckdb/duckdb) has been released. It would be very useful to add it to `ollama` so anyone could build new experiences on top if it. # :bookmark: Resources - [AI That Quacks: Introducing DuckDB-NSQL-7B, A LLM for DuckDB](https://motherduck.com/blog/duckdb-text2sql-llm/) - [Demo on HuggingFace](https://huggingface.co/spaces/motherduckdb/DuckDB-NSQL-7B) - [`motherduckdb/DuckDB-NSQL-7B-v0.1-GGUF`](https://huggingface.co/motherduckdb/DuckDB-NSQL-7B-v0.1-GGUF) - [:octocat: `github.com/NumbersStationAI/DuckDB-NSQL`](https://github.com/NumbersStationAI/DuckDB-NSQL)
GiteaMirror commented 2026-05-03 12:52:57 -05:00
Author
Owner
Copy Link

@adriens commented on GitHub (Jan 25, 2024):

💡 Pushed it on MotherDuch roadmap

<!-- gh-comment-id:1910943850 --> @adriens commented on GitHub (Jan 25, 2024): :bulb: Pushed it on [MotherDuch roadmap](https://motherduck.canny.io/feature-requests/p/publish-duckdb-nsql-7b-on-ollama)
GiteaMirror commented 2026-05-03 12:52:57 -05:00
Author
Owner
Copy Link

@mxyng commented on GitHub (Jan 25, 2024):

duckdb-nsql is available here

<!-- gh-comment-id:1911118285 --> @mxyng commented on GitHub (Jan 25, 2024): duckdb-nsql is available [here](https://ollama.ai/library/duckdb-nsql)
GiteaMirror commented 2026-05-03 12:52:58 -05:00
Author
Owner
Copy Link

@adriens commented on GitHub (Jan 26, 2024):

https://ollama.ai/library/duckdb-nsql
image

<!-- gh-comment-id:1911253005 --> @adriens commented on GitHub (Jan 26, 2024): https://ollama.ai/library/duckdb-nsql ![image](https://github.com/ollama/ollama/assets/5235127/94475c94-53d6-41bf-88c3-596793472c6c)
GiteaMirror commented 2026-05-03 12:52:59 -05:00
Author
Owner
Copy Link

@adriens commented on GitHub (Jan 26, 2024):

👏 Awesome to have also dropped code samples

pip install ollama

import ollama

r = ollama.generate(
    model='duckdb-nsql:7b-q4_0',
    system='''Here is the database schema that the SQL query will run on:
CREATE TABLE taxi (
    VendorID bigint,
    tpep_pickup_datetime timestamp,
    tpep_dropoff_datetime timestamp,
    passenger_count double,
    trip_distance double,
    fare_amount double,
    extra double,
    tip_amount double,
    tolls_amount double,
    improvement_surcharge double,
    total_amount double,
);''',
    prompt='get all columns ending with _amount from taxi table',
)

print(r['response'])

... it should make a lot more things easier to implement 🚀 🦥

<!-- gh-comment-id:1911253952 --> @adriens commented on GitHub (Jan 26, 2024): :clap: Awesome to have also dropped code samples ```sh pip install ollama ``` ```python import ollama r = ollama.generate( model='duckdb-nsql:7b-q4_0', system='''Here is the database schema that the SQL query will run on: CREATE TABLE taxi ( VendorID bigint, tpep_pickup_datetime timestamp, tpep_dropoff_datetime timestamp, passenger_count double, trip_distance double, fare_amount double, extra double, tip_amount double, tolls_amount double, improvement_surcharge double, total_amount double, );''', prompt='get all columns ending with _amount from taxi table', ) print(r['response']) ``` ... it should make a lot more things easier to implement :rocket: :sloth:
GiteaMirror commented 2026-05-03 12:53:00 -05:00
Author
Owner
Copy Link

@adriens commented on GitHub (Jan 26, 2024):

image

<!-- gh-comment-id:1912794734 --> @adriens commented on GitHub (Jan 26, 2024): ![image](https://github.com/ollama/ollama/assets/5235127/d0daf0a5-6e19-415b-bf08-d65c17791719)
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
amd
api
app
bug
build
cli
cloud
compatibility
context-length
create
docker
documentation
embeddings
feature request
feedback wanted
good first issue
gpt-oss
gpu
harmony
help wanted
image
install
intel
js
launch
linux
macos
memory
mlx
model
needs more info
networking
nvidia
ollama.com
performance
pull-request
Mirrored from GitHub Pull Request
 python
question
registry
rendering
thinking
tools
top
vulkan
windows
wsl
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/ollama#63291
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?