Features and Capabilities
DB Browser for SQLite with SQLCipher on Windows is a lightweight, portable tool to browse, edit and design SQLite databases — with optional strong encryption. Explore the core features below and jump to the guides for deeper workflows.
Data browsing and editing
View tables, sort and filter rows, insert/update/delete records directly. Ideal for quick inspections and QA checks.
Tip: keep an audit copy when doing manual edits.
SQLCipher encryption
Create encrypted databases, open existing ones and change passphrases (rekey) with SQLCipher support.
Learn more: SQLCipher basics • Encrypt/Decrypt
Schema design
Create and alter tables, columns, indexes and constraints using visual tools. Preview the SQL before applying changes.
Query editor
Run SELECT/INSERT/UPDATE/DELETE and analyze results. Save queries for reuse and export outputs to CSV.
See also: Useful SQL/PRAGMA commands
Import/Export CSV
Import CSV into new or existing tables with type mapping. Export tables or query results for sharing and analysis.
Guide: CSV import/export
Indexes and pragmas
Create indexes to speed up queries and apply practical PRAGMAs to balance integrity and performance.
Read: Performance tips
Use cases
- Developers: inspect schema, verify migrations, test encryption settings.
- Analysts: browse data, build quick queries, export CSV for reports.
- QA/Support: reproduce issues, review records, anonymize and share samples.
- Education: teach SQL/SQLite with a visual interface.
- Migrations: move between apps by exporting and importing CSV/SQL.
- Security: manage encrypted datasets with documented parameters.