---
title: Show the list of all dbt profiles
description: ```
sqleton db ls --use-dbt-profiles
```

doc_version: 1
last_updated: 2026-07-02
---

You can ask sqleton to list all dbt profiles it is able to find.

Don't forget to enable `--use-dbt-profiles`. Use `--dbt-profiles-path` to use another file.

---

```
❯ sqleton db ls --use-dbt-profiles --fields name,type,hostname,database
+---------------------+-------+-----------+-------------------+
| name                | type  | hostname  | database          |
+---------------------+-------+-----------+-------------------+
| localhost.localhost | mysql | localhost | ttc_analytics     |
| ttc.prod            | mysql | localhost | ttc_analytics     |
| prod.prod           | mysql | localhost | ttc_analytics     |
| dev.dev             | mysql | localhost | ttc_dev_analytics |
+---------------------+-------+-----------+-------------------+
```