This page is designed to help you find out whether QueryLight.app is good and if it is the right choice for you.
QueryLight is a SQLite client for macOS, written in Swift and AppKit. It only works with SQLite, and that won't change: the idea is to go further into one database than a general tool can.
It draws EXPLAIN QUERY PLAN as a diagram and can run a query repeatedly to show which step takes the time. It manages FTS5 tables, inspects PRAGMAs and database health, and compares two schemas and writes the migration SQL. There are also ER diagrams, a tree view for JSON columns, BLOB previews, and a browser for databases in the iOS Simulator, Core Data stores included.
Files open read-only by default. It handles SQLCipher-encrypted databases and connects to Cloudflare D1 and Turso. Requires macOS 14.
All features are free for 7 days. After that the basic editor stays free, and the SQLite tools are a one-time purchase. No subscription, no account.
Listed in
Query Profiling
Run a query N times for min/median/p95/max timing, with per-step cost on the plan
Schema Comparison and Synchronization
Diff two databases and generate the migration SQL to bring one in line with the other
Full-Text Search
Create FTS5 tables, pick a tokenizer and content mode, and test MATCH queries
Entity Relationships
Auto-generated crow's-foot ER diagrams from foreign keys
Encryption Support
Opens SQLCipher databases encrypted with AES-256
Database Health Checks
PRAGMA inspector with integrity check, fragmentation, WAL size and one-click VACUUM/ANALYZE
Remote Databases
Browse and query Cloudflare D1 and Turso databases
iOS Simulator Databases
Finds app databases in running simulators, including Core Data and SwiftData stores
Query Plan Visualization
EXPLAIN QUERY PLAN drawn as cards, with full scans and temporary B-trees marked
JSON Viewer
Expands JSON columns into navigable trees
Visual Query Builder
Drag tables onto a canvas to build a SELECT, then edit the SQL it generates
Read-only by Default
Databases open read-only to prevent accidental writes
Quick Look and Spotlight
Preview .sqlite files in Finder and find tables in Spotlight
Live Change Detection
Spots writes from other processes and refreshes the data grid
It only does SQLite, so it covers the parts that multi-engine clients skip: EXPLAIN QUERY PLAN drawn as a diagram, a profiler that runs a query N times and shows per-step cost on the plan, FTS5 table management, a PRAGMA inspector with health checks, and schema diff that writes the migration SQL. It's a native Swift and AppKit app and opens files read-only by default.
TablePlus and DataGrip support dozens of databases. DB Browser for SQLite is free and good for browsing and editing. QueryLight is for when you need to see why a query is slow, manage FTS5 indexes or check a database's health without going back to the sqlite3 shell. It's a one-time purchase with no subscription.
I got tired of database tools that were either slow Java apps or generic clients trying to support every database at once, with SQLite as an afterthought. QueryLight does one thing: SQLite, in a native Mac app. I built it around three things I needed: opening the databases inside the iOS Simulator without digging through folders, working with remote SQLite on Cloudflare D1 and Turso the same way as local files, and seeing changes right away when another process writes to the database.
Developers on macOS who run SQLite in production or in serious side projects, such as Rails 8, Turso, Cloudflare D1 and Litestream users, plus iOS developers inspecting their app's SQLite, Core Data and SwiftData stores.
Swift 6 and AppKit, a bundled SQLCipher build (SQLite 3.51.3), Tree-sitter for SQL parsing, and Sparkle for updates.
We have collected here some useful links to help you find out if QueryLight.app is good.
Check the traffic stats of QueryLight.app on SimilarWeb. The key metrics to look for are: monthly visits, average visit duration, pages per visit, and traffic by country. Moreoever, check the traffic sources. For example "Direct" traffic is a good sign.
Check the "Domain Rating" of QueryLight.app on Ahrefs. The domain rating is a measure of the strength of a website's backlink profile on a scale from 0 to 100. It shows the strength of QueryLight.app's backlink profile compared to the other websites. In most cases a domain rating of 60+ is considered good and 70+ is considered very good.
Check the "Domain Authority" of QueryLight.app on MOZ. A website's domain authority (DA) is a search engine ranking score that predicts how well a website will rank on search engine result pages (SERPs). It is based on a 100-point logarithmic scale, with higher scores corresponding to a greater likelihood of ranking. This is another useful metric to check if a website is good.
The latest comments about QueryLight.app on Reddit. This can help you find out how popualr the product is and what people think about it.
Do you know an article comparing QueryLight.app to other products?
Suggest a link to a post with product alternatives.
Is QueryLight.app good? This is an informative page that will help you find out. Moreover, you can review and discuss QueryLight.app here. The primary details have been verified within the last quarter. So they could be considered up to date. If you think we are missing something, please use the means on this page to comment or suggest changes. All reviews and comments are highly encouranged and appreciated as they help everyone in the community to make an informed choice. Please always be kind and objective when evaluating a product and sharing your opinion.
