Extensions are exactly as they sound - they "extend" the database with functionality which isn't part of the Postgres core. Supabase has pre-installed some of the most useful open source extensions.
1. Go to the Database page2. Click on "Extensions" in the sidebar 3. Find the extension you would like to enable/disable 4. Click the toggle.
-- Example: enable the "pgtap" extension create extension pgtap; -- Example: disable the "pgtap" extension drop extension pgtap;
Even though the SQL code is
create extension, this is the equivalent of "enabling the extension".
To disable an extension you can call
Supabase is pre-configured with over 50 extensions. You can also install your own SQL extensions directly into the database through our SQL editor.