MySQL to Magic Converter

About MySQL to Magic Converter

Convert MySQL database dumps (CREATE TABLE and INSERT statements) to Magic: The Gathering deck list format. Perfect for managing card collections, deck lists, and tournament submissions stored in MySQL databases.

Key Features

• Standard Deck Format: Generates the standard "Quantity CardName" format used by MTG platforms
• Automatic Parsing: Extracts quantity and card name from MySQL data
• Column Detection: Uses first column as quantity, second as card name
• Default Quantity: Assumes quantity of 1 if only card name is provided
• File Download: Save as .txt file for import into deck builders
• Platform Compatible: Works with MTG Arena, MTGO, TappedOut, Archidekt, and more

How to Use

1. Input MySQL Data: Paste your MySQL CREATE TABLE and INSERT statements or upload a .sql file
2. Review Output: The Magic deck list generates automatically
3. Copy or Download: Use the Copy or Download button to save your deck list
4. Import to Platform: Import the deck list into your favorite MTG platform

Expected MySQL Format

The converter expects MySQL data with at least 2 columns:

• Column 1: Quantity (number of cards)
• Column 2: Card name
• Additional columns: Ignored (can contain card type, mana cost, etc.)

Example Conversion

MySQL Input:

CREATE TABLE deck (
  quantity INT,
  card_name VARCHAR(100),
  card_type VARCHAR(50)
);

INSERT INTO deck VALUES (4, 'Lightning Bolt', 'Instant');
INSERT INTO deck VALUES (4, 'Counterspell', 'Instant');
INSERT INTO deck VALUES (3, 'Tarmogoyf', 'Creature');
INSERT INTO deck VALUES (20, 'Island', 'Basic Land');

Magic Deck Output:

// Magic: The Gathering Deck Format
// Format: Quantity CardName

4 Lightning Bolt
4 Counterspell
3 Tarmogoyf
20 Island

Common Use Cases

• Collection Management: Export card collections from MySQL to deck builder platforms
• Deck Lists: Convert stored deck lists to standard MTG format
• Tournament Submissions: Generate deck lists for tournament registration
• Inventory Systems: Export card inventory from database to trading platforms
• Deck Analysis: Import database deck data into analysis tools
• Backup & Migration: Convert MySQL deck data for backup or platform migration

Compatible Platforms

The generated deck list format is compatible with:

• MTG Arena: Import decks directly into the game client
• Magic Online (MTGO): Standard deck list format
• TappedOut: Deck building and sharing platform
• Archidekt: Visual deck builder
• Moxfield: Modern deck building platform
• Scryfall: Card search and deck building
• EDHRec: Commander deck recommendations

Deck Format Specifications

The standard Magic deck format follows these rules:

• Format: Each line contains "Quantity CardName"
• Quantity: Number of copies (1-4 for most cards, unlimited for basic lands)
• Card Name: Exact card name as printed (case-sensitive on some platforms)
• Comments: Lines starting with // are treated as comments
• Sections: Some platforms support sections like "Mainboard" and "Sideboard"

Tips for Best Results

• Exact Names: Ensure card names match official Gatherer database spellings
• Quantity Limits: Verify quantities comply with format rules (max 4 for non-basic cards)
• Set Codes: Some platforms support set codes like "4 Lightning Bolt (LEA)"
• Sideboard: Add a comment line "// Sideboard" to separate sideboard cards
• Commander: Add "1 Commander Name" at the top for Commander format

Privacy & Security

All conversions happen locally in your browser. Your MySQL data is never uploaded to any server, ensuring complete privacy and security.

FAQ

Does this tool validate Magic: The Gathering deck rules?

No. The converter only formats lines as "Quantity CardName". It does not enforce format legality, card bans, or sideboard rules.

What if my MySQL data does not have a quantity column?

If only a single column is present, the tool assumes a default quantity of 1 for each card. For precise deck sizes, include an explicit quantity column in your data.

Can I include sections like mainboard and sideboard?

Yes. After conversion, you can insert comment lines such as // Mainboard and // Sideboard to structure the deck for platforms that recognize these sections.

Will this work for non-English card names?

Yes, as long as your MySQL dump is encoded correctly (typically UTF-8). Most deck platforms accept localized card names, but check each platform's guidelines.

Is any of my deck data uploaded or stored?

No. All parsing and deck list generation happen in your browser. The tool does not send card or deck data to any remote server.