# Install sqlite3-to-mysql with Homebrew, Nix

Transfer data from SQLite to MySQL. Version 2.6.0 via Homebrew; verified 2026-06-15.

## Install

```sh
sudo av install brew:sqlite3-to-mysql
```

Additional install commands:

### macOS

- Homebrew (100%):

```sh
brew install sqlite3-to-mysql
```

  Evidence: local Homebrew formula metadata

### Linux

- Nix (92%):

```sh
nix profile install nixpkgs#sqlite3-to-mysql
```

  Evidence: nixpkgs package indexes: pkgs/by-name/sq/sqlite3-to-mysql/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1

## Package facts

- **Package key:** brew:sqlite3-to-mysql
- **Package manager:** Homebrew
- **Package manager page:** <https://formulae.brew.sh/formula/sqlite3-to-mysql>
- **Version:** 2.6.0
- **Source summary:** Transfer data from SQLite to MySQL
- **Homepage:** <https://techouse.github.io/sqlite3-to-mysql/>
- **Repository:** <https://github.com/techouse/sqlite3-to-mysql>
- **Upstream docs:** <https://techouse.github.io/sqlite3-to-mysql>
- **License:** MIT
- **Source archive:** <https://files.pythonhosted.org/packages/dd/a3/a39130ba3bbd9ad22ca794fd5ef93b20492474c16879ced76c6b05e60986/sqlite3_to_mysql-2.6.0.tar.gz>
- **Last updated:** 2026-06-15T10:21:20-04:00
- **Generated:** 2026-07-08T18:08:21+00:00

## Executables

- sqlite3mysql (cli)
- sqlite3mysql (alias)

## Dependencies

- python@3.14

## Uses from macOS

- sqlite

## Install behavior

- Post-install hook: not defined
- Bottle: available on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux

## Freshness

- Page generated: 2026-07-08
- Package-manager version: 2.6.0
- Package-manager updated: 2026-06-15
- Local data: ok
- Upstream repository: https://techouse.github.io/sqlite3-to-mysql/
- info: Release/tag comparison is only available for GitHub repositories.
## Project history and usage

sqlite3-to-mysql is a Python CLI for transferring schema and data from SQLite 3 databases into MySQL or MariaDB. It sits in the practical migration-tool niche rather than the embedded-database niche.

### Project history

The official documentation describes SQLite3 to MySQL as a simple Python tool to transfer data from SQLite 3 to MySQL. The repository README gives the CLI behavior in more detail: `sqlite3mysql` reads the SQLite schema, creates equivalent MySQL or MariaDB structures where possible, and transfers table data.

The project is distributed as a Python package, a Homebrew formula, and a Docker image according to its official README and docs. GitHub release metadata shows continuing maintenance through the 2.x series.

### Adoption history

The official README documents installation from PyPI and Homebrew, plus a container image from GitHub Container Registry. The input also lists a Nix package, showing packaging beyond Python's package index.

### How it is used

Users run `sqlite3mysql` with a source SQLite file, target MySQL database, MySQL user, host, and password prompt. Common recipes include schema-only transfer, loading into existing MySQL tables, transferring selected tables, refreshing target tables, using Unix sockets, SSL certificates, Docker, and chunk/log tuning.

### Why package nerds care

Package nerds care because sqlite3-to-mysql turns a one-off migration chore into an installable CLI with explicit packaging routes. It is useful when a project has outgrown a local SQLite file or needs to move data into MySQL/MariaDB without writing bespoke export scripts.

### Timeline

- 2023: GitHub release metadata shows the 2.0.0 line published in October 2023.
- 2024: The 2.3.x release line appears in GitHub release metadata.
- 2026: GitHub release metadata shows 2.6.0 with added MySQL SSL certificate options.

### Related projects

- The tool bridges SQLite 3 source databases with MySQL and MariaDB targets.
- It complements SQLite CLI export workflows when users want direct MySQL/MariaDB DDL and data loading.

### Sources

- <https://github.com/techouse/sqlite3-to-mysql - official repository README.>
- <https://github.com/techouse/sqlite3-to-mysql/releases - official GitHub release metadata.>
- <https://techouse.github.io/sqlite3-to-mysql/ - official documentation overview.>
- source_facts.package-manager - package-manager availability supplied in input.


## Security Notes

broad file, network, media, or database tool signal.

- **Geiger risk:** blue / medium
- broad file, network, media, or database tool signal

## Source Database Details

- **Source Database:** Homebrew formula API
- **Tap:** homebrew/core
- **Full Name:** sqlite3-to-mysql
- **Version Scheme:** 0
- **Revision:** 0
- **Head Version:** HEAD
- **Bottle Stable Root URL:** <https://ghcr.io/v2/homebrew/core>
- **Deprecated:** no
- **Disabled:** no
- **Keg Only:** no
- **URL Keys:** head, stable

## Other Package-Manager Records

- Nix - sqlite3-to-mysql: normalized package name match | nixpkgs package indexes: pkgs/by-name/sq/sqlite3-to-mysql/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1


## Related links

- [Source-control packages](https://www.automicvault.com/pkg/source-control-tools/) - Belongs to a source-control command family.
- [Secret-risk packages](https://www.automicvault.com/pkg/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals.
- [Terminal utility packages](https://www.automicvault.com/pkg/terminal-utilities/) - Matched terminal and command-line workflow metadata.
- [Text processing packages](https://www.automicvault.com/pkg/text-processing-tools/) - Matched text, document, or structured-data processing metadata.
- [python@3.14](https://www.automicvault.com/pkg/brew/python-3-14/) - Runtime dependency declared by Homebrew.
- [pgloader](https://www.automicvault.com/pkg/brew/pgloader/) - Shares av.db curated category or tags: cli, data, database, database-migration, migration.
- [lazysql](https://www.automicvault.com/pkg/brew/lazysql/) - Shares av.db curated category or tags: cli, data, database, mysql, sqlite.
- [pgroll](https://www.automicvault.com/pkg/brew/pgroll/) - Shares av.db curated category or tags: cli, data, database, migration.
- [whodb-cli](https://www.automicvault.com/pkg/brew/whodb-cli/) - Shares av.db curated category or tags: cli, data, database, mysql, sqlite.
- [automysqlbackup](https://www.automicvault.com/pkg/brew/automysqlbackup/) - Shares av.db curated category or tags: cli, data, database, mysql.
- [dumpling](https://www.automicvault.com/pkg/brew/dumpling/) - Shares av.db curated category or tags: cli, data, database, mysql.
- [kitchen-sync](https://www.automicvault.com/pkg/brew/kitchen-sync/) - Shares av.db curated category or tags: cli, data, database, mysql.
- [mysql](https://www.automicvault.com/pkg/brew/mysql/) - Shares av.db curated category or tags: cli, data, database, mysql.
- [mysql-to-sqlite3](https://www.automicvault.com/pkg/brew/mysql-to-sqlite3/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, database, database-migration, migration.
- [sqlite-utils](https://www.automicvault.com/pkg/brew/sqlite-utils/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, database, python, python-3-14.

## Combined YAML source

View the package source record on GitHub. [combined/sqlite3-to-mysql.yml](https://github.com/automic-vault/db/blob/main/combined/sqlite3-to-mysql.yml)


## Sources

- Nucleus package database
- Geiger risk classifier
- package-page enrichment
- curated package history
- package version freshness
- av.db category and tag curation
- package relationship graph
- external package-manager database matches
- cross-ecosystem install command graph
