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.