# SHOW CATALOGS

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: SHOW CATALOGS
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/sql-statements/show-catalogs
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-statements/show-catalogs.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-statements/show-catalogs.adoc
description: The SHOW CATALOGS statement lists catalogs in the cluster. Variants list only Redpanda catalogs or only Iceberg catalogs.
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-statements/show-catalogs.md -->

The `SHOW CATALOGS` statement lists catalogs in the cluster. Variants filter by catalog type: Redpanda catalogs or Iceberg catalogs.

> 📝 **NOTE**
>
> `SHOW CATALOGS` and its variants only display catalogs in schemas where the user has the `USAGE` grant.

## [](#syntax)Syntax

```sql
SHOW CATALOGS;
SHOW REDPANDA CATALOGS;
SHOW KAFKA CATALOGS;
SHOW ICEBERG CATALOGS;
```

`SHOW KAFKA CATALOGS` is a synonym for `SHOW REDPANDA CATALOGS`.

## [](#examples)Examples

### [](#list-all-catalogs)List all catalogs

To list all catalogs (both Redpanda and Iceberg) visible to the caller:

```sql
SHOW CATALOGS;
```

For SQL-queryable access to the same information (with `WHERE`, `ORDER BY`, and `LIMIT` support), see [`system.catalogs`](https://docs.redpanda.com/cloud-data-platform/reference/sql/system-virtual-tables/#system-catalogs).

### [](#list-only-redpanda-catalogs)List only Redpanda catalogs

```sql
SHOW REDPANDA CATALOGS;
```

### [](#list-only-iceberg-catalogs)List only Iceberg catalogs

```sql
SHOW ICEBERG CATALOGS;
```

For each Iceberg catalog’s REST endpoint, warehouse, and authentication type, see [`system.iceberg_catalogs`](https://docs.redpanda.com/cloud-data-platform/reference/sql/system-virtual-tables/#system-iceberg-catalogs) or [`DESCRIBE ICEBERG CATALOG`](https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-statements/describe/).