# DuckDB

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

Open DuckDB files through the Athas database provider system.

DuckDB support is available through the Athas database provider system.

## Open DuckDB Files

Install the DuckDB provider from **Integrations**, then open a `.duckdb` or `.duck` file
from the file tree or with the `athas` CLI.

## What You Can Do

- Browse tables and views
- Inspect columns and schema details
- Run SQL queries
- Filter and search result data
- Copy or export result data when available

## Notes

DuckDB is file-based like SQLite, but it is delivered as an installable database provider rather
than as the built-in default provider.

## First query

Start with a read query to confirm the connection and inspect the database:

```sql
SELECT * FROM information_schema.tables LIMIT 20;
```

## Troubleshooting

Check the provider installation if the file opens as text. Work on a copy when testing writes.

See [Database viewer](https://athas.dev/docs/database-viewer) for shared connection and editing behavior.