A local PyQt6 desktop app for editing SQLite databases in a spreadsheet-like interface, with CSV mirrors and multi-format export.
- Open or create SQLite database files.
- Create, rename, rebuild, and delete tables.
- Add, rename, delete, reorder, and multi-select rows and columns.
- Edit or empty selected cells.
- Search with highlighting or row filtering.
- Preview CSV data as highlighted text or in a read-only table.
- Use persistent change logs with undo and redo.
- Export the current table as CSV, TSV, JSON, XLSX, or SQL.
- Export all tables as XLSX or SQL, and create SQLite backups.
SQLite is the source of truth. CSV mirrors are regenerated after successful table edits.
On first launch, the app uses:
data/database.sqlite
data/csv/<table_name>.csv
When you open or create another database, its CSV mirror is stored beside it:
example.sqlite
example_csv/<table_name>.csv
python -m venv .venv
.\.venv\Scripts\Activate.ps1
pip install -r requirements.txtpython main.pypython -m unittest discover