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.