> ## Documentation Index
> Fetch the complete documentation index at: https://docs.mindsdb.com/llms.txt
> Use this file to discover all available pages before exploring further.

# List Projects

## Description

The `SHOW DATABASES` command lists all available data sources and projects. The `WHERE` clause filters all projects.

## Syntax

Here is the syntax:

```sql theme={null}
SHOW DATABASES
WHERE type = 'project';
```

Alternatively, you can use the `FULL` keyword to get more information:

```sql theme={null}
SHOW FULL DATABASES
WHERE type = 'project';
```