By Team Hypomnema · Data
Explore tables, indexes and foreign keys in a local database.
Use the guide alongside the working tool.
Open SQLite Database Explorer →Explicit working sample
customer,order,date,product,amount
A,100,2026-01-01,Notebook,30
A,100,2026-01-01,Pen,10
B,101,2026-01-03,Notebook,25
A,102,2026-02-01,Pen,20
C,103,2026-02-02,Notebook,50
C,103,2026-02-02,Pen,15
B,104,2026-03-01,Pen,35Explore tables, indexes and foreign keys in a local database. Unencrypted SQLite files up to 20 MB. Opens an in-memory copy in query-only mode. One SELECT/WITH query with at most 10,000 result rows. No SQL dumps, remote databases or extensions. Choose the metadata sample to see the database structure.
Prepare the input
Explore tables, indexes and foreign keys in a local database.
Paste the supported structured data or log text. The sample loads only when explicitly selected and can be undone.
Review the method
Unencrypted SQLite files up to 20 MB. Opens an in-memory copy in query-only mode. One SELECT/WITH query with at most 10,000 result rows. No SQL dumps, remote databases or extensions. Choose the metadata sample to see the database structure.
Keep the useful output
Review the summary and result records. Transformation tools retain separate change, rejected-record or diagnostics datasets where relevant. Choose the dataset before exporting; a report and a cleaned dataset serve different purposes.
CSV exports protect formula-like text. JSON keeps data portable without making an Excel workbook. Reports and editable backups may contain private source values; download only what you intend to share. No automatic account storage or server processing is used.
Ready to apply this workflow?
Try SQLite Database Explorer →Explore a related workflow
- SQL Data Explorer: methods and data limits
Query local records with joins, CTEs and window functions.
- Parquet Viewer & Converter: methods and data limits
Inspect local Parquet metadata and export selected records.
- SQL Dump Extractor: methods and data limits
Extract literal INSERT records without executing backup SQL.
- XML Data Extractor: methods and data limits
Extract repeated XML elements, attributes and nested values.
Keep your original files and review the result. Found unclear instructions? Contact Team Hypomnema.