motherduck-connect

What problem does it solve?

This Skill solves the challenge of getting reliable, secure connectivity from an application or runtime to MotherDuck so you can start working with data without guessing connection strings, SSL settings, or token handling.

Core Features & Use Cases

• Connection method selection: Choose the right path (PG endpoint vs native DuckDB md: connection vs alternatives) based on workload needs like hybrid execution, local file access, and query control.
• Runtime-aware installation: Detect whether to use MCP tools, uv, Python/pip, Node, or the DuckDB CLI, while pinning to a MotherDuck-supported DuckDB version.
• Operational safety defaults: Prefer environment-managed tokens, verify connections with a lightweight query, and apply read-scaling/session affinity guidance when needed.
• Use case: Configure a backend service or BI workflow to connect to the correct MotherDuck database, verify access, and prepare for subsequent exploration and querying.

Quick Start

Use the motherduck-connect skill to establish a verified, SSL-secured connection to your target MotherDuck database, then proceed to list and query tables.