一键在 Manus 中运行任何 Skill

magento2-db-sql-csv

星标4

分支1

更新时间2026年3月10日 16:22

Magento 2 best practices for database queries and CSV exports. Use when writing SQL queries, fetching data from DB, or exporting data to CSV files. Triggers on tasks involving raw SQL, SELECT queries, JOIN operations, CSV generation, or file export adapters. DO NOT use for frontend, caching, or search topics.

安装

用 Codex 或 Claude 帮你安装复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。

在 Manus 中运行

来源

tuanhaviet22

tuanhaviet22/magento-skills

打开 GitHub 仓库查看创作者相关仓库

下载

在 Manus 中运行

Magento 2 — DB Query & CSV Export Best Practices

Two mandatory rules for Magento 2 projects.

Rules

#	Rule	Severity
1	Never write raw SQL — always use the Magento query builder	CRITICAL
2	Always use/create a CSV adapter class for file exports	REQUIRED

Rule 1 — No Raw SQL, Use Query Builder

Read: rules/no-raw-sql.md

Rule 2 — CSV Export via Adapter

Read: rules/csv-adapter.md

同仓库更多 Skills

同仓库

magento2-warden

tuanhaviet22/magento-skills

Warden environment operations for Magento 2: database queries, Magento CLI commands, DB import/export, environment management, and shell access. Use when user asks to "run warden", "check database", "warden db connect", "run magento command", "import db", "export db", "warden shell", or any task involving the Warden local development environment. Do NOT use for code generation, frontend, or non-Warden environments.

2026-03-114

magento2-backend-toolkit

tuanhaviet22/magento-skills

Scaffold Magento 2 backend modules, system.xml admin configs, widgets with parameters and templates, plugins/events/observers, transactional email with trigger setup, and Hyva-compatible .phtml templates with ViewModels. Use when user asks to "create module", "scaffold module", "generate plugin", "add system config", "create widget", "setup email template", "create hyva template", or any Magento 2 backend code generation. Do NOT use for frontend-only tasks, CSS/JS theming, or Magento 1.x.

2026-03-114

magento2-custom-logger

tuanhaviet22/magento-skills

Custom per-class log files in Magento 2 using di.xml virtual types — no PHP class needed. Use when the user says "custom logger", "dedicated log file", "separate log file", "log to my own file", "virtual type logger", or wants a Console Command / Service to write to a specific var/log/ path. DO NOT use for general Magento logging via \Psr\Log\LoggerInterface already injected by the framework, or for frontend/JS logging.

2026-03-054

magento2-db-performance

tuanhaviet22/magento-skills

Database query optimization patterns for Magento 2 — bulk operations, EAV manipulation, CSV multiselect replacement, and custom loggers. Use when writing migration scripts, Console Commands with DB loops, bulk update operations, or any code where a loop contains DB queries. DO NOT use for frontend, caching, indexing, or search performance topics.

2026-03-054

一键运行任何 Skill

name	magento2-db-sql-csv
description	Magento 2 best practices for database queries and CSV exports. Use when writing SQL queries, fetching data from DB, or exporting data to CSV files. Triggers on tasks involving raw SQL, SELECT queries, JOIN operations, CSV generation, or file export adapters. DO NOT use for frontend, caching, or search topics.
license	MIT
metadata	{"author":"community","version":"1.0.0"}

name	magento2-db-sql-csv
description	Magento 2 best practices for database queries and CSV exports. Use when writing SQL queries, fetching data from DB, or exporting data to CSV files. Triggers on tasks involving raw SQL, SELECT queries, JOIN operations, CSV generation, or file export adapters. DO NOT use for frontend, caching, or search topics.
license	MIT
metadata	{"author":"community","version":"1.0.0"}