>_ tools --db

SQLite ⇄ MySQL Query Converter

Paste SQLite DDL/DML and get MySQL - or the reverse. AUTOINCREMENT → AUTO_INCREMENT, type affinity mapping, quoting dialect, the WordPress-SQLite leading-comma style, COLLATE/STRICT handling, and INSERT OR → INSERT IGNORE. Everything runs in your browser; nothing is uploaded.

DIRECTION

INPUT

OUTPUT

0 chars

TRANSFER NOTES

ACTIONS

Honest scope: this is a syntax converter - it maps types, AUTOINCREMENT, quoting and the common dialect differences. It does not rewrite stored data, migrate actual rows into a live MySQL server, or resolve every vendor edge case; test the output against your target database before importing. The MySQL ⇄ SQLite authority here pairs with the WordPress-SQLite production articles.
no server · everything computed in your browser · one HTML file
wp-config.php Generator Set up the SQLite database constants the queries target. .htaccess Generator Deny web access to the SQLite database folder. Debug Log Analyzer When the import runs, read what MySQL disliked. JSON Formatter Clean up serialized exports before they go in.

>_ FAQ

Does it convert SQLite AUTOINCREMENT?

Yes - SQLite AUTOINCREMENT becomes MySQL AUTO_INCREMENT (with NOT NULL added, since MySQL requires it on an auto-increment key), and back.

Does it handle the WordPress-SQLite dialect?

Yes - it normalizes the WordPress-SQLite leading-comma style, maps type affinity (INTEGER to INT, preserves varchar/longtext), strips COLLATE/STRICT for MySQL, and converts INSERT OR REPLACE / OR IGNORE.

Does it migrate live data?

No - it converts query syntax, not rows. Test the output against your target database before importing; it does not connect to any server.