MySQL to SQLite online converter

Online tool that converts SQL DDL code from MySQL to SQLite format.

Click here to open: https://ww9.github.io/mysql2sqlite/

Why?

I needed to convert SQL database and table creation from MySQL to SQLite and couldn't find an online solution. So I wrote one.

Updates

• Update 2024-09-24: First contributor PR merged! Thank you! I'll try once again to mantain this repo despite busy life. Improve while keeping it in a simple static single HTML file. If you have suggestions please submit an issue.
• Update 2022-01-01: I'll be mantaining this repo!

Todo

• Create tests and make sure they fix current Issues.
• Create sample SQL for testing.
• Implement options like don't remove comments, custom escaping.

Problem converting SQL file?

This was tested with only the MySQL SQL file I needed to convert. If the tool doesn't convert your SQL file correctly please create an issue. Preferably include the SQL file you're trying to convert or some sample code that's not being converted correctly.

License

The Unlicense, Public Domain. As free as it gets.