Best System Utilities for SQLite

DbSchema is for visual designing the schema in a team, deploy and document the schema. Other integrated features like data explorer, visual query editor, data generator, etc., makes DbSchema an every-day tool for everybody who interacts with databases. DbSchema supports all relational and No-SQL databases, including MySQL, PostgreSQL, SQLite, Microsoft SQL Server, MongoDB, MariaDB, Redshift, Snowflake, Google and more. DbSchema is reverse-engineering the database schema from the database and visualize it as diagrams. You will interact with the database using diagrams and visual tools. DbSchema model is using its copy of schema structure, independent from the database. This allows the schema deployment on multiple databases, save the design model to file, store it in GIT and design the schema in a team, design the schema without database connectivity, compare different versions of the schema and generate SQL migration scripts.

This is a dual-pane explorer, there are two folders shown at same time, and common operation such as copying files are done from one pane to another. And X-plore shows folder hierarchy in a tree view for clear orientation and fast switching to other location. You may explore internals of the device, and if you're power user and have your device rooted, you can make changes to system data - backup files, remove unwanted applications, etc. If you're standard user, you may choose to hide internal memory from view and be sure not to mess with system. You can comfortably see contents of mass memories on your device, or possibly attached USB memory stick.

​Tad is a free (MIT Licensed) desktop application for viewing and analyzing tabular data. It is a fast viewer for CSV and Parquet files and SQLite and DuckDb databases that support large files. It's a Pivot Table for analyzing and exploring data. Internally, Tad uses DuckDb for fast, accurate processing. Designed to fit into the workflow of data engineers and data scientists. Tad includes updates to DuckDb 1.0, the ability to export filtered tables as Parquet (as well as CSV), a fix for formatting numbers in scientific notation, and other minor bug fixes and dependent package upgrades. A packaged installer for Tad is available for macOS (x86 and Apple Silicon), Linux, and Windows.