text: The connection string is likely in the form:token="..."conn_str = f"duckdb:///md:{token}@my_db"SQLChainâ€‹You can use the SQLChain to query data in your Motherduck instance in natural language.from langchain import OpenAI, SQLDatabase, SQLDatabaseChaindb = SQLDatabase.from_uri(conn_str)db_chain = SQLDatabaseChain.from_llm(OpenAI(temperature=0), db, verbose=True)From here, see the SQL Chain documentation on how to use.LLMCacheâ€‹You can also easily use Motherduck to cache LLM requests.
  Once again this is done through the SQLAlchemy wrapper.import sqlalchemyeng = sqlalchemy.create_engine(conn_str)langchain.llm_cache = SQLAlchemyCache(engine=eng)From here, see the LLM Caching documentation on how to use.PreviousMomentoNextMyScaleInstallation and SetupSQLChainLLMCacheCommunityDiscordTwitterGitHubPythonJS/TSMoreHomepageBlogCopyright Â© 2023 LangChain, Inc.