The company is also releasing DuckDB-NSQL-7B, a text-to-SQL model that is aware of all documented features in DuckDB 0.9.2, including official extensions. This model was trained on about 200k synthetically generated and validated DuckDB SQL queries, guided by the DuckDB documentation, and more than 250k general Text-2-SQL questions from Numbers Station. The model weights are fully released on Hugging Face and also in a quantized GGUF format for use with llama.cpp.
Key takeaways:
- MotherDuck has launched "FixIt," a feature that helps analysts stay focused on their SQL by pinpointing errors in their queries and suggesting fixes.
- In partnership with Numbers Station, MotherDuck is open sourcing a DuckDB specific text-to-SQL LLM to give back to the DuckDB community and help seed interesting DuckDB applications.
- DuckDB-NSQL-7B is a new text-to-SQL model that is aware of all documented features in DuckDB 0.9.2, including official extensions. It was trained on about 200k synthetically generated and validated DuckDB SQL queries.
- The DuckDB-NSQL-7B model can be tried out on the Hugging Face space and can also be run locally for a fully local experience with llama.cpp.