⚡
数智荟AI能源
@OpenClaw
🌐中文
Energy & Mining⭐ Featured

Coal Mine Data Unifier

煤矿数据孤岛终结者

Automatically integrate data from multiple ERP and database systems into a unified format - ending coal mine data silos.

煤炭数据整合数字化转型煤矿信息化coaldata-integration
Install Command
npm install @openclawhub/industry-coal-data-unifier
Version
0.1.0
Author
OpenClawHub
Updated
Sun Apr 12 2026 00:00:00 GMT+0000 (Coordinated Universal Time)

Core Value

Solve the **multi-system ERP and database coexistence data silo problem** for coal mining enterprises. Automatically extract, transform, and integrate data, outputting standardized unified format data.

---

Corresponding Pain Point

> **Source**: During informatization construction, coal enterprises have not established unified data standards at the group level. Multiple ERP system versions and various database types coexist, with complex data integration and nesting between application systems.

>

> **Skill Potential**: ⭐⭐⭐

---

Core Features

1. Multi-Source Connectors

  • Supported ERPs: SAP, Oracle, Kingdee (金蝶), Yonyou (用友)
  • Supported databases: MySQL, PostgreSQL, SQL Server, MongoDB
  • Supported file formats: Excel, CSV, JSON, XML

    • 2. Smart Field Mapping

  • Auto-recognize fields with same meaning (e.g., "mine number" = "work area number" = "mine ID")
  • Automatically remember mapping relationships after human confirmation
  • Support custom mapping rules

    • 3. Data Cleaning Engine

  • Auto-remove duplicate data
  • Standardize date, number, and address formats
  • Anomaly detection and tagging

    • 4. Unified Output

  • Output formats: Standardized JSON / Excel reports / API
  • Scheduled sync: Daily/weekly/real-time incremental
  • Data quality report: Auto-generated completeness and accuracy scores

    • 5. Visual Monitoring

  • Real-time sync status dashboard
  • Anomaly record alerts (Feishu/email)
  • Historical traceability: Any data can trace its source

    • ---

    Technical Path

  • **Language**: TypeScript + Node.js
  • **Core Libraries**: Prisma (database ORM), Apache POI (Excel), pdf-parse
  • **Deployment**: Vercel Serverless Functions or Docker
  • **Config**: YAML configuration file for multi-source management

    • ---

    Target Users

    | User | Scenario |

    |------|----------|

    | IT Director | Solving the dilemma of leaders needing data but systems not connecting |

    | Data Analyst | No more manual merging of dozens of Excel files |

    | IT Ops | Reduced data coordination communication work |

    ---

    Business Model

  • **Free**: 2 data sources, daily sync once
  • **Pro** (¥99/month): Unlimited data sources, real-time sync, data quality reports
  • **Enterprise** (¥399/month): Private deployment, dedicated support
    • ← Back to Skills