skills.rest
nclandrei
nclandreiCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

query-data

Query local files, S3, PostgreSQL, and Google Sheets with DuckDB.

Updated Aug 27, 2026
Search Tags:#json#csv#s3#duckdb#google-sheets#data-query#cross-source
One-click install
npx skills add https://github.com/nclandrei/dotfiles --skill query-data-nclandrei
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: query-data
Source: https://github.com/nclandrei/dotfiles/tree/main/config/skills/query-data
Command: npx skills add https://github.com/nclandrei/dotfiles --skill query-data-nclandrei

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires duckdb, python3, aws, gcloud, and includes scripts (resource) and references (resource) components.

What problem does it solve?

Query data quickly across local files, S3 objects, PostgreSQL databases, and Google Sheets using DuckDB.

Core Features & Use Cases

  • Read-only data exploration across heterogeneous sources with a single SQL interface.
  • Schema discovery, sampling, joining across sources, and exporting results to CSV, JSON, or Parquet.
  • Suitable for exploratory analysis when tasks involve cross-source data and iterative queries.

Quick Start

Run read-only queries across local files, S3, PostgreSQL, and Google Sheets to inspect schemas, sample data, and export results.

Frequently Asked Questions about query-data

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

FAQPage Schema
How do I query data across S3, PostgreSQL, and Google Sheets in SQL?▼

You can query data across S3, PostgreSQL, and Google Sheets by using DuckDB to run read-only SQL joins and schema discovery across these heterogeneous sources. This enables cross-source analysis without moving data into a central warehouse first.

What's the best way to explore and sample local CSV and JSON files?▼

The best way to explore and sample local CSV and JSON files is using DuckDB to perform iterative schema discovery and data sampling. This provides a fast feedback loop for exploratory analysis directly on local files.

Do I need AWS CLI to query S3 objects with DuckDB?▼

Yes, you need optional AWS CLI authentication configured to query S3 objects. Network access is also required to load sources, while the DuckDB engine handles the actual read-only data extraction and cross-source joins.

Can I export cross-source query results to Parquet or JSON?▼

Yes, you can export cross-source query results to CSV, JSON, or Parquet formats. After running read-only analysis across sources like PostgreSQL and Google Sheets, DuckDB handles the export of the resulting dataset.

Does this approach support writing data back to PostgreSQL databases?▼

No, this approach is strictly read-only for data exploration. It supports querying, sampling, and joining across PostgreSQL and other sources, but does not support writing or modifying data back to the original databases.

Related Skills

Explore More Data & Analytics Skills→
atlanhqatlanhq
4

atlan-cli-install-configure

Install the Atlan CLI only when missing and configure tenant authentication.

Official
Advanced
bytedancebytedance
79.6k

data-analysis

Analyzes Excel and CSV files with DuckDB SQL queries and exports results to CSV, JSON, or Markdown.

Official
Intermediate
Mohamed-ElkahefMohamed-Elkahef

csv-data-visualizer

Generate interactive Plotly visualizations and statistical profiles from CSV datasets.

Community
Intermediate
SennTseSennTse

gog

Automate Google Workspace management across Gmail, Calendar, Drive, Contacts, Sheets, and Docs via CLI.

Community
Advanced