Metin2 TXT to SQL Converter
Convert Metin2 item_proto.txt and mob_proto.txt to SQL INSERT statements (and back) instantly in your browser. No download, no signup.
How to Use Metin2 TXT to SQL Converter
- Select the conversion direction: "TXT → SQL" to convert a proto text file to SQL INSERT statements, or "SQL → TXT" to do the reverse.
- Choose your proto type: "Item Proto" for item_proto.txt or "Mob Proto" for mob_proto.txt — this determines the column mapping.
- Paste the content of your file into the input textarea, or click "Upload File" to load a .txt or .sql file directly.
- Set the SQL table name if different from the default (item_proto or mob_proto).
- Click "Convert" to process the data. A preview table shows the first 10 rows so you can verify the mapping is correct.
- Click "Copy SQL" or "Download .sql" (respectively "Copy TXT" or "Download .txt") to get your converted output.
About Metin2 TXT to SQL Converter
The Metin2 TXT to SQL Converter is the fastest way to migrate your server's proto files between formats. Whether you're moving from a legacy TXT-based server to a modern MySQL setup, or you need to export your database back to a flat file for patching, this tool handles both directions instantly — entirely in your browser with no data sent to any server.
Why you need this tool: Metin2 private server admins constantly deal with two incompatible formats for item_proto and mob_proto. Older server releases (pre-2015 era) store proto data as tab-separated .txt files. Modern servers store the same data directly in MySQL tables. When you download a new item pack, upgrade your server version, or merge content from another server, you almost always need to convert between these formats — and raw SQL editors or manual Excel work is error-prone and slow.
How the converter works: Paste your tab-separated item_proto.txt or mob_proto.txt content (or upload the file directly), select whether it's an Item Proto or Mob Proto, and click Convert. The tool maps each tab-separated column to the correct SQL field name, generates properly escaped INSERT INTO statements, and lets you copy or download the result as a .sql file. The reverse direction parses SQL INSERT dumps and outputs clean tab-separated TXT.
Supported formats: item_proto.txt (all columns: vnum, name, locale_name, type, subtype, weight, size, antiflag, flag, wearflag, immuneflag, gold, shop_buy_price, limittypes/values, applytypes/values, value0–5, socket0–5, refined_vnum, refine_set, magic_pct, socket_pct, addon_type), mob_proto.txt (all columns including stats, resistances, immunities, skills, and special ability thresholds).
Safe and private: All conversion happens locally in your browser using JavaScript. Your proto data never leaves your machine. This is especially important for private server admins who want to keep their item balance and custom content private.
Common Use Cases
Frequently Asked Questions
What is item_proto.txt in Metin2?
item_proto.txt is the master item definition file for a Metin2 server. It is a tab-separated text file where each row defines one item with its ID (vnum), name, type, subtype, level requirements, passive bonuses, upgrade chain, prices, and other attributes. Modern servers store this data in a MySQL table instead.
What is mob_proto.txt in Metin2?
mob_proto.txt defines every monster and NPC in the game. Each row contains the mob's ID, name, type, level, HP, damage, defense, EXP, gold drops, AI flags, elemental resistances, immune flags, skills, and special ability thresholds.
Does this tool handle the binary item_proto.bin / mob_proto.bin client files?
No — this tool converts between the server-side TXT and SQL formats only. The binary .bin files used by the game client require TEA encryption and LZO compression, which is beyond the scope of this converter. Use a dedicated binary packer tool for client-side files.
Why does my converted SQL have "NULL" for some fields?
Some columns in item_proto.txt are optional or left blank in older file versions. The converter maps empty tab-separated fields to NULL in the SQL output, which is the correct MySQL behavior for optional columns.
Can I convert a file with custom columns?
The tool uses the standard official Metin2 column layout. If your server has added custom columns, they will appear as extra unrecognized fields. The converter will still process all standard columns correctly — custom columns at the end will be included as-is.
Related Metin2 Tools
Metin2 Drop Table Calculator
Paste your mob_drop_item.txt group block and instantly see the full drop table with real drop percentages and avg kills per item at any player level. Free, no signup.
Metin2 Item Proto Editor
Edit Metin2 item_proto.txt in your browser with a full spreadsheet interface, smart type/subtype dropdowns, wear slot checkboxes, and export to TXT or SQL. No download needed.
Metin2 Mob Proto Editor
Edit Metin2 mob_proto.txt online with a full table editor. Smart dropdowns for type, rank, battle type, resist sliders, immune flags — export to TXT or SQL instantly.