hardware-optimizer

Optimize macOS hardware usage for Polars and DuckDB data processing.

Updated Jan 14, 2026
One-click install
npx skills add https://github.com/omosb1-sys/epl-data-pipeline --skill hardware-optimizer
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: hardware-optimizer
Source: https://github.com/omosb1-sys/epl-data-pipeline/tree/main/epl_project/.agent/skills/hardware-optimizer
Command: npx skills add https://github.com/omosb1-sys/epl-data-pipeline --skill hardware-optimizer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

이 스킬은 8GB RAM Mac 환경에서 대용량 데이터 처리의 성능 저하와 메모리 관리 이슈를 해결합니다. 최소 하드웨어로도 데이터 파이프라인을 원활히 실행하도록 최적화된 지침을 제공합니다.

Core Features & Use Cases

  • 고성능 데이터 엔진 구성: Polars 와 DuckDB의 조합으로 데이터 로딩과 변환 속도를 대폭 향상시킵니다.
  • 메모리 관리 최적화: 메모리 매핑과 제로 복사 로딩으로 RAM 사용을 최소화합니다.
  • 가속화 기술 활용: Mac의 GPU(MPS) 및 효율적 병렬 처리로 대용량 데이터 작업을 빠르게 수행합니다.
  • Use Case: 8GB RAM Mac에서 로그 파일을 실시간으로 집계하고 요약하는 파이프라인을 구축하는 사례를 제시합니다.

Quick Start

  • 예시 1: 대용량 CSV/Parquet 데이터를 로드하고 Polars+DuckDB 파이프라인으로 처리하도록 환경을 설정합니다.
  • 예시 2: Mac 8GB RAM에서 메모리 매핑과 제로 카피 로딩을 활용한 데이터 변환을 실행합니다.
  • 예시 명령: python -m hardware_optimizer.examples.run_mac8gb --config config.yaml

Frequently Asked Questions about hardware-optimizer

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

FAQPage Schema
How do I optimize large data processing on an 8GB RAM Mac without running out of memory?

To optimize large data processing on an 8GB RAM Mac, use memory mapping and zero-copy loading with Polars and DuckDB. This approach minimizes RAM usage during data transformation and enables efficient handling of large datasets.

How does memory mapping work with Polars and DuckDB for zero-copy data loading?

Memory mapping with Polars and DuckDB enables zero-copy data loading by referencing parquet files directly from disk. This bypasses loading entire datasets into RAM, significantly reducing memory overhead during data transformation.

Can I use Mac GPU MPS acceleration for data processing pipelines?

Yes, you can use Mac GPU MPS acceleration for data processing pipelines. This skill provides runtime tuning steps to leverage MPS for faster execution of large dataset operations alongside efficient parallel processing.

What is the best way to set up a real-time log aggregation pipeline on macOS with limited RAM?

The best way to set up a real-time log aggregation pipeline on macOS with limited RAM is combining Polars and DuckDB. Using parquet-first storage and memory-mapped files ensures fast aggregation and summary without exceeding memory limits.

Does DuckDB work with parquet files for memory-efficient data storage on Mac?

DuckDB works seamlessly with parquet files for memory-efficient data storage on Mac. Adopting a parquet-first storage approach allows the engine to query compressed data directly, minimizing RAM requirements during large dataset processing.

Why does my macOS data pipeline crash when loading large CSV files?

Your macOS data pipeline crashes when loading large CSV files because the dataset exceeds available RAM. Switching to parquet files and applying memory-mapped loading with Polars prevents crashes by avoiding full memory consumption.