{"repo":"techouse/sqlite3-to-mysql","free":true,"listed":false,"github":"https://github.com/techouse/sqlite3-to-mysql","clone":"git clone https://github.com/techouse/sqlite3-to-mysql.git","description":"Transfer data from SQLite to MySQL","language":"Python","stars":470,"topics":["mysql","tool","transfer-data","python","command-line","sqlite","mariadb"],"license":"MIT","category":"databases-storage","readme_excerpt":"SQLite3 to MySQL A Python CLI for transferring SQLite 3 schema and data to MySQL or MariaDB. sqlite3mysql reads the source schema from SQLite, creates equivalent MySQL/MariaDB tables, indexes, foreign keys, and views where possible, then transfers table data into the target database. Prerequisites - Python 3.9 or newer, unless you use the Docker image. - A readable SQLite 3 database file. - A reachable MySQL or MariaDB server. - A MySQL user that can connect, create the target database when it does not exist, create tables and views, insert data, add indexes, and add foreign keys. 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, JSON, FULLTEXT, or authentication 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/sqlite3-to-mysql/ for users who want Codex or another compatible agent to help prepare a safe sqlite3mysql 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","default_branch":null,"files":null,"tree":[],"storefront":"/r/techouse","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/techouse/sqlite3-to-mysql/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."}