The greatest tool for any work with Sqlite is DB Browser for SQlite. An incredibly straightforward and useful GUI for viewing your tables, browsing data, and testing out queries. 10/10.