# Database Viewer

Source: https://athas.dev/docs/database-viewer

Open SQLite and DuckDB files or connect to PostgreSQL, MySQL, MongoDB, and Redis from Athas.

Athas includes a database viewer for local database files and saved network database connections.

## Open a Database

Open a `.db`, `.sqlite`, `.sqlite3`, or `.duckdb` file from the file tree or from the `athas`
CLI. Athas opens the file in a database tab automatically.

For network databases, use **Database: Connect to Database** from the command palette or the
Database settings tab. Saved connections are listed in **Settings > Database**.

## Supported Sources

Athas currently supports:

- [SQLite](https://athas.dev/docs/sqlite)
- [DuckDB](https://athas.dev/docs/duckdb)
- [PostgreSQL](https://athas.dev/docs/postgresql)
- [MySQL](https://athas.dev/docs/mysql)
- [MongoDB](https://athas.dev/docs/mongodb)
- [Redis](https://athas.dev/docs/redis)

SQLite is built in. DuckDB, PostgreSQL, MySQL, MongoDB, and Redis are database providers installed
from **Integrations**.

## What you can do

- Browse tables, views, collections, or keys depending on the database type
- Inspect schemas and column details
- Filter and search table data
- Edit rows and cells where the provider supports writes
- Run SQL queries for SQL databases
- Copy or export result data when available

## Notes

Local database files are opened directly and are not saved as connections. Saved connections are for
network databases such as PostgreSQL, MySQL, MongoDB, and Redis.

## Connect and query deliberately

Install the required provider, test a connection, and start with a read query. Use a read-only database account when browsing production data. Cell edits and SQL statements can change the original database; they are not isolated previews. Back up local files before experimenting.