# 📂 Database Overview

SweepFlow now uses a database system (SQLite) instead of JSON files. This makes everything more stable, faster, and easier to manage. The database stores your entry data, token data, and win data in one place.

***

🔑 Key Features

* Database Page
  * View and manage Entry Data, Token Data, and Win Data.
  * Search entries by email, URL, or identifier.
  * Export any tab directly to CSV for backup or analysis.
  * See item counts for each site (entries, tokens, wins).
* Performance Upgrades
  * Database is optimized for speed — no more lag when switching tabs.
  * Lower memory usage across both main and renderer processes.
  * Live memory stats are displayed in the bottom left of the app.
* Customization
  * Columns can be resized and SweepFlow remembers your layout.
  * Multi-select and delete multiple sites at once.
  * Email suggestions appear while typing for faster task setup.

***

### 🗂️ Location

Your database file is stored locally here:

%appdata%/sweepflow/appdata

***

### 👀 Viewing Your Database

If you’d like to peek inside your database or export data beyond SweepFlow’s built-in tools, you can use a third-party SQLite viewer.

Popular options include:

* DB Browser for SQLite – simple and free, perfect for browsing and exporting tables.
* Beekeeper Studio – modern interface, supports multiple databases.
* DBeaver – powerful, all-purpose database manager.

\
👉 These tools let you see your entries, tokens, and wins in a spreadsheet-like view and export them to CSV.

***

### ⚠️ Important Notes

* Always close SweepFlow first before opening the database in another program.
* Make a backup before making changes — editing the DB directly can break things.
* Only view or export unless you know what you’re doing. Don’t change the database structure.
* SweepFlow already exports CSVs from inside the app, so most users won’t need external tools at all.

***

🔥 Bottom line: The database makes SweepFlow faster, safer, and more user-friendly, while giving advanced users the option to view or export their data with third-party tools.
