observable-framework-sql

Execute SQL queries on CSV, JSON, Arrow, and Parquet files with DuckDB in Observable Framework.

Updated Feb 28, 2026
One-click install
npx skills add https://github.com/spqw/skill-observable-framework --skill observable-framework-sql
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: observable-framework-sql
Source: https://github.com/spqw/skill-observable-framework/tree/main/skills/observable-framework-sql
Command: npx skills add https://github.com/spqw/skill-observable-framework --skill observable-framework-sql

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill simplifies querying data directly within Observable Framework projects using SQL, enabling efficient data manipulation and analysis without leaving the framework.

Core Features & Use Cases

  • Client-side SQL with DuckDB: Query data from various file formats (CSV, JSON, Parquet, Arrow) directly in the browser.
  • SQL Code Blocks: Write and execute SQL queries directly within Markdown files.
  • Data Visualization Integration: Seamlessly use SQL query results with Observable Plot for dynamic visualizations.
  • Use Case: Analyze a large dataset of astronomical observations stored in a Parquet file by writing SQL queries to filter, aggregate, and then visualize the results using Observable Plot.

Quick Start

Use the observable-framework-sql skill to query the first 10 rows from the 'gaia' table.

Frequently Asked Questions about observable-framework-sql

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

FAQPage Schema
How do I query CSV and Parquet files using SQL in Observable Framework?

You can query CSV and Parquet files in Observable Framework by writing SQL queries in Markdown code blocks or tagged template literals. An integrated DuckDB client executes these SQL queries directly in the browser to return data.

Can I use DuckDB to query JSON and Apache Arrow files in Observable Framework?

Yes, you can use the integrated DuckDB client to query JSON and Apache Arrow files in Observable Framework. The SQL querying functionality supports these local and remote data sources for direct browser-based analysis.

How do I visualize SQL query results with Observable Plot?

To visualize SQL query results with Observable Plot, you execute SQL queries against your data sources using the integrated DuckDB client, then pass the resulting data directly into Observable Plot for dynamic visualizations.

What is the best way to analyze large datasets client-side in Observable Framework?

The best way to analyze large datasets client-side in Observable Framework is using SQL queries with the integrated DuckDB client. It efficiently filters and aggregates large files like Apache Parquet directly within the browser.

Do I need a separate database server to run SQL queries in Observable Framework?

No, you do not need a separate database server to run SQL queries in Observable Framework. The Skill uses an integrated DuckDB client to execute SQL directly in the browser against local or remote files.

Can I use dynamic SQL queries in Markdown files with Observable Framework?

Yes, you can use dynamic SQL queries in Markdown files with Observable Framework. The Skill supports SQL code blocks and tagged template literals for dynamic data manipulation and analysis.