skills.rest
alabasi2025
alabasi2025COMMUNITY
Explore all skills by this author →
GitHub

onyx-data-migration

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
One-click install
npx skills add https://github.com/alabasi2025/manus-skills-library --skill onyx-data-migration
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
rodrigoBermejorodrigoBermejo

Data Processing - pandas, numpy, Data Analysis

Automate data processing and analysis in Python with pandas and numpy.

Community
Intermediate
Wesley1600Wesley1600

data-analysis

Analyze CSV, JSON, and Parquet datasets with exploratory analysis and visualizations.

Community
Advanced
oci-ai-architectsoci-ai-architects
1

mcp-architecture

Integrate Model Context Protocol with Oracle Cloud services for agent-based data workflows.

Official
Advanced
FalkorDBFalkorDB
22

Migrate SQL to FalkorDB

Migrate relational SQL data from PostgreSQL, MySQL, and BigQuery into FalkorDB graph databases.

Official
Advanced