onyx-data-migration

Name: onyx-data-migration
Availability: InStock
Author: alabasi2025

Automate data migration between Onyx Oracle and external sources using Python.

Updated Aug 23, 2026

Search Tags:#ETL #Excel #Oracle #CSV #data-validation #data-migration #Onyx

Ready to run

npx skills add https://github.com/alabasi2025/manus-skills-library --skill onyx-data-migration

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: onyx-data-migration
Source: https://github.com/alabasi2025/manus-skills-library/tree/main/onyx-erp/onyx-data-migration
Command: npx skills add https://github.com/alabasi2025/manus-skills-library --skill onyx-data-migration

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, requests, and includes scripts (resource) and references (resource) components.

What problem does it solve?

هذه المهارة تقوم بأتمتة نقل البيانات بين نظام Onyx Oracle وأنظمة خارجية، مما يقلل الجهد اليدوي ويضمن صحة البيانات أثناء الاستيراد، التصدير والمزامنة.

Core Features & Use Cases

استيراد البيانات من ملفات Excel/CSV إلى Oracle أو جداول Onyx
تصدير البيانات من Oracle إلى Excel/CSV مع تحويلات وتصفية
مزامنة ثنائية بين Oracle و PostgreSQL مع التحقق من التطابق
التحقق من صحة البيانات باستخدام ملفات التعيين وقواعد التحقق
سيناريوهات استخدام عملية: نقل بيانات الحسابات من ملف Excel إلى قاعدة البيانات مع تقارير التحقق

Quick Start

قم باستيراد البيانات من الملف data.xlsx إلى الجدول ACCOUNTS باستخدام ملف التعيين mapping.json.

Frequently Asked Questions about onyx-data-migration

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

FAQPage Schema

How do I automate Excel data migration to Oracle tables?▼

You can automate Excel data migration to Oracle using Python with pandas to parse files and MCP endpoints to execute Oracle operations. This skill imports Excel/CSV data, applies mapping files, and validates records during the transfer process.

What is the best way to validate data during ETL processes between CSV and Oracle?▼

Data validation during ETL is handled using mapping files and predefined validation rules. The skill checks imported CSV or Excel data against these rules before loading it into Oracle, generating validation reports to ensure data accuracy.

How does cross-system data synchronization work between Oracle and PostgreSQL?▼

Cross-system synchronization between Oracle and PostgreSQL works by extracting data via MCP endpoints and using pandas to verify data consistency. It performs bidirectional syncs and checks for data alignment between the two databases.

Do I need Python and pandas to export Oracle data to CSV?▼

Yes, you need Python and pandas to export Oracle data to CSV. The skill relies on pandas for data manipulation and the requests library to communicate with MCP endpoints for retrieving Oracle records before writing them to CSV.

Can I filter and transform Oracle data before exporting it to Excel?▼

Yes, you can filter and transform Oracle data before exporting to Excel. The skill uses pandas to apply required data transformations and filtering logic on the dataset retrieved from Oracle before generating the final Excel file.