Warehouses connector
MotherDuck connector for governed AI agent access
Connect MotherDuck through its PostgreSQL wire protocol endpoint with a service token.
Direct answer
OneQuery supports MotherDuck for governed agent access.
Teams use the MotherDuck connector to give AI agents SQL-style query workflows for structured data access while OneQuery keeps credentials centralized, limits access to approved sources, and preserves audit logs for review.
Agent workflow
What this connector enables
MotherDuck becomes an approved OneQuery source instead of a secret copied into an agent prompt, shell session, or model tool. The agent receives a governed access path, and the source credentials stay behind OneQuery.
- Use SQL-style query workflows for structured data access for warehouses context.
- Keep MotherDuck credentials centralized and out of agent runtimes.
- Review agent access through OneQuery audit history instead of reconstructing direct service usage.
Setup checklist
Prepare the MotherDuck connection
Use motherduck credentials and connect the source through the Dashboard and CLI. Keep credentials scoped to the data the agent is allowed to read.
- Create a MotherDuck service token with access to the target database.
- Use `md:` for the default database, or `md:database_name` for a specific MotherDuck database.
- Only override host, port, or username if MotherDuck documents a different endpoint for your environment.
FAQ
MotherDuck connector questions
What is the OneQuery MotherDuck connector?
The OneQuery MotherDuck connector makes warehouses context from MotherDuck available to AI agents through SQL-style query workflows for structured data access. Connect MotherDuck through its PostgreSQL wire protocol endpoint with a service token.
How do AI agents access MotherDuck through OneQuery?
Agents call OneQuery instead of receiving raw MotherDuck credentials. OneQuery keeps credentials centralized, applies source boundaries, and records access in audit logs while exposing SQL-style query workflows for structured data access.
How do I set up the MotherDuck connector?
Prepare motherduck credentials and connect MotherDuck from the OneQuery dashboard or CLI. Start with this setup step: Create a MotherDuck service token with access to the target database.