← All articles

SQLite · 2 min

How to quickly view SQLite tables locally

The fastest way to open a local SQLite database and browse its tables and rows — no server, no import, no command line. A short, practical guide.

SQLite keeps a whole database in a single file, which is convenient right up until you want to look inside it. The command line works, but typing .tables and SELECT * FROM … for every peek gets old fast. Here is the quickest way to browse a local SQLite database visually.

The fast path

  1. Install a native SQLite viewer. JustDB is a small desktop app for macOS and Windows — download it and open it.
  2. Open your file. Point it at any .db, .sqlite or .sqlite3 file. There is no server to start and no import step; the file opens directly.
  3. Browse. The left pane lists every table and view with live row counts. Click a table to see its rows in a grid, along with column types, nullability and defaults.

That is the whole loop — from file on disk to rows on screen in a few seconds.

Look without touching

Browsing is read-only until you decide otherwise. When you do want to change something, edits stage up first and you can read the exact SQL before it runs against the file — so opening a database to look never risks changing it by accident.

From the command line instead

If you prefer the shell, the SQLite CLI covers the basics:

sqlite3 mydata.db
.tables            -- list tables
.schema users      -- show a table's schema
SELECT * FROM users LIMIT 20;

That is perfect for a one-off check. For anything you do repeatedly — scanning several tables, filtering rows, editing a value — a visual viewer is faster and harder to fat-finger.

Why JustDB for this

  • Native and quick — a small app that opens about as fast as you can click it.
  • No server, no signup — open the file and go; nothing is uploaded anywhere.
  • View, query and edit in one window, with a Review-SQL step before any write.

Open your SQLite file in JustDB →

Keep reading