skills.rest
Cozythecoder
CozythecoderCOMMUNITY
Explore all skills by this author →
GitHub

opendata-api

Query OpenData REST API datasets with filtering, sorting, SQL SELECTs, and JSON/CSV/TSV/XLSX exports.

4|Updated Apr 9, 2026
Search Tags:#rest api#data pipelines#dataset discovery#opendata#data querying#duckdb sql#csv xlsx export
One-click install
npx skills add https://github.com/Cozythecoder/frontend-design-md --skill opendata-api
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: opendata-api
Source: https://github.com/Cozythecoder/frontend-design-md/tree/main/plugins/opendata/skills/opendata-api
Command: npx skills add https://github.com/Cozythecoder/frontend-design-md --skill opendata-api

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

It removes the friction of finding, filtering, and exporting dataset rows from OpenData sources by providing a single REST API that supports common research and pipeline tasks without bespoke data wrangling.

Core Features & Use Cases

  • Dataset discovery for LLM workflows: Find relevant datasets via natural-language search endpoints, including enriched metadata and column details, to speed up research on unclear prompts.
  • Flexible REST querying and exports: Query rows, filter, sort, paginate, and export results as JSON/CSV/TSV/XLSX with projection and response-shaping options.
  • SQL execution for advanced analysis: Run authenticated, read-only DuckDB SQL for complex transformations, including cross-dataset joins through a dedicated SQL endpoint.

Quick Start

Use the opendata-api skill to query FRED CPI data by asking: "Fetch the latest 5 rows from the FRED CPI dataset, sorted by date descending, and return JSON."

Frequently Asked Questions about opendata-api

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

FAQPage Schema
How do I query public datasets using a REST API?▼

Query public datasets by making REST calls to the /v1/datasets endpoint using provider/dataset paths, applying filter[col] syntax with proper URL encoding for filtering, sorting, and pagination.

Can I export REST API data query results to CSV or XLSX?▼

You can export REST API data query results as JSON, CSV, TSV, or XLSX formats by utilizing the projection and response-shaping options available on the flat dataset endpoints.

How do I run cross-dataset joins on public data?▼

Run cross-dataset joins on public data by executing authenticated, read-only DuckDB SQL queries through the dedicated SQL endpoint to perform complex SELECT-only transformations.

What is the best way to discover datasets for LLM workflows?▼

Discover datasets for LLM workflows by querying the /v1/discover endpoint, which provides natural-language search capabilities enriched with metadata and column details for research.

Are there limitations to the SQL interface for data querying?▼

The SQL interface for data querying is limited to read-only SELECT statements and requires authentication, ensuring safe operations without allowing destructive modifications to the underlying public datasets.

Related Skills

Explore More Data & Analytics Skills→
ssmleossmleo

bigquery-basics

Create and manage BigQuery datasets, tables, and SQL queries.

Community
Intermediate
loganylchenloganylchen

spreadsheet

Create, edit, analyze, and visualize .xlsx, .csv, and .tsv spreadsheets with Python.

Community
Intermediate
cameronraysmithcameronraysmith
14

preferences-json-querying

Query and transform JSON data with DuckDB and jaq.

Community
Intermediate
tassiovaletassiovale
13

database-lookup

Retrieve data from 78 public scientific databases via REST API calls.

Community
Advanced