This reference documents every object and method available in Supabase's Kotlin Multiplatform library, supabase-kt. You can use supabase-kt to interact with your Postgres database, listen to database changes, invoke Deno Edge Functions, build login and user management functionality, and manage large files.

To see supported Kotlin targets, check the corresponding module README on GitHub.

The Kotlin client library is created and maintained by the Supabase community, and is not an official library. Please be tolerant of areas where the library is still being developed, and — as with all the libraries — feel free to contribute wherever you find issues.

Huge thanks to official maintainer, jan-tennert.

Installing

Add one or more modules to your project#

Add dependency to your build file:


_10implementation("io.github.jan-tennert.supabase:[module]:VERSION")

The available modules are: gotrue-kt, realtime-kt, storage-kt, functions-kt, postgrest-kt, apollo-graphql, compose-auth and compose-auth-ui

When using multiple modules, you can also use the BOM dependency to ensure that all modules use the same version:


_10implementation(platform("io.github.jan-tennert.supabase:bom:VERSION"))
_10implementation("io.github.jan-tennert.supabase:postgrest-kt")
_10implementation("io.github.jan-tennert.supabase:realtime-kt")

Add Ktor Client Engine to each of your Kotlin targets (required)#

You can find a list of engines here


_10implementation("io.ktor:ktor-client-[engine]:KTOR_VERSION")

Multiplatform example:


_23val commonMain by getting {
_23    dependencies {
_23        //supabase modules
_23    }
_23}
_23val jvmMain by getting {
_23    dependencies {
_23        implementation("io.ktor:ktor-client-cio:KTOR_VERSION")
_23    }
_23}
_23val androidMain by getting {
_23    dependsOn(jvmMain)
_23}
_23val jsMain by getting {
_23    dependencies {
_23        implementation("io.ktor:ktor-client-js:KTOR_VERSION")
_23    }
_23}
_23val iosMain by getting {
_23    dependencies {
_23        implementation("io.ktor:ktor-client-darwin:KTOR_VERSION")
_23    }
_23}

Serialization#

supabase-kt provides several different ways to encode and decode your custom objects. By default, KotlinX Serialization is used.

Use KotlinX Serialization.


_10plugins {
_10    kotlin("plugin.serialization") version "KOTLIN_VERSION"
_10}


_10val supabase = createSupabaseClient(supabaseUrl, supabaseKey) {
_10    //Already the default serializer
_10}

Use Moshi.


_10implementation("io.github.jan-tennert.supabase:serializer-moshi:VERSION")


_10val supabase = createSupabaseClient(supabaseUrl, supabaseKey) {
_10    defaultSerializer = MoshiSerializer()
_10}

Use Jackson.


_10implementation("io.github.jan-tennert.supabase:serializer-jackson:VERSION")


_10val supabase = createSupabaseClient(supabaseUrl, supabaseKey) {
_10    defaultSerializer = JacksonSerializer()
_10}

Use custom serializer.


_11class CustomSerializer: SupabaseSerializer {
_11
_11    override fun <T : Any> encode(type: KType, value: T): String {
_11        //encode value to string
_11    }
_11
_11    override fun <T : Any> decode(type: KType, value: String): T {
_11        //decode value
_11    }
_11
_11}


_10val supabase = createSupabaseClient(supabaseUrl, supabaseKey) {
_10    defaultSerializer = CustomSerializer()
_10}

Initializing

Create Supabase Client

Independently of which Supabase module you are using, you will need to initialize the main client first and install the module.

To create a new client, you can use the createSupabaseClient function.

When installing a module, you can pass a block to configure it.

OAuth and OTP link verification

supabase-kt provides several platform implementations for OAuth and OTP link verification.
On JVM, it uses a HTTP Callback Server to receive the session data from a successful OAuth login.

Note: OTP link verification such as sign ups are not supported on JVM. You may have to send a verification token rather than a url in your E-Mail. To send the token, rather than a redirect url, you have to change {{ .ConfirmationURL }} in your sign up email to {{ .Token }}

On Android, IOS & MacOS, it uses deeplinks. Refer to the guide below on how to setup deeplinks. Alternatively you could use Native Google Auth or a WebView for OAuth. Refer to our demo to learn more. On JS, it uses the website origin as the callback url. Session importing gets handled automatically. Windows, tvOS, watchOS & Linux currently have no default implementation. Feel free to create a PR.

You always make your own implementation and use gotrue.parseSessionFromFragment(fragment) or gotrue.parseSessionFromUrl(url) to let supabase-kt handle the parsing after receiving a callback. Then you can simply use gotrue.importSession(session).

