SQLite Validator
Drop any .db, .sqlite, or .sqlite3 file to instantly check its integrity. Validates the file header, runs a full PRAGMA integrity_check, inspects every table's schema, counts rows, flags issues, and previews your data. Nothing leaves your browser.
SQLite Database File
Drop a .db, .sqlite, or .sqlite3 file here, or
Supports .db, .sqlite, and .sqlite3 files up to 100 MB
⛔
Wrong file type — only .db, .sqlite, or .sqlite3 files are supported. You dropped a file.
Loading sql.js engine…
Validation Errors
Warnings
✓ Valid SQLite Database
Database Header
Tables & Views
| # | Name | Type | Rows | Columns |
|---|
Column Schema
| CID | Name | Type | Not Null | Default | PK |
|---|
Data Preview (first 5 rows)
How It Works
1
Drop your SQLite fileDrag it onto the drop zone or click "browse" to select it. Supports
.db, .sqlite, and .sqlite3 files up to 100 MB.2
Deep integrity analysisThe validator loads the file into a real SQLite engine (via sql.js / WebAssembly), verifies the file header magic bytes, runs
PRAGMA integrity_check, and inspects every table, view, and index in the schema.3
Review the reportGet a pass/fail result plus full stats: table count, total rows, page size, SQLite version, index count, and a live data preview for every table.
What Gets Validated
- File header magic — confirms the first 16 bytes match the SQLite magic string
SQLite format 3. Catches truncated or non-SQLite files immediately. - Integrity check — runs SQLite's built-in
PRAGMA integrity_checkwhich detects corrupt pages, mismatched row counts, broken b-tree structures, and invalid cell pointers. - Schema inspection — lists every table and view with column names, types, NOT NULL constraints, default values, and primary key membership.
- Row counts — reports the exact number of rows in each table so you can spot unexpectedly empty or oversized tables.
- Index inventory — counts all indexes and flags tables with no indexes (potentially slow for large datasets).
- Database statistics — reports page size, page count, SQLite version stored in the file, auto-vacuum mode, journal mode, encoding, and application ID.
- Data preview — renders the first 5 rows of each table so you can visually confirm data looks correct.
NULLvalues are clearly labeled. - Empty tables — flags any table with zero rows, which may indicate a loading or migration issue.
🔒 Privacy & Security
All validation is performed locally using sql.js — a WebAssembly build of SQLite that runs entirely in your browser. Your database file is never sent to a server. Suitable for sensitive business data, personal records, or any private database.