SQLite
Open and inspect SQLite database files directly in Athas.
Updated
SQLite support is built into Athas for local database files.
Open SQLite Files
Open a .db, .sqlite, or .sqlite3 file from the file tree or with the athas CLI. Athas opens
the file in a database tab automatically.
What You Can Do
- Browse tables and views
- Inspect columns and schema details
- Filter and search table data
- Edit rows and cells where supported
- Run SQL queries
- Copy or export result data when available
Notes
SQLite files are opened directly from disk. They are not saved as network database connections in Settings > Database.
First query
Start with a read query to confirm the connection and inspect the database:
sql
SELECT name FROM sqlite_master WHERE type = 'table';Troubleshooting
Back up the database file before edits. If it is locked, check which other process has it open.
See Database viewer for shared connection and editing behavior.