Extensions

Flokk supports popular PostgreSQL extensions, installable with one click from the dashboard or via the API. No superuser access needed.

Available extensions by tier

Basic (Starter + Pro + Dedicated)

Extension	Description
`pgcrypto`	Cryptographic functions (hashing, encryption)
`uuid-ossp`	UUID generation functions
`pg_trgm`	Trigram-based text similarity and search
`citext`	Case-insensitive text type
`hstore`	Key-value pairs within a single column

Extended (Pro + Dedicated only)

Extension	Description
`vector`	Vector similarity search (pgvector)
`postgis`	Geographic objects and spatial queries
`pg_stat_statements`	Query performance statistics
`timescaledb`	Time-series data optimisations
`pg_cron`	Scheduled jobs inside PostgreSQL

Installing an extension

From the dashboard: go to your database → Extensions tab → click Install next to the extension you want.

Via the API:

curl -X POST https://api.flokk.dev/api/v1/databases/DB_ID/extensions \
  -H "Authorization: Bearer sk_live_..." \
  -H "Content-Type: application/json" \
  -d '{"name": "vector"}'

Blocked extensions

Extensions that provide filesystem or OS-level access are blocked on all tiers for tenant isolation: plpythonu, plperlu, plsh, adminpack, file_fdw, pg_execute_server_program.