---
title: SHOW CATALOGS
description: Description: List the available catalogs and their types. 
url: https://www.elastic.co/elastic/docs-builder/docs/3016/reference/query-languages/sql/sql-syntax-show-catalogs
products:
  - Elasticsearch
---

# SHOW CATALOGS
```sql
SHOW CATALOGS
```

**Description**: List the available catalogs and their types.
```sql
SHOW CATALOGS;

     name         |     type
------------------+---------------
javaRestTest         |local
my_remote_cluster |remote
```