skills.rest
ninyawee
ninyaweeCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

DBF Data Analysis

Read, convert, and query Thai DBF accounting data with DuckDB.

Updated Aug 23, 2026
Search Tags:#data analysis#parquet#duckdb#dbf#thai accounting#legacy data#roonpoo
One-click install
npx skills add https://github.com/ninyawee/dotfiles --skill dbf-data-analysis
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: DBF Data Analysis
Source: https://github.com/ninyawee/dotfiles/tree/main/dot_claude/saved_skills/dbf-analysis
Command: npx skills add https://github.com/ninyawee/dotfiles --skill dbf-data-analysis

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses the challenge of accessing and analyzing data locked in legacy Thai accounting systems that use DBF files, enabling modern data workflows.

Core Features & Use Cases

  • Read DBF Files: Directly read DBF files, correctly handling Thai TIS-620/CP874 encoding.
  • Convert to Parquet: Transform DBF data into efficient Parquet format for faster querying.
  • Query with DuckDB: Perform SQL analytics on the converted Parquet data.
  • Use Case: Analyze historical sales transactions from a Thai company's old accounting system by converting DBF files to Parquet and querying them with SQL.

Quick Start

Use the DBF Data Analysis skill to convert all DBF files in the '/path/to/data' directory to Parquet format.

Frequently Asked Questions about DBF Data Analysis

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

FAQPage Schema
How do I read legacy Thai DBF accounting files with TIS-620 encoding?▼

To read legacy Thai DBF accounting files, you must correctly handle the TIS-620 or CP874 character encoding to prevent text corruption. This process converts DBF databases into Parquet format, enabling modern data access to historical financial records.

What is the best way to query large DBF files using SQL?▼

The best way to query large DBF files using SQL is to first convert them into Parquet format. This transformation allows you to use DuckDB for efficient SQL-based analytics on the converted data, bypassing the limitations of legacy DBF databases.

Can I convert DBF data to Parquet for faster querying?▼

Yes, you can convert DBF data to Parquet for faster querying. Transforming legacy DBF files into the efficient Parquet format optimizes the dataset, allowing DuckDB to perform high-speed SQL analytics on your historical financial records.

Does DuckDB support analyzing historical sales transactions from DBF databases?▼

DuckDB supports analyzing historical sales transactions by querying data converted from DBF databases. After transforming the legacy Thai accounting files into Parquet format, you can run SQL analytics directly on the dataset using DuckDB.

How do I convert all DBF files in a directory to Parquet format?▼

To convert all DBF files in a directory to Parquet format, you target the specified data path for batch processing. This workflow reads the legacy files, handles the Thai encoding, and outputs efficient Parquet files for modern analysis.

Related Skills

Explore More Finance & Accounting Skills→
aiunlocked1412aiunlocked1412
14

accountant-pro

Categorize Thai SME transactions and generate tax checklists as markdown reports.

Community
Intermediate
TeiNamTeiNam
12

duckdb-patterns

Perform in-memory analytics on CSV, Parquet, and JSON files with DuckDB.

Community
Advanced
OpenSenseNovaOpenSenseNova
4.9k

sn-da-large-file-analysis

Convert large Excel datasets to Parquet using streaming techniques.

Official
Advanced
googlegoogle
17.1k

bigquery-bigframes

Analyze BigQuery data with a pandas-style DataFrame API.

Official
Intermediate