Configure deeplink callbacks for Authentication

Deeplinks are supported on Android, IOS and MacOS.

Setup a deeplink for you app
On Android you may setup a deeplink in your Android manifest.
On IOS & MacOS you may setup a url scheme.
Add your deeplink to the redirect URLs
Pattern: scheme://host

Configure the GoTrue plugin You have to set the host and the scheme in the GoTrue config:

install(GoTrue) {
   host = "deeplink host" // this can be anything, eg. your package name or app/company url (not your supabase url)
   scheme = "deeplink scheme"

   //Android only, you can also change that OAuth/SSO logins open in a custom tab, rather than an external browser:
   defaultExternalAuthAction = ExternalAuthAction.CUSTOM_TABS //defaults to EXTERNAL_BROWSER
}

Call platform specific function on startup
On Android: supabase.handleDeeplinks(intent)
On IOS/MacOS: supabase.handleDeeplinks(url)

Then you can just login using OAuth:

supabase.gotrue.loginWith(Google)

Or open OTP links directly in your app.

PKCE Authentication flow

supabase-kt supports the PKCE authentication flow. To use it, you just have to change the flowType in the GoTrue configuration:

install(GoTrue) {
  flowType = FlowType.PKCE
}

That's it! If you already implemented deeplinks to handle OTPs and OAuth you don't have to change anything!


val supabase = createSupabaseClient(
    supabaseUrl = "https://xyzcompany.supabase.co",
    supabaseKey = "public-anon-key"
) {
    install(GoTrue)
    install(Postgrest)
    //install other modules
}

Fetch data

Perform a SELECT query on the table or view.

When calling a decode method, you have to provide a serializable class as the type parameter.
You can provide a Columns object to select specific columns.
You can provide a filter block to filter the results


val city = supabase.postgrest["cities"].select().decodeSingle<City>()

Insert data

When calling an insert method, you have to provide a serializable value.
By default, every time you run insert(), the client library will make a select to return the full record. This is convenient, but it can also cause problems if your policies are not configured to allow the select operation. If you are using Row Level Security and you are encountering problems, try setting the returning param to Returning.MINIMAL.


val city = City(name = "The Shire", countryId = 554)
supabase.postgrest["cities"].insert(city, returning = Returning.MINIMAL) //returning defaults to Returning.REPRESENTATION

Update data

update() should always be combined with a filter block to avoid updating all records.
When calling insert or update, you have to provide a serializable value in the function parameter.


supabase.postgrest["countries"].update(
    {
       Country::name setTo "Australia"
       //or
       set("name", "Australia")
    }
) {
   Country::id eq 1
   //or
   eq("id", 1)
}

Upsert data

Primary keys should be included in the data payload in order for an update to work correctly.
Primary keys must be natural, not surrogate. There are however, workarounds for surrogate primary keys.
If you need to insert new data and update existing data at the same time, use Postgres triggers.
When calling insert or update, you have to provide a serializable value in the function parameter.


val toUpsert = Message(id = 3, message = "foo", username = "supabot")
supabase.postgrest["messages"].insert(toUpsert, upsert = true)

Delete data

delete() should always be combined with a filter block to target the item(s) you wish to delete.
If you use delete() with filters and you have RLS enabled, only rows visible through SELECT policies are deleted. Note that by default no rows are visible, so you need at least one SELECT/ALL policy that makes the rows visible.


supabase.postgrest["cities"].delete {
   City::id eq 666
   //or
   eq("id", 666)
}

Call a Postgres function

You can call stored procedures as a "Remote Procedure Call".

That's a fancy way of saying that you can put some logic into your database then call it from anywhere. It's especially useful when the logic rarely changes - like password resets and updates.

When calling rpc with parameters, you have to provide a serializable value in the function parameter.


supabase.postgrest.rpc("hello_world")

Notes

Using filters

Filters allow you to only return rows that match certain conditions.

Filters can be used on select(), update(), and delete() queries.

You can use two different types for applying filters:

eq("country_id", 1)

And using a class property:

City::countryId eq 1

As you can see on the property syntax: the name of the countryId gets converted to country_id.

By default, this is done by converting camel case to snake case, but you can customize this by changing the PropertyConversionMethod in the Postgrest Config

If a database function returns a table response, you can also apply filters.


supabase.postgrest["cities"].select(columns = Columns.list("name", "country_id")) {
    City::name eq "The Shire"
    //or
    eq("name", "The Shire")
}

Notes

Column is equal to a value

