---
name: "db.databases"
section: "1grass"
platform: "linux"
package: "grass-doc"
version: "8.4.1-1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/db.databases"
---

# db.databases(1grass)

Lists all databases for a given driver and location.

## NAME

**db.databases**  - Lists all databases for a given driver and location.

## KEYWORDS

database, attribute table, SQL

## SYNOPSIS

**db.databases**\
 **db.databases --help**\
 **db.databases**  \[**driver**=*name*\]   \[**location**=*name*\]   \[--**help**\]  \[--**verbose**\]  \[--**quiet**\]  \[--**ui**\]

### Flags:

- **--help**

  Print usage summary

- **--verbose**

  Verbose module output

- **--quiet**

  Quiet module output

- **--ui**

  Force launching GUI dialog

### Parameters:

- **driver**=*name*

  Name of database driver\
   Options: *dbf, mysql, odbc, ogr, pg, sqlite*\
   Default: *sqlite*

- **location**=*name*

  Location\
   Path for SQLite driver, or connection string for PostgreSQL driver

## DESCRIPTION

*db.databases* lists all databases for a given **driver** and optionally **location**.

## NOTES

Currently supported database drivers are *SQLite*, *PostgreSQL*, and *ODBC*.

Default **location** for SQLite driver is the full path for the current mapset. For PostgreSQL driver it’s empty connection string.

## EXAMPLES

List SQLite databases in the current mapset:\

```
db.databases driver=sqlite
```

List SQLite databases in a given directory:\

```
db.databases driver=sqlite location=/opt/sqlite
```

List PostgreSQL databases from database server running on given port:\

```
db.databases driver=pg location="host=server_name port=5333"
```

## SEE ALSO

*db.columns,* *db.describe,* *db.drivers,* *db.execute,* *db.login,* *db.tables*

GRASS SQL interface

## AUTHORS

Radim Blazek, ITC-Irst, Trento, Italy\
 Updated for GRASS 7 by Martin Landa, Czech Technical University in Prague, Czech Republic

## SOURCE CODE

Available at: db.databases source code (history)

Accessed: Monday Feb 24 17:50:22 2025

Main index \| Database index \| Topics index \| Keywords index \| Graphical index \| Full index

© 2003-2025 GRASS Development Team, GRASS GIS 8.4.1 Reference Manual