SQLite Viewer

User Guide

Learn how to use SQLite View effectively

Last updated: June 15, 2023

This guide will help you get the most out of SQLite Viewer, a powerful browser-based tool for working with SQLite databases.

Table of Contents

Introduction

SQLite Viewer is a client-side application that runs entirely in your web browser. It allows you to create, view, edit, and analyze SQLite databases without installing any software or uploading your data to external servers.

Key Benefits

  • Privacy: Your data never leaves your browser
  • Convenience: No installation required
  • Powerful: Full SQLite functionality in a web interface
  • User-friendly: Intuitive design for both beginners and experts

Getting Started

Opening a Database

Click the Open Database button in the top navigation bar to:

  • Create New: Start a fresh database
    • You'll be prompted to name your database
    • A new, empty database will be created
  • Open File: Import an existing database
    • Select a .sqlite, .db, or .sqlite3 file from your device
    • The database will be loaded into the application
  • Recent: Access recently used databases
    • Select from a list of previously opened databases
    • Databases are stored in your browser's local storage

Interface Overview

The SQLite Viewer interface consists of:

  • Top Navigation Bar: Database operations and global settings
  • Left Sidebar: Database structure (tables, views, indexes, triggers)
  • Main Content Area: Data viewing and editing
  • Tab Navigation: Switch between different views of your data

Database Management

Creating a New Database

  1. Click Open Database → Create New
  2. Enter a name for your database
  3. Click Create

Naming and Renaming Databases

  • When creating a new database, you'll be prompted to provide a name
  • To rename an existing database:
    1. Click on the database name in the header
    2. Enter the new name
    3. Press Enter or click outside the input field

Clearing Data

To remove a database from local storage:

  1. Click the Close button
  2. Confirm that you want to clear the database from storage

Working with Tables

Viewing Table Data

  1. Select a table from the left sidebar
  2. The table's data will appear in the main content area
  3. Use pagination controls to navigate through large datasets

Adding a New Table

  1. Click the + button next to the "Tables" heading in the sidebar
  2. Enter table details:
    • Table name
    • Column definitions (name, type, constraints)
  3. Click Create Table

Editing Table Data

  1. Navigate to the table you want to edit
  2. Click on a cell to modify its value
  3. Press Enter to save changes

Table Operations

Click the ... menu next to a table name to access operations:

  • Edit Table: Modify table structure
  • Rename Table: Change the table name
  • Delete Table: Remove the table and all its data
  • Export Table: Save the table data to a file

Running SQL Queries

Using the SQL Editor

  1. Click the Custom SQL tab
  2. Type your SQL query in the editor
  3. Click Run to execute
  4. Results will appear in the table below

SQL Command History

  • Previously executed commands are stored in the command history
  • Access them by clicking the up/down arrows in the SQL editor

Schema Visualization

Viewing Table Schema

  1. Select a table from the sidebar
  2. Click the Schema tab
  3. View detailed information about:
    • Column names
    • Data types
    • Constraints (NOT NULL, PRIMARY KEY, etc.)
    • Default values

Editing Column Properties

  1. In the Schema view, click the edit icon next to a column
  2. Modify properties:
    • Column name
    • Data type
  3. Click Save Changes

Visualizing Database Structure

  1. Click the Schema Visualizer tab
  2. View a graphical representation of:
    • Tables and their columns
    • Relationships between tables
    • Primary and foreign keys

Data Import and Export

Importing Data

SQLite Viewer supports importing:

  • SQLite database files (.sqlite, .db, .sqlite3)
  • CSV files
  • Excel files (.xlsx, .xls)
  • JSON files

Exporting Data

Export options:

  • Full Database: Save the entire database
  • Table: Export a specific table
  • Query Results: Save the results of a SQL query

Export formats:

  • SQLite (.sqlite)
  • CSV
  • JSON

Privacy and Security

Data Storage

  • All data is stored locally in your browser using IndexedDB
  • Database files, table rows, SQL text, and file names are not sent to external servers for viewing or processing
  • Support chat messages are sent to the support service only when you choose to use chat
  • Data persists between sessions unless you clear browser data

Privacy Guarantees

  • No database file contents are uploaded for viewing or processing
  • Product analytics may record anonymous usage events, but not database contents, row values, SQL text, or file names
  • No account required

Data Backup

We recommend regularly exporting important databases to files on your local system, as browser storage can be cleared accidentally.

Thank you for using SQLite View! We hope this guide helps you make the most of our application.