Skip to main content
MotherDuck is a cloud data warehouse powered by DuckDB.

​
Installation and Setup

First, you need to install duckdb python package. 
pip install duckdb
You will also need to sign up for an account at MotherDuck After that, you should set up a connection string - we mostly integrate with Motherduck through SQLAlchemy. The connection string is likely in the form: 
token="..."

conn_str = f"duckdb:///md:my_db?motherduck_token={token}"
For more authentication options, see the MotherDuck SQLAlchemy documentation.

​
SQLChain

You can use the SQLChain to query data in your MotherDuck instance in natural language. 
from langchain_openai import OpenAI
from langchain_community.utilities import SQLDatabase
from langchain_experimental.sql import SQLDatabaseChain
db = SQLDatabase.from_uri(conn_str)
db_chain = SQLDatabaseChain.from_llm(OpenAI(temperature=0), db, verbose=True)

​
LLMCache

You can also easily use MotherDuck to cache LLM requests. Once again this is done through the SQLAlchemy wrapper. 
import sqlalchemy
from langchain.globals import set_llm_cache
eng = sqlalchemy.create_engine(conn_str)
set_llm_cache(SQLAlchemyCache(engine=eng))
Edit this page on GitHub or file an issue.
Connect these docs to Claude, VSCode, and more via MCP for real-time answers.