Create YSQL extensions in YugabyteDB Managed
Extend the functionality of your cluster using PostgreSQL extensions. YugabyteDB comes bundled with a number of extensions that are tested to work with YSQL. For a list of bundled extensions, refer to PostgreSQL extensions.
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 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.