← Back to SQLiteScope

User Guide

Getting Started

Open SQLiteScope and either drag & drop a database file onto the drop zone, or click to browse your files. You can also click Try Sample Database to explore a pre-built e-commerce dataset.

Supported Formats

Browsing Tables

The left sidebar shows all tables, views, indexes, and triggers in your database. Click any table name to view its data in the main area. Row counts are shown next to each table.

Click column headers to sort data ascending or descending. Data is paginated at 50 rows per page — use the navigation buttons at the bottom to browse.

Running SQL Queries

Switch to the SQL Query tab to write and execute custom SQL. Type your query and click Run or press Ctrl+Enter. Results appear in a table below the editor.

Your last 20 queries are saved in the history dropdown for easy re-use. Multiple statements separated by semicolons are supported.

Database Overview

The Overview tab shows database metadata (file size, SQLite version, page info) and a bar chart comparing table sizes by row count.

Exporting Data

Click Export CSV in the toolbar to download the currently visible data (table browse or query results) as a CSV file.

Privacy

Everything runs in your browser. Your database files are never sent to any server. Close the tab and the data is gone from memory. Read our privacy policy for details.

Tips