FlockMTL DuckDB extension brings LLM and RAG functions directly into SQL
_reachsumit · x · 2026-09-15
Researchers introduce FlockMTL, a DuckDB extension that deeply integrates LLMs and RAG into the DBMS, offering model-driven scalar and aggregate SQL functions for summarization, classification, and hybrid search with tuple-level chained predictions.
Design highlights:
- New PROMPT and MODEL DDL abstractions as first-class schema objects alongside TABLE, enabling resource independence
- Cost-based optimization seamlessly applies batching and caching
The goal is to streamline knowledge-intensive analytical apps by removing cross-system orchestration, data movement, and context-management overhead. Paper and code are open.
More from coding & agent
- MiniMax launches Design: an agent-driven canvas that turns one brief into a full video production — Hailuo_AI · 2026-09-15
- Anthropic explains how it contains its own agents with gVisor, system sandboxes and restricted VMs — emmanuelvivier · 2026-09-15
- How to write tests in the AI era: 6 rules to stop mock-riddled brittle tests — dotey · 2026-09-15
- Qdrant engineer to demo a self-healing research agent that learns from its own run history — qdrant_engine · 2026-09-15
- XWiki clarifies its MCP server is optional, not a forced-in AI assistant — LorinaBalan · 2026-09-15
- Dev Finds Screen Casting Trivial to Implement, but Codex and Claude Both Took the Long Way Around — ezshine · 2026-09-15