Terminal
Terminal/Skill
Set up or troubleshoot MotherDuck connections, authentication, client runtimes, and read scaling.
By MotherDuck
Works with
npx skills add motherduckdb/agent-skills --skill motherduck-connectask_docs_question tool is available, use it first for current connection behavior.md: workspace connections for multi-database exploration, bootstrap flows, and temporary validation environments.custom_user_agent where supported; for PG endpoint clients, prefer the client's application_name setting when available.Pick the connection method (above) and the runtime separately. The runtime is what actually executes queries: MotherDuck MCP, the MotherDuck CLI, a Python or Node process, or the DuckDB CLI.
For answer, review, or planning requests, inspect the available runtimes and recommend a path without installing anything. Install or configure a runtime only when the user asks to connect, build, or change the application.
Reuse the project’s language, dependencies, and working connection. Prefer MCP for chat-only exploration and the MotherDuck CLI for file-shaped Dive/Flight work or large output. For application code, use its existing runtime; choose a new runtime only when none is established.
Before installing a DuckDB client, check https://motherduck.com/docs/duckdb-versions.json and pin a MotherDuck-supported version. Keep an existing compatible pin unless the task requires an upgrade. See the runtime reference for installation examples.
SELECT 1 AS connected and then list reachable tables.session_hint.Read only the reference sections needed for the current task.
references/CONNECTION_GUIDE.md for connection-method selection, PG endpoint and native DuckDB examples, token handling, read scaling, attach modes, and common failure modesreferences/RUNTIME_SELECTION.md for the MCP-vs-Python-vs-Node-vs-CLI decision tree, detection commands, install snippets, and the DuckDB version-pinning workflowLoad related skills only for missing capabilities; reuse established context.
motherduck-explore for discovering databases, tables, columns, and shares after the connection is establishedmotherduck-query for executing DuckDB SQL against the connected databasesmotherduck-duckdb-sql for DuckDB syntax and function lookup supportmotherduck-rest-api for control-plane admin operations; those use MOTHERDUCK_ADMIN_TOKEN, which is never used for database connectionsmotherduck-cli for terminal queries and file-oriented Dive/Flight authoring