skills.rest
spqw
spqwCOMMUNITY
Explore all skills by this author →
GitHub

observable-framework-lib-duckdb

Integrate DuckDB-Wasm for in-browser SQL analytics in Observable Framework projects.

Updated Feb 28, 2026
Search Tags:#analytics#sql#data processing#duckdb#in-browser#observable framework
One-click install
npx skills add https://github.com/spqw/skill-observable-framework --skill observable-framework-lib-duckdb
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: observable-framework-lib-duckdb
Source: https://github.com/spqw/skill-observable-framework/tree/main/skills/observable-framework-lib-duckdb
Command: npx skills add https://github.com/spqw/skill-observable-framework --skill observable-framework-lib-duckdb

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill enables powerful in-browser SQL analytics by integrating DuckDB, allowing users to query data directly within their web applications without server-side processing.

Core Features & Use Cases

  • In-Browser SQL Queries: Execute SQL queries directly in the browser using DuckDB-Wasm.
  • Data Loading: Supports loading data from various sources including CSV, Parquet, JSON, and DuckDB files via FileAttachment.
  • Use Case: Analyze large datasets like the Gaia Star Catalog directly in the browser to visualize astronomical data, or process earthquake data from USGS feeds for real-time mapping.

Quick Start

Use the observable-framework-lib-duckdb skill to load 'gaia-sample.parquet' and query the count of stars.

Frequently Asked Questions about observable-framework-lib-duckdb

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

FAQPage Schema
How do I run in-browser SQL queries on Parquet files in Observable Framework?▼

Run in-browser SQL queries by integrating DuckDB-Wasm to load Parquet files via FileAttachment and execute SQL queries directly in the client without server-side dependencies. This enables advanced data manipulation directly within your Observable Framework projects.

What data formats can I query using DuckDB-Wasm in the browser?▼

DuckDB-Wasm supports loading and querying data from various file formats including CSV, Parquet, JSON, and DuckDB files. Data is loaded using the FileAttachment method within your Observable Framework project for client-side processing.

Do I need a backend server to analyze large datasets like the Gaia Star Catalog in the browser?▼

No server-side dependencies are needed to analyze large datasets like the Gaia Star Catalog. DuckDB-Wasm executes SQL queries entirely in the browser, allowing you to load Parquet files and visualize astronomical data directly on the client.

What is the best way to process real-time earthquake data feeds without a server?▼

Processing real-time earthquake data without a server is best achieved using DuckDB-Wasm for in-browser SQL analytics. You can load data feeds like USGS earthquake data directly in the client and execute SQL queries to map the results.

Can I use DuckDB-Wasm for data visualization in Observable Framework without server-side processing?▼

Yes, DuckDB-Wasm enables in-browser SQL analytics for data visualization in Observable Framework without server-side processing. You can load datasets from formats like CSV and Parquet, manipulate them with SQL, and visualize the results directly in the client.

Related Skills

Explore More Data & Analytics Skills→
nq-rdlnq-rdl

convert-file

Convert data files between formats using DuckDB COPY statements.

Official
Intermediate
data-desk-ecodata-desk-eco

notebooks-front-end

Edit Observable notebooks and docs/index.html to create interactive visualizations.

Official
Intermediate
spqwspqw

observable-framework-convert

Convert Observable notebooks into Markdown and vanilla JavaScript for Framework projects.

Community
Intermediate
jupremjuprem

analytics-dashboarder

Aggregate SQL data with Drizzle and visualize it using Recharts.

Community
Advanced