MySQL to TiDB DDL Assessment

Assess user-provided SQL files or directories offline and produce a compatibility report in English, Chinese, or Japanese with located findings, uncertainty, coverage gaps, and remediation suggestions. Use the bundled offline checker to obtain reproducible structural evidence, then explain business implications. Do not connect to databases, execute SQL, or rewrite inputs by default.

Collect inputs

• Establish the file scope, source MySQL server version, and target. The implemented syntax subset covers MySQL 5.7, 8.0, and 8.4. Prefer user-provided version evidence, then the dump server-version header. Continue with explicit limitations when evidence is missing or conflicting.
• Identify self-managed TiDB 8.5 or the TiDB Cloud plan. Do not ask the customer for a cloud provider or region. Both are optional; when either is omitted, assess the minimum capability set across providers and regions for that plan. If any applicable provider or region is documented as incompatible, report the feature as incompatible and explain the conservative assumption. Use volunteered provider and region values only for an explicit deployment-specific assessment. Do not invent missing values. If the user has not selected a target, ask; do not treat the script's default as the user's choice.
• Prepare a target configuration using target-profiles.md. Cloud capabilities change over time. Verify applicable official documentation; retain unknown values when verification is unavailable.
• Establish whether the export includes routines, events, and triggers. Pass --export-scope only when the user confirms completeness or the export command provides evidence. Finding one trigger does not establish that all triggers were exported.
• Use --ordered only when the execution order of multiple files is known. Default directory sorting makes output stable; it does not establish import order.
• Select the report language from the user's preference: en (English), zh (Simplified Chinese), or ja (Japanese). Use English when no preference is provided. Keep the narrative explanation in the selected language.

Run the checker

Requires Python 3.10+ and uses only the standard library. Paths below are relative to this skill directory; substitute its actual path when invoking from another directory.