SQLite to MySQL Converter - Migrate Database Schema

Convert SQLite databases to MySQL format. Transforms data types, syntax, and generates compatible SQL. Browser-based migration tool.

Load Database

Drop SQLite file here

Load a SQLite database to convert to MySQL

Security: Only process files from sources you trust. All processing happens locally in your browser.

CREATE TABLE statements, INSERT data, indexes, and triggers. Data types are mapped to MySQL equivalents and syntax is adjusted.

INTEGER becomes INT, TEXT becomes TEXT or VARCHAR, REAL becomes DOUBLE, BLOB stays BLOB. AUTOINCREMENT becomes AUTO_INCREMENT.

No. All conversion happens locally in your browser using SQL.js. Your data never leaves your device.

Foreign key constraints are preserved and converted to MySQL syntax with proper ENGINE=InnoDB for referential integrity.

SQLite stores booleans as 0/1 integers. These are converted to TINYINT(1) in MySQL with the same values.

Date and time strings are preserved. You may need to ensure MySQL's sql_mode accepts the format.

Yes. After loading, choose which tables to include in the MySQL export.

Views are extracted but may need manual adjustment for function differences between SQLite and MySQL.

SQLite's implicit ROWID is replaced with an explicit AUTO_INCREMENT primary key if no integer primary key exists.

Browser memory limits apply. For very large databases, consider using command-line tools.