DB Convert

Copy PostgreSQL or MySQL into a single SQLite file, from the CLI or a simple desktop UI

DbConvert uses SQLAlchemy and a Typer-based CLI to migrate schema and data from PostgreSQL or MySQL into SQLite. The same project offers an optional GUI (extra install) for guided runs, with progress and error reporting described in the README.

When it is useful

You want a portable SQLite snapshot for local dev, analytics, offline inspection, or shipping an embedded DB, without writing a one-off ETL for the happy path. You provide connection strings and a target file path.

What you can do

Run convert with --source, --conn, and --sqlite as documented for Postgres or MySQL.
List supported source types or launch gui when installed with GUI extras.
Script conversions in CI or backups once you validate results on a copy of production data.

Limits

Complex schemas (exotic types, heavy triggers, cross-database features) may need manual follow-up; always verify row counts and critical tables.
This tool creates SQLite; it is not a bidirectional sync engine or zero-downtime migration service.
Secrets in connection strings belong in secure storage, not pasted into tickets or logs.

Frequently asked questions

What does DB Convert do?

It migrates schema and data from PostgreSQL or MySQL into a single SQLite file using SQLAlchemy and a Typer CLI. An optional GUI (install with the gui extra) adds guided runs with progress and error reporting.

How do I install and run a conversion?

Install with pip install dbconvert (Python 3.8+). Run dbconvert convert with --source postgres or mysql, --conn for the connection string, and --sqlite for the target file path. Use pip install dbconvert[gui] then dbconvert gui for the desktop UI.

Is it free?

Yes. The product is listed as Free on this site.

What are the limits?

Complex schemas (exotic types, heavy triggers, cross-database features) may need manual follow-up, so verify row counts and critical tables. It creates SQLite only; it is not a bidirectional sync engine or zero-downtime migration service.