SQLite Vacuum & Optimize - Compact Database

Vacuum SQLite databases to reclaim space, defragment, and optimize. Run VACUUM and ANALYZE commands. Browser-based tool.

Load Database

Drop SQLite file here or click to browse

Load a database to see size information

Security: Only process files from sources you trust. All processing happens locally in your browser.

VACUUM rebuilds the entire database, reclaiming unused space from deleted rows and defragmenting the file for better performance.

After deleting significant data, periodically for databases with frequent updates/deletes, or when the file has grown unexpectedly large.

ANALYZE collects statistics about table contents. SQLite uses these stats to choose optimal query plans.

No. All processing happens locally using SQL.js. Your database stays in your browser.

Depends on how much was deleted. You might save anywhere from 0% (if compact) to 50%+ (after major deletions).

No. VACUUM and ANALYZE don't modify your data, only the internal structure and statistics.

auto_vacuum keeps the database compact automatically but has a small performance cost. This tool shows your current setting.

VACUUM rewrites the entire database, so it's proportional to database size. Large databases may take seconds to minutes.

REINDEX rebuilds all indexes from scratch. Useful if indexes become corrupted or after major data changes.

Not in the browser. In production, use auto_vacuum or schedule VACUUM in your application/cron jobs.