# SQLite

Source: https://athas.dev/docs/sqlite

Open and inspect SQLite database files directly in Athas.

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](https://athas.dev/docs/database-viewer) for shared connection and editing behavior.