DB Browser is an SQL Viewer for SQLite Databases
What is DB Browser for SQLite?
DB Browser for SQLite (DB4S) is an open-source tool for creating, designing, and editing SQLite-compatible database files.
It provides a spreadsheet-like interface, eliminating the need to learn complex SQL commands. It includes controls and wizards for creating and compacting database files, and for creating, defining, modifying, and deleting tables.
Features
Features of DB Browser for SQLite (DB4S):
- Create, design, and edit SQLite-compatible database files
- User-friendly, spreadsheet-like interface
- No need to learn complicated SQL commands
- Create and compact database files
- Create, define, modify, and delete tables
- Create, define, and delete indexes
- Browse, edit, add, and delete records
- Search records
- Import and export records as text
- Import and export tables from/to CSV files
- Import and export databases from/to SQL dump files
- Issue SQL queries and inspect the results
- Examine a log of all SQL commands issued by the application
- Plot simple graphs based on table or query data