skills.rest
vathymut
vathymutCOMMUNITY
Explore all skills by this author →
Website𝕏@vathymutGitHub

duckdb

Execute SQL queries and analyze spatial data with DuckDB.

Updated Apr 19, 2026
Search Tags:#SQL#database#data analysis#DuckDB#spatial data
One-click install
npx skills add https://github.com/vathymut/copilot-skills --skill duckdb-vathymut
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: duckdb
Source: https://github.com/vathymut/copilot-skills/tree/main/.github/skills/duckdb
Command: npx skills add https://github.com/vathymut/copilot-skills --skill duckdb-vathymut

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill simplifies interaction with DuckDB databases and associated files, enhancing the speed and ease of working with SQL data.

Core Features & Use Cases

  • SQL Execution: Execute SQL queries against attached databases or files directly.
  • Data Access: Read, profile, and query data files with built-in functionality.
  • Spatial Analysis: Analyze spatial data using DuckDB's spatial extension.
  • Documentation: Quick access to DuckDB documentation and resources.
  • Installation: Manage DuckDB extensions and installations.
  • Use Case: A data scientist uses this skill to run complex SQL queries on large datasets stored in DuckDB files, without leaving their workflow.

Quick Start

Start the duckdb skill by invoking a command such as 'query' or 'data-access' followed by your SQL query or data management task.

Frequently Asked Questions about duckdb

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

FAQPage Schema
How do I run SQL queries on local data files without a separate database server?▼

DuckDB allows you to execute SQL queries directly against attached databases and local files. This skill automates ad-hoc SQL execution and data profiling on large datasets without requiring a separate server setup.

Can I perform spatial analysis using DuckDB?▼

Yes, you can perform spatial analysis using DuckDB's spatial extension. This skill automates the activation and use of spatial extensions to process and query spatial data directly within your database environment.

Does this approach support importing and exporting large datasets for analysis?▼

Yes, DuckDB supports data import and export alongside ad-hoc querying. This skill automates data access and file management tasks, making it ideal for data scientists handling large datasets stored in DuckDB files.

What is the best way to automate data profiling on DuckDB databases?▼

Automating data profiling is achieved by executing SQL queries against attached databases. This skill provides built-in functionality to read, profile, and query data files directly, streamlining the data profiling process.

How do I manage DuckDB extensions and installations during my workflow?▼

DuckDB extensions and installations can be managed directly through SQL commands. This skill provides quick access to manage extensions, installations, and DuckDB documentation without leaving your current workflow.

Why use DuckDB for ad-hoc analysis instead of traditional database systems?▼

DuckDB is designed for efficient data querying and management directly on local files without server overhead. This skill simplifies interaction with DuckDB databases, enhancing the speed and ease of working with SQL data for ad-hoc analysis.

Related Skills

Explore More Data & Analytics Skills→
clawdataclawdata
24

duckdb

Query local DuckDB warehouses with SQL and ingest CSV, Parquet, and JSON files.

Official
Intermediate
crossxwillcrossxwill
5

duckdb-parquet-lab-workflow

Query Parquet data with DuckDB and convert results to pandas DataFrames.

Community
Intermediate
antvisantvis
4.0k

antv-l7

Compose interactive geospatial visualizations with AntV L7.

Official
Advanced
herdiansahherdiansah
23

sql-optimization-patterns

Analyze PostgreSQL execution plans and optimize SQL query performance.

Community
Advanced