Finds all rows whose value on the stated column exactly matches the specified value.


supabase.postgrest["cities"].select(columns = Columns.list("name", "country_id")) {
    City::name eq "The Shire"
    //or
    eq("name", "The Shire")
}

Column is not equal to a value

Finds all rows whose value on the stated column doesn't match the specified value.


supabase.postgrest["cities"].select(columns = Columns.list("name", "country_id")) {
    City::name neq "The Shire"
    //or
    neq("name", "The Shire")
}

Column is greater than a value

Finds all rows whose value on the stated column is greater than the specified value.


supabase.postgrest["cities"].select(columns = Columns.list("name")) {
   City::countryId gt 300
   //or
   gt("country_id", 300)
}

Column is greater than or equal to a value

Finds all rows whose value on the stated column is greater than or equal to the specified value.


supabase.postgrest["cities"].select(columns = Columns.list("name")) {
   City::countryId gte 300
   //or
   gte("country_id", 300)
}

Column is less than a value

Finds all rows whose value on the stated column is less than the specified value.


supabase.postgrest["cities"].select(columns = Columns.list("name")) {
   City::countryId lt 300
   //or
   lt("country_id", 300)
}

Column is less than or equal to a value

Finds all rows whose value on the stated column is less than or equal to the specified value.


supabase.postgrest["cities"].select(columns = Columns.list("name")) {
   City::countryId lte 300
   //or
   lte("country_id", 300)
}

Column matches a pattern

Finds all rows whose value in the stated column matches the supplied pattern (case sensitive).


supabase.postgrest["cities"].select(columns = Columns.list("name")) {
   City::name like "%la%"
   //or
   like("name", "%la%")
}

Column matches a case-insensitive pattern

Finds all rows whose value in the stated column matches the supplied pattern (case insensitive).


supabase.postgrest["cities"].select(columns = Columns.list("name")) {
   City::name ilike "%la%"
   //or
   ilike("name", "%la%")
}

Column is a value

A check for exact equality (null, true, false), finds all rows whose value on the stated column exactly match the specified value.

is_ and in_ filter methods are suffixed with _ to avoid collisions with reserved keywords.


supabase.postgrest["cities"].select(columns = Columns.list("name")) {
   City::name isExact null
   //or
   exact("name", null)
}

Column is in an array

Finds all rows whose value on the stated column is found on the specified values.


supabase.postgrest["cities"].select(columns = Columns.list("name")) {
   City::name isIn listOf("Rio de Janeiro", "San Francisco")
   //or
   isIn("name", listOf("Rio de Janeiro", "San Francisco"))
}

Column contains every element in a value


supabase.postgrest["cities"].select(columns = Columns.list("name")) {
   City::mainExports contains listOf("oil")
   //or
   contains("main_exports", listOf("oil"))
}

Greater than a range

Only relevant for range columns. Match only rows where every element in column is greater than any element in range.


  supabase.postgrest["reservations"].select {
     Reservation::during rangeGt ("2000-01-02 08:30" to "2000-01-02 09:30")
     //or
     rangeGt("during", "2000-01-02 08:30" to "2000-01-02 09:30")
  }

Data source

Response

Notes

Greater than or equal to a range

Only relevant for range columns. Match only rows where every element in column is either contained in range or greater than any element in range.


  supabase.postgrest["reservations"].select {
     Reservation::during rangeGte ("2000-01-02 08:30" to "2000-01-02 09:30")
     //or
     rangeGte("during", "2000-01-02 08:30" to "2000-01-02 09:30")
  }

Data source

Response

Notes

Less than a range

Only relevant for range columns. Match only rows where every element in column is less than any element in range.


  supabase.postgrest["reservations"].select {
     Reservation::during rangeLt ("2000-01-02 08:30" to "2000-01-02 09:30")
     //or
     rangeLt("during", "2000-01-02 08:30" to "2000-01-02 09:30")
  }

Data source

Response

Notes

Less than or equal to a range

Only relevant for range columns. Match only rows where every element in column is either contained in range or less than any element in range.


  supabase.postgrest["reservations"].select {
     Reservation::during rangeLte ("2000-01-02 08:30" to "2000-01-02 09:30")
     //or
     rangeLte("during", "2000-01-02 08:30" to "2000-01-02 09:30")
  }

Data source

Response

Notes

Mutually exclusive to a range

Only relevant for range columns. Match only rows where column is mutually exclusive to range and there can be no element between the two ranges.


  supabase.postgrest["reservations"].select {
     Reservation::during adjacent ("2000-01-02 08:30" to "2000-01-02 09:30")
     //or
     adjacent("during", "2000-01-02 08:30" to "2000-01-02 09:30")
  }

