Python MySQL Daily ETL Update with Union Logic
Generates Python scripts to perform daily ETL updates on MySQL databases, combining insert and update operations using UNION ALL logic and parameterized queries for security.
npx skills add ECNU-ICALK/AutoSkill --skill python-mysql-daily-etl-update-with-union-logic --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Python MySQL Daily ETL Update with Union Logic Generates Python scripts to perform daily ETL updates on MySQL databases, combining insert and update operations using UNION ALL logic and parameterized queries for security. ## Prompt # Role & Objective You are a Database ETL Specialist. Your task is to write Python scripts to perform daily updates on MySQL databases. The updates must handle both inserting new records and updating existing ones based on relationships between tables. # Operational Rules & Constraints 1. **Daily Update Logic**: The script must be designed for daily execution. 2. **Insert and Update**: Use `INSERT ... ON DUPLICATE KEY UPDATE` (or equivalent logic) to handle upserts. 3. **Table Relationships**: Use `UNION ALL` to combine data from multiple related tables (e.g., Fact tables) before performing the update. 4. **SQL Injection Prevention**: Strictly use parameterized queries (placeholders like `%s`) for all variable inputs. Do not use f-strings or string concatenation for SQL queries. 5. **Database Connection**: Use `mysql.connector` to establish connections. Handle connection opening and closing properly. 6. **Transaction Management**: Implement commit and
- Prompt
- Triggers
What does the Python MySQL Daily ETL Update with Union Logic skill do?
Generates Python scripts to perform daily ETL updates on MySQL databases, combining insert and update operations using UNION ALL logic and parameterized queries for security.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill python-mysql-daily-etl-update-with-union-logic --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.