{"repo":"techouse/mysql-to-sqlite3","free":true,"listed":false,"github":"https://github.com/techouse/mysql-to-sqlite3","clone":"git clone https://github.com/techouse/mysql-to-sqlite3.git","description":"Transfer data from MySQL to SQLite","language":"Python","stars":273,"topics":["mysql","transfer-data","sqlite","python","tool","command-line","mariadb"],"license":"MIT","category":"databases-storage","readme_excerpt":"MySQL to SQLite3 A Python CLI for transferring MySQL or MariaDB schema and data to a SQLite 3 database file. mysql2sqlite reads the source schema from MySQL/MariaDB, creates equivalent SQLite tables, indexes, views, and foreign keys where possible, then transfers table data into the SQLite file. Prerequisites - Python 3.9 or newer, unless you use the Docker image. - A reachable MySQL or MariaDB server. - A MySQL user that can read the source database and its metadata in information schema . - A writable destination path for the SQLite database file. See the GitHub Actions CI matrix for the current MySQL and MariaDB versions tested by the project. Very old server versions are more likely to differ in type, default-value, authentication, or metadata behavior. Installation Install from PyPI: On macOS, you can also install with Homebrew: Or run the published Docker image: Agent skill This repo includes an optional agent skill at skills/mysql-to-sqlite3/ for users who want Codex or another compatible agent to help prepare a safe mysql2sqlite transfer command. The skill is user-facing: it focuses on migration planning, CLI recipes, password-safe defaults, and MySQL/MariaDB caveats. Quick start Use -p / --prompt-mysql-password for interactive password entry. This avoids putting the password in shell history or process listings. Short options are equivalent: For automation, --mysql-password is available, but prefer a secret manager or environment-expanded value rather than typing the","default_branch":null,"files":null,"tree":[],"storefront":"/r/techouse","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/techouse/mysql-to-sqlite3/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}