Data source

Response

With a common element

Only relevant for array and range columns. Match only rows where column and value have an element in common.


supabase.postgrest["issues"].select(columns = Columns.list("title")) {
   Issue::tags overlaps listOf("is:closed", "severity:high")
   //or
   overlaps("tags", listOf("is:closed", "severity:high"))
}

Data source

Response

Match a string

Only relevant for text and tsvector columns. Match only rows where column matches the query string in query.

For more information, see Postgres full text search.


supabase.postgrest["quotes"].select(columns = Columns.list("catchphrase")) {
   textSearch(column = "catchphrase", query = "'fat' & 'cat'", config = "english", type = TextSearchType.YOUR_TYPE)
}

Don't match the filter

Finds all rows that don't satisfy the filter.

.filterNot() expects you to use the raw PostgREST syntax for the filter names and values.


supabase.postgrest["countries"].select {
    filterNot("name", FilterOperation.IS, "")
}

Match at least one filter

Finds all rows satisfying at least one of the filters.


supabase.postgrest["countries"].select(columns = Columns.list("name")) {
    or {
        Country::id eq 2
        Country::name eq "Algeria"
        //or
        eq("id", 2)
        eq("name", "Algeria")
    }
}

Match the filter

filter() expects you to use the raw PostgREST syntax for the filter values.


supabase.postgrest["countries"].select {
   filter(column = "name", operator = FilterOperator.IN, value = "('Algeria', 'Japan')")
}

Data source

Response

Order the results

Order the query result by column.


supabase.postgrest["countries"].select(columns = Columns.list("id", "name")) {
   order(column = "id", order = Order.ASCENDING)
}

Data source

Response

Limit the number of rows returned

Limit the query result by count.


supabase.postgrest["countries"].select {
    limit(count = 20)
}

Data source

Response

Limit the query to a range

Limit the query result by from and to inclusively.


supabase.postgrest["countries"].select {
    range(1L..5L)
}

Data source

Response

Overview

The auth methods can be accessed via the Supabase GoTrue Auth client.


val supabase = createSupabaseClient(supabaseURL = "https://xyzcompany.supabase.co'", supabaseKey = "public-anon-key") { ... }
val gotrue = supabase.gotrue

Creates a new user.

By default, the user needs to verify their email address before logging in. To turn this off, disable Confirm email in your project.
Confirm email determines if users need to confirm their email address after signing up.
- If Confirm email is enabled, the return value is null and you will be logged in instead.
- If Confirm email is disabled, the return value is the user and you won't be logged in automatically.
When the user confirms their email address, they are redirected to the SITE_URL by default. You can modify your SITE_URL or add additional redirect URLs in your project.
To learn how to handle OTP links & OAuth refer to initializing
If signUpWith() is called for an existing confirmed user:
- If Confirm email is enabled in your project, an obfuscated/fake user object is returned.
- If Confirm email is disabled, the error message, User already registered is returned.

Sign in a user

Logs in an existing user.

Requires either an email and password or a phone number and password.

Sign in a user through OTP

Sends a OTP to the user's email or phone number.

Requires either an email or phone number.
This method is used for passwordless sign-ins where a OTP is sent to the user's email or phone number.
If the user doesn't exist, sendOtpTo() will signup the user instead. To restrict this behavior, you can set createUser to false.
If you're using an email, you can configure whether you want the user to receive a magiclink or a OTP.
If you're using phone, you can configure whether you want the user to receive a OTP.
The magic link's destination URL is determined by the SITE_URL.
See redirect URLs and wildcards to add additional redirect URLs to your project.
To learn how to handle OTP links & OAuth refer to initializing
Magic links and OTPs share the same implementation. To send users a one-time code instead of a magic link, modify the magic link email template to include {{ .Token }} instead of {{ .ConfirmationURL }}.

Sign in a user through OAuth

This method is used for signing in using a third-party provider.
Supabase supports many different third-party providers.
To learn how to handle OTP links & OAuth refer to initializing

Sign in a user through SSO

Before you can call this method you need to establish a connection to an identity provider. Use the CLI commands to do this.
If you've associated an email domain to the identity provider, you can use the SSO.withDomain() function in the loginWith method to start a sign-in flow.
In case you need to use a different way to start the authentication flow with an identity provider, you can use the SSO.withProviderId function. For example:
- Mapping specific user email addresses with an identity provider.
- Using different hints to identity the identity provider to be used by the user, like a company-specific page, IP address or other tracking information.
To learn how to handle OTP links & OAuth refer to initializing


  // You can extract the user's email domain and use it to trigger the
  // authentication flow with the correct identity provider.

  supabase.gotrue.loginWith(SSO.withDomain("company.com"))

  //the url was opened automatically, if you don't want that, provide a custom redirect url

