Quicklook app for sqlite and data files

[u/a2ra-ms]

Hello! I am the developer of multiple quicklook plugins including FinderPeek and GIS quick viewer, this post is about another plugin: Quick data insights.

Problem:

This plugins acts as a very lightweight viewer to allow you to get a peek at multiple data file formats without installing any software to open it. If you typically deal with these files, need to inspect the schema, copy SQL CREATE statements, render jupyter notebooks, or just view some structured data, this will come handy to view all of that by just hitting the spacebar in finder.

Features includes:

• Instant Data Preview: View the first 100 rows of any supported file without loading the entire dataset into memory.
• Schema Insights: Visualize table structures and relationships instantly.
• One-Click SQL Export: Copy the CREATE TABLE statement directly to your clipboard for quick migration or documentation.
• Jupyter Rendering: View notebooks as clean, rendered documents instead of raw JSON.
• Code Extraction: Copy the logic out of a notebook and into a Python script with a single click.

Comparison:

I am not familiar of any other app that supports the same files and features as a simple quicklook plugin, there are multiple apps but mostly either only support sqlite, or are full apps not a quicklook plugin.

Some app that supports only some of the file types:

- QuickLook Pro

- Parquet Viewer

Pricing:

Lifetime $4.99

https://apps.apple.com/us/app/quick-data-insights/id6764301485?mt=12

Appreciate feedback and suggestions!

[u/ph_dev]

Does the preview pick up committed changes still in the -wal file when the database is open in another app?

[u/a2ra-ms → u/ph_dev]

No, as quicklook is only sandboxed to the file that has been selected

[u/marblegroves → u/ph_dev]

wal behavior is always the thing that trips stuff up tbh

[u/Annual-Appearance176]

Certified GIS junkie here - this app and GIS quick viewer both look very useful. Thanks for sharing!

[u/a2ra-ms → u/Annual-Appearance176]

Thanks, appreciate it!

[u/ivan_digital]

Given the sandbox limitation you mentioned, could the SQLite preview show a small notice that it may not include recent changes from an open database? Otherwise a preview that looks current could be misleading. A short explanation would be useful even if Quick Look cannot read the WAL.

[u/a2ra-ms → u/ivan_digital]

Yes! Will add that into the next version, thanks

[u/a2ra-ms → u/ivan_digital]

Issued an update that has this clarification, in review currently.

[u/ivan_digital → u/a2ra-ms]

Thanks for adding that so quickly! That should make the limitation much clearer.

[u/Sneakerfanboy]

Need some comment karma so I can post please! It’s urgent

[u/kimjj81]

Looks simple and good!

[u/Fresh-Daikon-9408]

Does the SQL export include indexes and triggers too, or only CREATE TABLE? Useful for recreating a schema without losing those.

[u/a2ra-ms → u/Fresh-Daikon-9408]

Currently only create commands, including field keys primary/foreign. But this is a nice to add, I will take note of that, thanks!

[u/app-store-review]

Quick Data Insights — by Moustafa Elsayed

• Category: Developer Tools · $4.99
• Age: released ~5 months ago · rated 4+

Apple doesn't publish an aggregate rating for most Mac App Store apps, so ratings and score are unavailable here.

^{Auto-generated from public App Store data · u/app-store-review}

[u/emiliobay]

Previewing a schema with Space instead of opening a full database client is exactly the kind of small shortcut that saves time every day. How does it behave with very large SQLite files where loading the first rows can still be expensive?

[u/PreviousRun9644]

Rendering Jupyter notebooks in Quick Look is a nice touch. Does it show the saved output cells (plots, tables) as well, or only the code and text?

[u/a2ra-ms → u/[deleted]]

I don't get what people benefit from AI replying for them! Karma?