read-file
read-file uses DuckDB to load and analyze data files across multiple formats—CSV, JSON, Parquet, Avro, Excel, spatial, and SQLite—from local paths or remote sources like S3 and HTTPS. It automatically detects file type, retrieves schema and row counts, and displays sample rows to help you understand your dataset at a glance.
read-file loads and previews local or remote data files in formats like CSV, JSON, Parquet, Excel, and SQLite using DuckDB.
AI-generated summary based on this skill's SKILL.md
Decision gist · record as of 2026-04-23
read-file loads and previews local or remote data files in formats like CSV, JSON, Parquet, Excel, and SQLite using DuckDB. read-file uses DuckDB to load and analyze data files across multiple formats—CSV, JSON, Parquet, Avro, Excel, spatial, and SQLite—from local paths or remote sources like S3 and HTTPS. It automatically detects file type, retrieves schema and row counts, and displays sample rows to help you understand your dataset at a glance.
Use it when
- read-file supports CSV, JSON, Parquet, Avro, Excel, SQLite, NDJSON, TSV, and spatial formats like shapefiles.
- Yes.
Verify before relying
Read SKILL.md below before installing (1 file). Open directory: indexed for reading, not audited.
Similar skills
Install
duckdb/duckdb-skills/read-file · repository language: Shell
Open directory. Skills are indexed for reading, not audited. Review a skill's body before installing it.
Frequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
How do I read a CSV file with read-file?
read-file loads CSV files directly using DuckDB's native CSV parser. Simply provide the local file path or remote URL, and read-file automatically detects the format, retrieves the schema, row count, and displays sample rows so you can preview your data instantly.
What file formats does read-file support?
read-file supports CSV, JSON, Parquet, Avro, Excel, SQLite, NDJSON, TSV, and spatial formats like shapefiles. It uses DuckDB to handle format detection and querying, letting you load and analyze data across all these formats from local paths or remote sources.
Can read-file load data from cloud storage like S3?
Yes. read-file reads files from S3, GCS, and Azure blob storage, as well as remote HTTPS URLs. You can preview datasets directly from cloud sources without downloading them locally first, making it easy to inspect large remote datasets.
How do I inspect a data file's schema and row count?
read-file automatically inspects your dataset when you load it. It retrieves the schema (column names and types), total row count, and displays sample rows in one operation, giving you a complete overview of your data structure without manual inspection steps.
Can read-file convert between data formats?
read-file can query and read data across multiple formats—CSV, JSON, Parquet, Excel, and SQLite—using DuckDB. While primarily a loader and inspector, its format flexibility lets you work with data in different formats and understand their contents.
Does read-file handle spatial or geospatial data?
read-file supports spatial file formats like shapefiles, allowing you to load and preview geospatial datasets. Combined with its schema inspection and sample-row display, you can quickly understand the structure and content of spatial data files.
SKILL.md
Rendered from the published skill. Quoted content, verbatim.
You are helping the user read and analyze a data file using DuckDB.
Filename given: $0
Question: ${1:-describe the data}
Step 1 — Read it
RESOLVED_PATH is $0. If the user gave a bare filename (no /), resolve it to a full path with find first.
Run a single DuckDB command that defines the read_any macro inline and reads the file.
For remote files, prepend the necessary LOAD/SECRET before the macro:
| Protocol | Prepend |
|---|---|
https:// / http:// |
LOAD httpfs; |
s3:// |
LOAD httpfs; CREATE SECRET (TYPE S3, PROVIDER credential_chain); |
gs:// / gcs:// |
LOAD httpfs; CREATE SECRET (TYPE GCS, PROVIDER credential_chain); |
az:// / azure:// / abfss:// |
LOAD httpfs; LOAD azure; CREATE SECRET (TYPE AZURE, PROVIDER credential_chain); |
For local files, no prefix
(truncated - see the full file via the links below)
File tree — 1 file
skills/read-file/SKILL.md
Let your AI agent find skills like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 56,283 agent skills by what they can do, searchable in plain language.
wish › “Load and preview a local or remote data file in multiple formats”
Give your agent the search over MCP, or paste the wish link into any chat. No install? Search from any chat →
Related skills
Convert any data file to another format—CSV, Parquet, JSON, Excel, GeoJSON, and more—in a single DuckDB command. Handles both local and remote files, with support for partitioning and compression options when needed.
Spatial handles geographic questions by combining DuckDB's spatial functions with Overture Maps, a free global dataset accessible via S3. Ask about nearby places, distances between points, or analyze your own GeoJSON, Shapefile, or GPX files—the skill manages spatial joins, containment checks, and format conversions.
Interact with Google Drive files you've explicitly selected, created, or shared with the app using the Drive v3 REST API. The skill supports reading, downloading, exporting, renaming, moving, and deleting files through curl and jq, with optional upload support via Google's Workspace CLI. Note that the connector operates under the drive.file scope and cannot browse or search your entire Drive.
Microsoft Excel lets you read and modify workbooks stored in OneDrive or SharePoint using the Microsoft Graph API. Perform operations like reading ranges, updating cells, appending table rows, and listing worksheets directly on cloud-hosted .xlsx files.
Connect to Google Sheets to read data ranges, append or update rows, create new spreadsheets, and manage tabs through the Sheets v4 REST API. OAuth scopes control access: read-only by default, with write permissions available on user opt-in. Use A1 notation for ranges and leverage valueInputOption to control how formulas and dates are parsed.
axiom-data equips AI coding assistants with production-grade database expertise for Apple ecosystem development. Navigate persistence patterns, framework selection, and data architecture decisions with confidence—avoiding common pitfalls that lead to performance issues and data integrity problems. Built for Swift 6, SwiftUI, and modern Apple Intelligence workflows.