Browse and filter
Page through records, sort columns, and combine filter conditions. Inspect long values in the row inspector.
SQLite viewer for Mac and Windows
Open a local SQLite file, inspect its tables, filter rows and run SQL in plainDB. Your file stays on your computer; you do not need to upload it to an online viewer or set up a database server.
New to database tools? Download a practice database and try one reviewed edit.
Start with the file.
Find the answer.
Save a SQLite connection with the path to your database. Browse tables and views, sort and filter rows, or open a SQL tab to ask a more specific question.
Use a read-only connection when you want to inspect data without editing it. For important files, work on a backup made while the application that owns the database is closed, or use SQLite’s backup tools.
Read the SQLite guide ↗
A file on disk. A full working view.
Inspect the structure
View columns, indexes, and table DDL before writing queries or making changes.
Write and keep SQL
Run statements, read their results, and return to saved queries and execution history.
Review grid edits
Stage cell changes and review generated SQL before applying. Editable rows need a reliable identifier.
Which SQLite files can I open?
A standard, unencrypted SQLite database can use extensions such as .sqlite, .sqlite3, or .db. The extension alone does not prove that a file is SQLite. plainDB connects to the local file; it does not require a database server.
What if the database is locked?
Another process may be writing to it. Close the owning application if appropriate, then retry. Do not delete a -wal or -shm file to resolve a lock: those files can be part of the active database state. See SQLite’s write-ahead log documentation for the details.
Can I export the data?
Both builds support CSV, TSV, JSON, Markdown, and SQL INSERT exports. Both platforms can export a whole filtered table in batches. Check the export scope before using a file as a complete copy of your data.
Bring your local data into focus.
A native Mac app and a dedicated Windows build, with PostgreSQL and MySQL alongside SQLite.