SQLite Viewer

View and query SQLite database files in your browser.
Supports .db, .sqlite, and .sqlite3 files. No data is uploaded to the server.

Features

  • Client-side processing: Files are processed entirely in your browser.
  • Browse tables: View all tables with row counts in the database.
  • Table schema: Inspect column names, types, and constraints.
  • Pagination: Navigate through large tables with built-in pagination.
  • Export to CSV: Download table data or query results as CSV files.
  • Execute SQL: Run custom SQL queries against the database.
  • No upload: Your database files never leave your device.

How to Use

  1. Click "Choose File" and select your SQLite database file (.db, .sqlite, .sqlite3).
  2. The tables in the database will be listed on the left sidebar with their row counts.
  3. Click on a table name to view its data and schema information.
  4. Use the "Show Schema" button to see column details including types and constraints.
  5. Navigate through pages using the pagination controls for large tables.
  6. Click "Export CSV" to download the current view as a CSV file.
  7. Or write a custom SQL query and click "Execute" to run it.
  8. Results will be displayed in a table format below.