DbConvert

Convert your PostgreSQL or MySQL database to an SQLite file with ease. DbConvert provides both a modern Command-Line Interface (CLI) and a user-friendly Graphical User Interface (GUI).

Features

• Convert PostgreSQL databases to SQLite
• Convert MySQL databases to SQLite
• Command-line interface for fast, scriptable usage
• Graphical user interface for easy, no-code conversion
• Preserves table structures and data
• Supports all common data types
• Rich progress display and error reporting

Installation

You can install DbConvert using pip:

pip install dbconvert

To use the GUI, install with the extra dependencies:

pip install dbconvert[gui]

Requirements

• Python 3.8 or higher
• PostgreSQL or MySQL database to convert from
• (For GUI) Pillow >= 10.0.0

Usage

Command Line Interface (CLI)

dbconvert [COMMAND] [OPTIONS]

Commands:
  convert              Convert a database to SQLite
  supported-databases  Show supported database types
  gui                  Launch the graphical user interface

Options for convert:
  --source TEXT    Source database type (postgres, mysql)  [required]
  --conn TEXT      Source database connection string         [required]
  --sqlite TEXT    Target SQLite database file path         [required]
  --help          Show this help message and exit

Connection String Format

PostgreSQL

postgresql://[user[:password]@][host][:port][/dbname]

MySQL

mysql://[user[:password]@][host][:port][/dbname]

CLI Examples

1. Convert a PostgreSQL database:

dbconvert convert --source postgres --conn "postgresql://user:password@dbhost:5432/mydb" --sqlite mydb.sqlite

2. Convert a MySQL database:

dbconvert convert --source mysql --conn "mysql://user:password@dbhost:3306/production" --sqlite prod_backup.sqlite

3. List supported database types:

dbconvert supported-databases

4. Launch the GUI:

dbconvert gui

Graphical User Interface (GUI)

After installing with GUI support, launch the GUI with:

dbconvert gui

• Select your source database type, enter the connection string, and choose the target SQLite file path.
• Click "Convert" to start the conversion process.
• The GUI provides progress and error reporting, and allows you to reset or clear output easily.

Development

Setup Development Environment

1. Clone the repository:

git clone https://github.com/ysskrishna/dbconvert.git
cd dbconvert

2. Create and activate a virtual environment:

python -m venv venv
source venv/bin/activate  # On Windows: venv\Scripts\activate

3. Install development dependencies:

pip install -e .

4. Install development dependencies with GUI support:

pip install -e ".[gui]"

License

This project is licensed under the MIT License - see the LICENSE file for details.

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

Support

If you encounter any issues or have questions, please open an issue on GitHub.