Sign out a user

Logs out the current user.

In order to use the logout() method, the user needs to be signed in first.


supabase.gotrue.logout()

Send a password reset request

Sends a password reset request to the given email address.

The password reset flow consist of 2 broad steps: (i) Allow the user to login via the password reset link; (ii) Update the user's password.
The sendRecoveryEmail() only sends a password reset link to the user's email. To update the user's password, see modifyUser().
The user gets redirected back to your app, assuming you setup OTP handling

After the user has been redirected successfully, prompt them for a new password and call modifyUser():

supabase.gotrue.modifyUser {
    password = "1234567"
}


supabase.gotrue.sendRecoveryEmail(email = "example@email.com")

Verify and log in through OTP


supabase.gotrue.verifyEmailOtp(type = OtpType.Email.INVITE, email = "example@email.com", token = "token")

Notes

Retrieve a session

Returns the current session, or null if there is none.


val session = supabase.gotrue.currentSessionOrNull()

Retrieve a new session

This method will refresh the session whether the current one is expired or not.

This is done automatically, but can be disabled in the GoTrue config.


val session = supabase.gotrue.refreshCurrentSession()

Retrieve a user

This method gets the user object from the current session.
Fetches the user object from the database instead of local session.
Should be used only when you require the most current user data. For faster results, getCurrentSessionOrNull()?.user is recommended.


val user = supabase.gotrue.retrieveUserForCurrentSession(updateSession = true)

Notes

Update a user

Modifies the user data.

In order to use the modifyUser() method, the user needs to be signed in first.
By default, email updates sends a confirmation link to both the user's current and new email. To only send a confirmation link to the user's new email, disable Secure email change in your project's email auth provider settings.


val user = supabase.gotrue.modifyUser {
   email = "newEmail@email.com"
}

Notes

Send a password reauthentication nonce

This method is used together with modifyUser() when a user's password needs to be updated.
This method will send a nonce to the user's email. If the user doesn't have a confirmed email address, the method will send the nonce to the user's confirmed phone number instead.


supabase.gotrue.reauthenticate()

Notes

Resend an OTP

Resends a signup confirmation, email change or phone change email to the user.
Passwordless sign-ins can be resent by calling the sendOtpTo() method again.
Password recovery emails can be resent by calling the sendRecoveryEmail() method again.
This method will only resend an email or phone OTP to the user if there was an initial signup, email change or phone change request being made.

Set the session data

Changes the local session.

importSession() takes in a UserSession.
Refresh token rotation is enabled by default on all projects to guard against replay attacks.
You can configure the REFRESH_TOKEN_REUSE_INTERVAL which provides a short window in which the same refresh token can be used multiple times in the event of concurrency or offline issues.


supabase.gotrue.importSession(UserSession(accessToken = "token", refreshToken = "refresh", expiresIn = 2000, tokenType = "Bearer", user = null))

Notes

Listen to auth events

Listen to session changes.


supabase.gotrue.sessionStatus.collect {
    when(it) {
        is SessionStatus.Authenticated -> println(it.session.user)
        SessionStatus.LoadingFromStorage -> println("Loading from storage")
        SessionStatus.NetworkError -> println("Network error")
        SessionStatus.NotAuthenticated -> println("Not authenticated")
    }
}

Notes

Exchange an auth code for a session

Used when flowType is set to FlowType.PKCE in the GoTrue configuration.


supabase.gotrue.exchangeCodeForSession("34e770dd-9ff9-416c-87fa-43b31d7ef225")

Auth MFA

This section contains methods commonly used for Multi-Factor Authentication (MFA) and are invoked behind the supabase.gotrue.mfa namespace.

Currently, we only support time-based one-time password (TOTP) as the 2nd factor. We don't support recovery codes but we allow users to enroll more than 1 TOTP factor, with an upper limit of 10.

Having a 2nd TOTP factor for recovery frees the user of the burden of having to store their recovery codes somewhere. It also reduces the attack surface since multiple recovery codes are usually generated compared to just having 1 backup TOTP factor.

Enroll a factor

Enrolls a new factor.

