Data · .sqlite
What Is an SQLite File?
A .sqlite file is a self-contained database stored in a single file.
- Extension
- .sqlite, .sqlite3, .db3
- Full name
- SQLite database
- Type
- Data
- MIME type
- application/vnd.sqlite3
- Developed by
- D. Richard Hipp (2000)
Free SQLite Tools
These run in your browser. Your SQLite files are never uploaded.
About SQLite Files
SQLite is the most widely deployed database in the world. Instead of running a server, it stores a complete database of tables, indexes and data in one ordinary file. Every iPhone and Android phone, every browser and countless apps use SQLite files to store data. You can open one with free tools and query it with SQL, export tables to CSV, or inspect what an app has saved.
How to Open an SQLite File
- Windows
- Open it with DB Browser for SQLite, DBeaver or the sqlite3 command-line tool.
SQLite File Questions
How do I export a SQLite table to CSV?
In DB Browser for SQLite choose File, Export, Table(s) as CSV file.
Do I need a server for SQLite?
No. The database is a single file read directly by the app.