Create YSQL extensions

Extend the functionality of your cluster using PostgreSQL extensions

YugabyteDB is bundled with a number of PostgreSQL extensions that are tested to work with YSQL.

Loading extensions

Before using an extension, you must load it in the database using the CREATE EXTENSION command. For example:

CREATE EXTENSION fuzzystrmatch;

Required privileges

In YugabyteDB Managed, extensions can only be loaded by users that are a member of the yb_extension role. All yb_superuser users, including the default database admin user, are members of yb_extension.

Use the GRANT statement to assign the role to users. For example, to grant the yb_extension role to user, use the following command:

yugabyte=# GRANT yb_extension TO user;

For more information on roles in YugabyteDB Managed, refer to Database authorization in YugabyteDB Managed clusters.

Request support for a new extension

You cannot install new extensions in YugabyteDB Managed.

If you need a database extension that is not bundled with YugabyteDB added to a cluster, contact Yugabyte Support with the names of the cluster and extension, or reach out on Slack.

Learn more