# SHOW EXTENSIONS

The `SHOW EXTENSIONS` command lists the [Extensions](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/extensions.md) installed in the current or specified database.

## Syntax

```sql
SHOW EXTENSIONS 
  [{FROM | IN} database]
  [LIKE 'pattern']
```

## Argument

* `FROM database` or `IN database`: Lists the extensions in the specified database.
* `LIKE 'pattern'`: Returns a list of Extensions that match the specified pattern.

## Remarks

* Run the `SHOW EXTENSIONS` command without the `FROM` or `IN` clause to list all the Extensions in the current database.
* Refer to the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permission.

## Examples

* List all the Extensions in the current database:
  ```sql
  SHOW EXTENSIONS;

  ```
  ```output

  +----------------------+
  | Extensions_in_dbTest |
  +----------------------+
  | ts9                  |
  | str_to_ts9           |
  +----------------------+
  ```
* List the Extensions in the specified database with names matching a specific pattern:
  ```sql
  SHOW EXTENSIONS FROM dbTest LIKE 't%';

  ```
  ```output

  +---------------------------+
  | Extensions_in_dbTest (t%) |
  +---------------------------+
  | ts9                       |
  +---------------------------+
  ```

***

Modified at: June 23, 2026

Source: [/db/v9.1/reference/sql-reference/show-commands/show-extensions/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-extensions/)

(An index of the documentation is available at /llms.txt)