duckdb-motherduck-parquet

Integrate DuckDB, MotherDuck, and remote Parquet sources in Node.js/TypeScript.

1|Updated Dec 30, 2025
One-click install
npx skills add https://github.com/SecurityRonin/ronin-marketplace --skill duckdb-motherduck-parquet
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: duckdb-motherduck-parquet
Source: https://github.com/SecurityRonin/ronin-marketplace/tree/main/plugins/data-skills/skills/duckdb-motherduck-parquet
Command: npx skills add https://github.com/SecurityRonin/ronin-marketplace --skill duckdb-motherduck-parquet

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps developers build scalable analytics applications by combining an embedded OLAP engine (DuckDB), a cloud-hosted DuckDB instance (MotherDuck), and Parquet columnar storage. It simplifies data access and analysis across serverless and client environments.

Core Features & Use Cases

  • Unified analytics stack: run OLAP queries locally or in the cloud against Parquet sources.
  • Remote Parquet loading: load Parquet data from URLs or cloud storage (S3, GCS, etc.) into DuckDB queries.
  • MotherDuck integration: securely connect to MotherDuck via token-based connection strings and manage workloads in serverless contexts.

Quick Start

Install the required packages and create a connection using a MotherDuck token in the connection string, then run a sample read_parquet query to verify setup.

Frequently Asked Questions about duckdb-motherduck-parquet

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run DuckDB queries against remote Parquet files in Node.js?

You can run DuckDB queries against remote Parquet files in Node.js by using the duckdb-node APIs to execute SQL with the read_parquet function, loading data directly from HTTPS URLs into your analytics workload.

What is the best way to connect a Node.js app to MotherDuck securely?

To connect a Node.js app to MotherDuck securely, you configure a token-based connection string that authenticates your session, allowing you to manage serverless cloud analytics workloads without exposing raw credentials.

Can I use DuckDB and MotherDuck together for server-side analytics in TypeScript?

Yes, you can use DuckDB and MotherDuck together for server-side analytics in TypeScript by integrating an embedded local OLAP engine with a cloud-hosted instance to run SQL queries against Parquet sources.

Does DuckDB support loading Parquet data directly from S3 or GCS cloud storage?

DuckDB supports loading Parquet data directly from S3, GCS, and other cloud storage by using the read_parquet function with remote URLs, simplifying data access across serverless and client analytics environments.

How do I set up an OLAP analytics stack with Parquet and MotherDuck?

You set up an OLAP analytics stack by installing required Node.js packages, creating a MotherDuck connection using a secure token in the connection string, and running a sample read_parquet query to verify remote data loading.

Why use MotherDuck instead of just local DuckDB for Parquet analytics?

Using MotherDuck instead of only local DuckDB allows you to scale OLAP workloads into a serverless cloud environment, managing remote analytics contexts while still querying Parquet data with the same DuckDB SQL syntax.