Currently, totp is the only supported factorType. The returned id should be used to create a challenge.
To create a challenge, see mfa.createChallenge().
To verify a challenge, see mfa.verifyChallenge().
To create and verify a challenge in a single step, see mfa.createChallengeAndVerify().


val factor = supabase.gotrue.mfa.enroll(factorType = FactorType.TOTP)

// Use the id to create a challenge.
// The challenge can be verified by entering the code generated from the authenticator app.
// The code will be generated upon scanning the qr_code or entering the secret into the authenticator app.
val (id, type, qrCode) = factor.data //qrCode is a svg as a string
val (factorId, factorType, _) = factor

Create a challenge

Creates a challenge for a factor.

An enrolled factor is required before creating a challenge.
To verify a challenge, see mfa.verifyChallenge().


val challenge = supabase.gotrue.mfa.createChallenge(factorId = "34e770dd-9ff9-416c-87fa-43b31d7ef225")

Verify a challenge

Verifies a challenge for a factor.

To verify a challenge, please create a challenge first.


supabase.gotrue.mfa.verifyChallenge(
    factorId = "34e770dd-9ff9-416c-87fa-43b31d7ef225",
    challengeId = "4034ae6f-a8ce-4fb5-8ee5-69a5863a7c15",
    code = "123456",
    saveSession = true // this is set to true by default, but you can set it to false if you want to handle the session yourself
)

Create and verify a challenge

Creates and verifies a challenge for a factor.

An enrolled factor is required before invoking createChallengeAndVerify().
Executes mfa.createChallenge() and mfa.verifyChallenge() in a single step.


supabase.gotrue.mfa.createChallengeAndVerify(
    factorId = "34e770dd-9ff9-416c-87fa-43b31d7ef225",
    code = "123456",
    saveSession = true // this is set to true by default, but you can set it to false if you want to handle the session yourself
)

Unenroll a factor

Unenroll removes a MFA factor. A user has to have an AAL2 authentication level in order to unenroll a verified factor.


supabase.gotrue.mfa.unenroll(factorId = "34e770dd-9ff9-416c-87fa-43b31d7ef225")

Get Authenticator Assurance Level

Authenticator Assurance Level (AAL) is the measure of the strength of an authentication mechanism.
In Supabase, having an AAL of aal1 refers to having the 1st factor of authentication such as an email and password or OAuth sign-in while aal2 refers to the 2nd factor of authentication such as a time-based, one-time-password (TOTP).
If the user has a verified factor, the next field will return AuthenticatorAssuranceLevel.AAL2, else, it will return AuthenticatorAssuranceLevel.AAL1.


val (current, next) = supabase.gotrue.mfa.getAuthenticatorAssuranceLevel()

Auth Admin

Any method under the supabase.gotrue.admin namespace requires a service_role key.
These methods are considered admin methods and should be called on a trusted server. Never expose your service_role key in the browser.


val supabase = createSupabaseClient(
    supabaseUrl = "https://id.supabase.co",
    supabaseKey = "supabaseKey"
) {
    install(GoTrue) {
        autoLoadFromStorage = false
        alwaysAutoRefresh = false
    }
    // install other plugins (these will use the service role key)
}
supabase.gotrue.importAuthToken("service_role")

// Access auth admin api
val adminGoTrueClient = supabase.gotrue.admin

Retrieve a user

Fetches the user object from the database based on the user's id.

The retrieveUserById() method requires the user's id which maps to the auth.users.id column.


val user = supabase.gotrue.admin.retrieveUserById(uid = "f2a0b0a0-6b1a-4b7a-8f1a-4b7a6b1a8f1a")

List all users

Retrieves a list of users.

Defaults to return 50 users per page.


val users = supabase.gotrue.admin.retrieveUsers()

Create a user

Creates a new user.

To confirm the user's email address or phone number, set autoConfirm to true. Both arguments default to false.


val userWithEmail = supabase.gotrue.admin.createUserWithEmail {
    email = "example@email.com"
    password = "secretpassword"
    userMetadata {
        put("name", "John")
    }
}

Delete a user

Deletes a user from the database.

The deleteUser() method requires the user's ID, which maps to the auth.users.id column.


supabase.gotrue.admin.deleteUser(uid = "uid")

Send an email invite link

Sends an invite link to the user's email address.


supabase.gotrue.admin.inviteUserByEmail(
    email = "example@email.com",
    //optional:
    redirectTo = "https://example.com/redirect",
    data = buildJsonObject {
        put("custom", "value")
    }
)

Generate an email link

Generates email links and OTPs to be sent via a custom email provider.

Update a user

Updates the user data.


