SQLite to MariaDB Schema Converter

Paste your SQLite CREATE TABLE statements below. The tool will convert data types, handle AUTOINCREMENT, and ensure MariaDB compatibility.

SQLite Schema (Input)

MariaDB Schema (Output)

Conversion Reference

Data Type Conversions:

INTEGER → INT
TEXT → TEXT
REAL → DOUBLE
BLOB → BLOB
NUMERIC → DECIMAL

Syntax Conversions:

AUTOINCREMENT → AUTO_INCREMENT
Removes SQLite-specific constraints
Adds ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
Handles backtick quoting for reserved words