mysql-to-sqlite3 ☆
« Back to VersTracker
Description:
Transfer data from MySQL to SQLite
Type: Formula  |  Latest Version: 2.5.5@0  |  Tracked Since: Dec 20, 2025
Links: Homepage  |  GitHub  |  Docs  |  formulae.brew.sh
Stars: 258  |  Forks: 35  |  Language: Python  |  Category: Databases
Tags: database migration mysql sqlite cli python
Install: brew install mysql-to-sqlite3
About:
mysql-to-sqlite3 is a command-line utility that efficiently transfers data from MySQL databases to SQLite files. It handles schema conversion and data migration, making it ideal for local development or downsizing production databases. The tool supports large datasets via streaming and offers configurable options for data handling.
Key Features:
  • Stream-based data transfer for handling large databases
  • Automatic MySQL to SQLite data type conversion
  • Command-line interface for easy automation
  • Supports SSL connections and standard MySQL options
Use Cases:
  • Migrating production data to a lightweight local database for development and testing
  • Creating portable, serverless database snapshots for analysis
  • Downsizing large database instances to SQLite for embedded applications
Alternatives:
  • pgloader – Supports many database sources including MySQL, but is generally heavier and more complex to configure.
  • sqlite3 CLI – Can import CSV data but lacks native binary protocol support for direct MySQL migration.
Version History
Detected Version Rev Change Commit
Dec 20, 2025 9:05pm 2.5.5 0 VERSION_BUMP 3a520804
Nov 5, 2025 4:35am 0 NEW 44a9759a
« Back to VersTracker  |  Browse Packages  |  About