超越鸣叫:语言模型和 RAG 与 DuckDB 的深度整合 (VLDB Demo 2025)
Table of Contents
About The Project
Features
Getting StartedPrerequisites
Installation
Usage
Roadmap
Feedback and Issues
License
Acknowledgments
Flock is an advanced DuckDB extension that seamlessly integrates analytics with semantic analysis through declarative SQL queries. Designed for modern data analysis needs, Flock empowers users to work with structured and unstructured data, combining OLAP workflows with the capabilities of LLMs (Large Language Models) and RAG (Retrieval-Augmented Generation) pipelines.
To cite the project:
@article{10.14778/3750601.3750685,
author = {Dorbani, Anas and Yasser, Sunny and Lin, Jimmy and Mhedhbi, Amine},
title = {Beyond Quacking: Deep Integration of Language Models and RAG into DuckDB},
journal = {Proc. VLDB Endow.},
year = {2025},
volume = {18},
number = {12},
doi = {10.14778/3750601.3750685},
url = {https://doi.org/10.14778/3750601.3750685}
}back to top
flock_get_metrics() for better cost and performance monitoring.context_columns abstraction (with type: 'audio').back to top
back to top
Flock can be installed in two ways:
Flock is a Community Extension available directly from DuckDB's community catalog.
INSTALL flock FROM community;LOAD flock;If you want to build Flock from source or contribute to the project, you can use our automated build script:
Clone the repository with submodules:
git clone --recursive https://github.com/dais-polymtl/flock.git
cd flockOr if you've already cloned without submodules:
git submodule update --init --recursiveRun the build and run script:
./scripts/build_and_run.shThis interactive script will guide you through:
The script will automatically detect your system configuration and use the appropriate build tools (Ninja or Make).
The script will launch DuckDB with Flock extension ready to use. Make sure to check the documentation for usage examples.
Requirements for building from source:
back to top
Using Flock, you can run semantic analysis tasks directly in DuckDB. For example:
SELECT llm_complete(
{ 'model_name': 'summarizer'},
{ 'prompt_name': 'description-generation', 'context_columns': [{ 'data': product_name }]}
) AS product_description
FROM UNNEST(['Wireless Headphones', 'Gaming Laptop', 'Smart Watch']) AS t(product_name);Explore more usage examples in the documentation.
If you are a contributor or want to work on Flock itself, see the dedicated Developer Guide for build, testing, and contribution details.
back to top
Our roadmap outlines upcoming features and improvements. Stay updated by checking out our detailed plan.
back to top
We value your feedback! If you’d like to report an issue or suggest a new feature, please use the links below:
For contributing code or other contributions, please refer to our dedicated Contribution Guidelines.
back to top
This project is licensed under the MIT License. See the LICENSE file for details.
back to top
This project is under active development by the Data & AI Systems Laboratory (DAIS Lab) at Polytechnique Montréal.
back to top
暂无开放 Issues,或尚未同步最近议题。