Home
Name Modified Size InfoDownloads / Week
Readme-SqlConverter.md 2026-01-07 2.4 kB
sqlciphercoverter.py 2026-01-07 4.6 kB
Totals: 2 Items   7.0 kB 0

πŸ” SQLCipherConverter

Convert Normal SQLite db to SQLCipher Encrypted Database ( Selected Tables only )

A simple cross-platform Python GUI tool to:

  • Open an existing SQLite database
  • Select specific tables/views
  • Export them into a new, SQLCipher-encrypted SQLite database

πŸ“¦ Features

  • βœ… Open .db, .sqlite, or .sqlite3 files
  • βœ… List all tables and views
  • βœ… Select multiple items for export
  • βœ… Set a custom encryption password
  • βœ… Save as a new encrypted SQLite database using SQLCipher

🧰 Requirements

Before running the app, ensure you have the following installed:

  • Python 3.10+
  • tkinter (comes with standard Python installations)
  • pysqlcipher3 – for SQLCipher support

Install dependencies via pip:

pip install pysqlcipher3

⚠️ On Windows: You may need to install Microsoft Visual C++ Build Tools first.
See: Visual Studio C++ Build Tools

If you are unable to compile pysqlcipher3 yourself, download from https://pypi.org/project/sqlcipher3-wheels/#files


▢️ How to Run

  1. Clone or download the project: bash git clone https://github.com/yourusername/sqlciphercoverter.git cd sqlciphercoverter

  2. Run the app: bash python sqlciphercoverter.py


πŸ–₯️ Usage Guide

  1. Click "Open DB" to load an SQLite file.
  2. From the list, select one or more tables/views to export.
  3. Click "Export to Encrypted DB", enter a password.
  4. Choose a location to save the new encrypted database.

πŸ“ Project Structure

sqlite-encryptor-gui/
β”‚
β”œβ”€β”€ sqlciphercoverter.py       # Main application script
└── README.md                  # This file

πŸ’¬ Notes

  • The app copies both schema and data from selected tables.
  • Views are copied by schema only β€” no data is inserted.
  • Works best with smaller databases due to in-memory operations.
  • For large databases or production use, consider optimizing performance and adding progress indicators.

πŸ“Ž License

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


πŸ‘₯ Contributing

Contributions are welcome! If you'd like to improve the app (e.g., add batch processing, dark mode, or export logs), feel free to open a pull request.

Source: Readme-SqlConverter.md, updated 2026-01-07