supabase.gotrue.admin.updateUserById(uid = "id") {
    email = "example@email.com"
}

List all factors for a user

Lists all factors associated to a user.


const factors = supabase.gotrue.admin.retrieveFactors(uid = "id")

Delete a factor for a user

Deletes a factor on a user. This will log the user out of all active sessions if the deleted factor was verified.


supabase.gotrue.admin.deleteFactor(uid = "id", factorId = "factor_id")

Invokes a Supabase Edge Function.

Invokes a Supabase Function. See the guide for details on writing Functions.

When invoking a function with parameters, you have to provide a serializable value in the function parameter.

Requires an Authorization header.


supabase.functions.invoke("function_name")

Subscribe to realtime changes in your database.

Realtime is disabled by default for new Projects for better database performance and security. You can turn it on by managing replication.
If you want to receive the "previous" data for updates and deletes, you will need to set REPLICA IDENTITY to FULL, like this: ALTER TABLE your_table REPLICA IDENTITY FULL;
When using a method with a generic type like track, broadcast or broadcastFlow, you have to provide a serializable class as the type parameter.


supabase.realtime.connect()

Unsubscribe from a channel

Unsubscribes and removes Realtime channel from Realtime client.

Removing a channel is a great way to maintain the performance of your project's Realtime service as well as your database if you're listening to Postgres changes.
Supabase will automatically handle cleanup 30 seconds after a client is disconnected, but unused channels may cause degradation as more clients are simultaneously subscribed.


val channel = supabase.realtime.createChannel("channelId") {
    //optional config
}
//...
supabase.realtime.removeChannel(channel)

Unsubscribe from all channels

Unsubscribes and removes all Realtime channels from Realtime client.

Removing channels is a great way to maintain the performance of your project's Realtime service as well as your database if you're listening to Postgres changes. Supabase will automatically handle cleanup 30 seconds after a client is disconnected, but unused channels may cause degradation as more clients are simultaneously subscribed.


supabase.realtime.removeAllChannels()

Retrieve all channels

Returns all Realtime channels.


val channels = supabase.realtime.subscriptions.entries

Create a bucket

RLS policy permissions required:
- buckets table permissions: insert
- objects table permissions: none
Refer to the Storage guide on how access control works


supabase.storage.createBucket(name = "icons", id = "icons") {
    public = true
    fileSizeLimit = 5.megabytes
}

Retrieve a bucket

RLS policy permissions required:
- buckets table permissions: select
- objects table permissions: none
Refer to the Storage guide on how access control works


val bucket = supabase.storage.retrieveBucketById(bucketId = "avatars")

List all buckets

RLS policy permissions required:
- buckets table permissions: select
- objects table permissions: none
Refer to the Storage guide on how access control works


val buckets = supabase.storage.retrieveBuckets()

Update a bucket

RLS policy permissions required:
- buckets table permissions: select and update
- objects table permissions: none
Refer to the Storage guide on how access control works


supabase.storage.updateBucket("cards") {
    public = false
    fileSizeLimit = 20.megabytes
    allowedMimeTypes(ContentType.Image.PNG, ContentType.Image.JPEG)
}

Delete a bucket

RLS policy permissions required:
- buckets table permissions: select and delete
- objects table permissions: none
Refer to the Storage guide on how access control works


supabase.storage.deleteBucket(bucketId = "icons")

Empty a bucket

RLS policy permissions required:
- buckets table permissions: select
- objects table permissions: select and delete
Refer to the Storage guide on how access control works


supabase.storage.emptyBucket(bucketId = "icons")

Upload a file

RLS policy permissions required:
- buckets table permissions: none
- objects table permissions: insert
Refer to the Storage guide on how access control works
Resumable uploads use a Disk cache by default to store the upload urls. You can customize that in the GoTrue config by changing the resumable.cache property.


val bucket = supabase.storage["avatars"]
bucket.upload("myIcon.png", byteArray, upsert = false)
//on JVM you can use java.io.File
bucket.upload("myIcon.png", file, upsert = false)

Download a file

RLS policy permissions required:
- buckets table permissions: none
- objects table permissions: select
Refer to the Storage guide on how access control works


val bucket = supabase.storage["avatars"]
val bytes = bucket.downloadAuthenticated("test.png")
//or on JVM:
bucket.downloadAuthenticatedTo("test.png", File("test.png"))

List all files in a bucket

RLS policy permissions required:
- buckets table permissions: none
- objects table permissions: select
Refer to the Storage guide on how access control works


val bucket = supabase.storage["avatars"]
val files = bucket.list()

Replace an existing file

