MotherDuck

A MotherDuck connection string looks like md:my_db?motherduck_token=…, and one token reaches every database on its account, so name the databases and schemas Dot may use.

Dot reads tables and views from DuckDB’s catalog and writes DuckDB SQL, and read queries open the connection read-only.

Dot sees what its token sees, narrowed by your database and schema lists. For per-person rows, Dot’s row-level rules (Team plan) filter each query by the asker’s groups or attributes.

On every MotherDuck connection Dot turns off community extensions and DuckDB’s local file system, locks that configuration, and checks each query before it runs, so no question can reach files on the machine Dot runs on.

As of October 2026, MotherDuck offers a remote MCP server (fully managed, with read and read-write query tools) and a local one (self-hosted, read-only by default), plus AI functions in SQL: prompt() sends text to an LLM row by row, and prompt_sql turns a question into SQL.

Use those when one person wants their own assistant on MotherDuck, or LLM calls inside SQL, like tagging reviews. Use Dot when a whole team asks in Slack, Teams or email and needs shared definitions, scheduled reports and per-person rows across MotherDuck and your other sources.

• MotherDuck MCP Server
• MotherDuck PROMPT function