RLS policy permissions required:
- buckets table permissions: none
- objects table permissions: update and select
Refer to the Storage guide on how access control works


val bucket = supabase.storage["avatars"]
bucket.update("myIcon.png", byteArray, upsert = false)
//on JVM you can use java.io.File
bucket.update("myIcon.png", file, upsert = false)

Move an existing file

RLS policy permissions required:
- buckets table permissions: none
- objects table permissions: update and select
Refer to the Storage guide on how access control works


val bucket = supabase.storage["avatars"]
bucket.move("icon1.png", "icon2.png")

Copy an existing file

RLS policy permissions required:
- buckets table permissions: none
- objects table permissions: insert and select
Refer to the Storage guide on how access control works


supabase.storage["test"].copy(from = "avatar.png", to = "avatar2.png")

Delete files in a bucket

RLS policy permissions required:
- buckets table permissions: none
- objects table permissions: delete and select
Refer to the Storage guide on how access control works


val bucket = supabase.storage["avatars"]
bucket.delete("test.png", "test2.png")

Create a signed URL

RLS policy permissions required:
- buckets table permissions: none
- objects table permissions: select
Refer to the Storage guide on how access control works


val bucket = supabase.storage["avatars"]
val url = bucket.createSignedUrl(path = "icon.png", expiresIn = 3.minutes)

Create signed URLs

RLS policy permissions required:
- buckets table permissions: none
- objects table permissions: select
Refer to the Storage guide on how access control works


val urls = supabase.storage["avatars"].createSignedUrls(20.minutes, "avata1.jpg", "avatar2.jpg")

Create signed upload URL

RLS policy permissions required:
- buckets table permissions: none
- objects table permissions: insert
Refer to the Storage guide on how access control works


val url = supabase.storage["avatars"].createSignedUploadUrl("avatar.png")

Upload to a signed URL

RLS policy permissions required:
- buckets table permissions: none
- objects table permissions: none
Refer to the Storage guide on how access control works


supabase.storage["avatars"].uploadToSignedUrl(path = "avatar.jpg", token = "token-from-createSignedUploadUrl", data = bytes)
//or on JVM:
supabase.storage["avatars"].uploadToSignedUrl(path = "avatar.jpg", token = "token-from-createSignedUploadUrl", file = File("avatar.jpg"))

Retrieve public URL

The bucket needs to be set to public, either via updateBucket() or by going to Storage on supabase.com/dashboard, clicking the overflow menu on a bucket and choosing "Make public"
RLS policy permissions required:
- buckets table permissions: none
- objects table permissions: none
Refer to the Storage guide on how access control works


val url = supabase.storage["public-bucket"].publicUrl("folder/avatar1.png")

Need some help?
Contact support
Latest product updates?
See Changelog
Something's not right?
Check system status

Kotlin Client Library

@supabase-community/supabase-kt

Installing

Add one or more modules to your project#

Add Ktor Client Engine to each of your Kotlin targets (required)#

Serialization#

Initializing

Create Supabase Client

OAuth and OTP link verification

Configure deeplink callbacks for Authentication

PKCE Authentication flow

Fetch data

Insert data

Update data

Upsert data

Delete data

Call a Postgres function

Using filters

Column is equal to a value

Column is not equal to a value

Column is greater than a value

Column is greater than or equal to a value

Column is less than a value

Column is less than or equal to a value

Column matches a pattern

Column matches a case-insensitive pattern

Column is a value

Column is in an array

Column contains every element in a value

Greater than a range

Greater than or equal to a range

Less than a range

Less than or equal to a range

Mutually exclusive to a range

With a common element

Match a string

Don't match the filter

Match at least one filter

Match the filter

Order the results

Limit the number of rows returned

Limit the query to a range

Overview

Create a new user

Sign in a user

Sign in a user through OTP

Sign in a user through OAuth

Sign in a user through SSO

Sign out a user

Send a password reset request

Verify and log in through OTP

Retrieve a session

Retrieve a new session

Retrieve a user

Update a user

Send a password reauthentication nonce

Resend an OTP

Set the session data

Listen to auth events

Exchange an auth code for a session

Auth MFA

Enroll a factor

Create a challenge

Verify a challenge

Create and verify a challenge

Unenroll a factor

Get Authenticator Assurance Level

Auth Admin

Retrieve a user

List all users

Create a user

Delete a user

Send an email invite link

Generate an email link

Update a user

List all factors for a user

Delete a factor for a user

Invokes a Supabase Edge Function.

Subscribe to channel

Unsubscribe from a channel