The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { zodResolver } from '@hookform/resolvers/zod'
import { QUEUES_SCHEMA } from '@supabase/pg-meta'
import { useEffect, useState } from 'react'
import { useForm, useWatch } from 'react-hook-form'
import { toast } from 'sonner'
import { Button, Form, FormControl, FormField, FormItem, Switch } from 'ui'
import { Admonition } from 'ui-patterns/Admonition'
import ConfirmationModal from 'ui-patterns/Dialogs/ConfirmationModal'
import { FormItemLayout } from 'ui-patterns/form/FormItemLayout/FormItemLayout'
import { PageSection } from 'ui-patterns/PageSection'
import { z } from 'zod'
import { useIntegrationDetail } from '../Landing/useIntegrationDetail'
import { ConstrainedIntegrationTabScaffold } from '@/components/interfaces/Integrations/ConstrainedIntegrationTabScaffold'
import { DocsButton } from '@/components/ui/DocsButton'
import { FormHeader } from '@/components/ui/Forms/FormHeader'
import {
FormPanelContainer,
FormPanelContent,
FormPanelFooter,
} from '@/components/ui/Forms/FormPanel'
import { InlineLink } from '@/components/ui/InlineLink'
import { useProjectPostgrestConfigQuery } from '@/data/config/project-postgrest-config-query'
import { useProjectPostgrestConfigUpdateMutation } from '@/data/config/project-postgrest-config-update-mutation'
import { useQueuesExposePostgrestStatusQuery } from '@/data/database-queues/database-queues-expose-postgrest-status-query'
import { useQueuesQuery } from '@/data/database-queues/database-queues-query'
import { useDatabaseQueueToggleExposeMutation } from '@/data/database-queues/database-queues-toggle-postgrest-mutation'
import { useDatabaseQueuesVersionQuery } from '@/data/database-queues/database-queues-version-query'
import { useTableUpdateMutation } from '@/data/tables/table-update-mutation'
import { useTablesQuery } from '@/data/tables/tables-query'
import { FGA_PERMISSIONS, useAsyncCheckPermissionsV2 } from '@/hooks/misc/useCheckPermissionsV2'
import { useSelectedProjectQuery } from '@/hooks/misc/useSelectedProject'
import { DOCS_URL, IS_PLATFORM } from '@/lib/constants'
import { getErrorMessage } from '@/lib/get-error-message'
export const QueuesSettings = () => {
const { data: project } = useSelectedProjectQuery()
const { can: canUpdatePostgrestConfig } = useAsyncCheckPermissionsV2(
FGA_PERMISSIONS.PROJECT.DATA_API_CONFIG_WRITE
)
const { isInstalled } = useIntegrationDetail()
const [isToggling, setIsToggling] = useState(false)
const [rlsConfirmModalOpen, setRlsConfirmModalOpen] = useState(false)
const [isUpdatingRls, setIsUpdatingRls] = useState(false)
const formSchema = z.object({ enable: z.boolean() })
const form = useForm<z.infer<typeof formSchema>>({
resolver: zodResolver(formSchema),
mode: 'onChange',
defaultValues: { enable: false },
})
const { formState } = form
const enable = useWatch({ control: form.control, name: 'enable' })
const { data: queueTables } = useTablesQuery(
{
projectRef: project?.ref,
connectionString: project?.connectionString,
schema: 'pgmq',
},
{ enabled: isInstalled }
)
const tablesWithoutRLS =
queueTables?.filter((x) => x.name.startsWith('q_') && !x.rls_enabled) ?? []
// pgmq lowercases queue names when building q_/a_ relations, but pgmq.meta keeps
// the original casing. Look up each relname in list_queues() so we render the
// user-provided name rather than the lowercased relname slice.
const { data: queues } = useQueuesQuery(
{
projectRef: project?.ref,
connectionString: project?.connectionString,
},
{ enabled: isInstalled }
)
const queueDisplayName = (relname: string) => {
const stripped = relname.slice(2)
return queues?.find((q) => q.queue_name.toLowerCase() === stripped)?.queue_name ?? stripped
}
const { data: config, error: configError } = useProjectPostgrestConfigQuery(
{
projectRef: project?.ref,
},
{ enabled: isInstalled }
)
const {
data: isExposed,
isSuccess,
isPending: isLoading,
} = useQueuesExposePostgrestStatusQuery(
{
projectRef: project?.ref,
connectionString: project?.connectionString,
},
{ enabled: isInstalled }
)
const schemas = config?.db_schema.replace(/ /g, '').split(',') ?? []
const { data: pgmqVersion } = useDatabaseQueuesVersionQuery(
{
projectRef: project?.ref,
connectionString: project?.connectionString,
},
{ enabled: isInstalled }
)
const { mutateAsync: updateTable } = useTableUpdateMutation()
const onPostgrestConfigUpdateSuccess = () => {
if (enable) {
toast.success('Queues can now be managed through client libraries or PostgREST endpoints!')
} else {
toast.success(
'Queues can no longer be managed through client libraries or PostgREST endpoints'
)
}
setIsToggling(false)
form.reset({ enable })
}
const { mutate: updatePostgrestConfig } = useProjectPostgrestConfigUpdateMutation({
onSuccess: onPostgrestConfigUpdateSuccess,
onError: (error) => {
setIsToggling(false)
toast.error(`Failed to toggle queue exposure via PostgREST: ${error.message}`)
},
})
const { mutate: toggleExposeQueuePostgrest } = useDatabaseQueueToggleExposeMutation({
onSuccess: (_, values) => {
if (!IS_PLATFORM) return onPostgrestConfigUpdateSuccess()
if (project && config) {
if (values.enable) {
const updatedSchemas = schemas.concat([QUEUES_SCHEMA])
updatePostgrestConfig({
projectRef: project?.ref,
dbSchema: updatedSchemas.join(', '),
maxRows: config.max_rows,
dbExtraSearchPath: config.db_extra_search_path,
dbPool: config.db_pool,
})
} else {
const updatedSchemas = schemas.filter((x) => x !== QUEUES_SCHEMA)
updatePostgrestConfig({
projectRef: project?.ref,
dbSchema: updatedSchemas.join(', '),
maxRows: config.max_rows,
dbExtraSearchPath: config.db_extra_search_path,
dbPool: config.db_pool,
})
}
}
},
onError: (error) => {
setIsToggling(false)
toast.error(`Failed to toggle queue exposure via PostgREST: ${error.message}`)
},
})
const onToggleRLS = async () => {
if (!project) return console.error('Project is required')
setIsUpdatingRls(true)
try {
await Promise.all(
tablesWithoutRLS.map((x) =>
updateTable({
projectRef: project?.ref,
connectionString: project?.connectionString,
id: x.id,
name: x.name,
schema: x.schema,
payload: { id: x.id, rls_enabled: true },
})
)
)
toast.success(
`Successfully enabled RLS on ${tablesWithoutRLS.length === 1 ? tablesWithoutRLS[0].name : `${tablesWithoutRLS.length} queue${tablesWithoutRLS.length > 1 ? 's' : ''}`} `
)
setRlsConfirmModalOpen(false)
} catch (error) {
setIsUpdatingRls(false)
toast.error(`Failed to enable RLS on queues: ${getErrorMessage(error)}`)
}
}
const onSubmit = async (values: z.infer<typeof formSchema>) => {
if (!project) return console.error('Project is required')
if (configError) {
return toast.error(
`Failed to toggle queue exposure via PostgREST: Unable to retrieve PostgREST configuration (${configError.message})`
)
}
if (!pgmqVersion) {
return toast.error('Unable to retrieve PGMQ version. Please try again later.')
}
setIsToggling(true)
toggleExposeQueuePostgrest({
projectRef: project.ref,
connectionString: project.connectionString,
enable: values.enable,
pgmqVersion,
})
}
useEffect(() => {
if (isSuccess) form.reset({ enable: isExposed })
}, [isSuccess])
if (!isInstalled) {
return (
<div className="mx-auto w-full max-w-6xl px-6 xl:px-10">
<ConstrainedIntegrationTabScaffold>
<PageSection className="py-0">
<Admonition type="default" description="Queues is not installed." />
</PageSection>
</ConstrainedIntegrationTabScaffold>
</div>
)
}
return (
<>
<ConstrainedIntegrationTabScaffold className="flex flex-col gap-y-4">
<FormHeader
className="mb-0"
title="Settings"
description="Manage your queues via any client library or Data APIs endpoints"
/>
<Form {...form}>
<form id="pgmq-postgrest" onSubmit={form.handleSubmit(onSubmit)}>
<FormPanelContainer>
<FormPanelContent className="px-8 py-8">
<FormField
control={form.control}
name="enable"
render={({ field }) => (
<FormItem className="w-full">
<FormItemLayout
className="w-full"
layout="flex"
label="Expose Queues via PostgREST"
description={
<>
<p className="max-w-2xl">
When enabled, you will be able to use the following functions from the{' '}
<code>{QUEUES_SCHEMA}</code> schema to manage your queues via any
Supabase client library or PostgREST endpoints:
</p>
<p className="mt-2">
<code>send</code>, <code>send_batch</code>, <code>read</code>,{' '}
<code>pop</code>, <code>archive</code>, and <code>delete</code>
</p>
{!IS_PLATFORM ? (
<div className="mt-6 max-w-2xl">
When running Supabase locally with the CLI or self-hosting using
Docker Compose, you also need to update your configuration to expose
the <code>{QUEUES_SCHEMA}</code> schema.
<br />
<InlineLink
href={`${DOCS_URL}/guides/queues/expose-self-hosted-queues`}
>
Learn more
</InlineLink>
</div>
) : null}
</>
}
>
<FormControl>
<Switch
name="enable"
size="large"
disabled={
isLoading || tablesWithoutRLS.length > 0 || !canUpdatePostgrestConfig
}
checked={field.value}
onCheckedChange={(value) => field.onChange(value)}
/>
</FormControl>
</FormItemLayout>
{tablesWithoutRLS.length > 0 && (
<Admonition
type="default"
title="Existing Queues must have RLS enabled first before exposing via PostgREST"
className="mt-2"
>
<p className="m-0!">
Please ensure that the following {tablesWithoutRLS.length} queue
{tablesWithoutRLS.length > 1 ? 's' : ''} have RLS enabled in order to
prevent anonymous access.
</p>
<ul className="list-disc pl-6">
{tablesWithoutRLS.map((x) => {
return (
<li key={x.name}>
<code>{queueDisplayName(x.name)}</code>
</li>
)
})}
</ul>
<Button className="mt-3" onClick={() => setRlsConfirmModalOpen(true)}>
Enable RLS on{' '}
{tablesWithoutRLS.length === 1
? queueDisplayName(tablesWithoutRLS[0].name)
: `${tablesWithoutRLS.length} queues`}
</Button>
</Admonition>
)}
{formState.dirtyFields.enable && field.value === true && (
<Admonition type="warning" className="mt-2">
<p>
Queues will be exposed and managed through the{' '}
<code>{QUEUES_SCHEMA}</code> schema
</p>
<p className="text-foreground-light">
Database functions will be created in the <code>{QUEUES_SCHEMA}</code>{' '}
schema upon enabling. Call these functions via any Supabase client
library or PostgREST endpoint to manage your queues. Permissions on
individual queues can also be further managed through privileges and row
level security (RLS).
</p>
</Admonition>
)}
{formState.dirtyFields.enable && field.value === false && (
<Admonition type="warning" className="mt-2">
<p>
The <code>{QUEUES_SCHEMA}</code> schema will be removed once disabled
</p>
<p className="text-foreground-light">
Ensure that the database functions from the <code>{QUEUES_SCHEMA}</code>{' '}
schema are not in use within your client applications before disabling.
</p>
</Admonition>
)}
</FormItem>
)}
/>
</FormPanelContent>
<FormPanelFooter className="flex px-8 py-4 flex items-center justify-between">
<DocsButton
href={`${DOCS_URL}/guides/queues/quickstart#expose-queues-to-client-side-consumers`}
/>
<div className="flex items-center gap-x-2">
<Button
disabled={Object.keys(formState.dirtyFields).length === 0 || isToggling}
onClick={() => form.reset({ enable: false })}
>
Cancel
</Button>
<Button
variant="primary"
type="submit"
disabled={Object.keys(formState.dirtyFields).length === 0}
loading={isToggling}
>
Save changes
</Button>
</div>
</FormPanelFooter>
</FormPanelContainer>
</form>
</Form>
</ConstrainedIntegrationTabScaffold>
<ConfirmationModal
visible={rlsConfirmModalOpen}
title="Enable Row Level Security"
confirmLabel="Enable RLS"
confirmLabelLoading="Enabling RLS"
loading={isUpdatingRls}
onCancel={() => setRlsConfirmModalOpen(false)}
onConfirm={() => onToggleRLS()}
>
<p className="text-sm text-foreground-light">
Are you sure you want to enable Row Level Security for the following queues:
</p>
<ul className="list-disc pl-6">
{tablesWithoutRLS.map((x) => {
return (
<li key={x.id}>
<code>{queueDisplayName(x.name)}</code>
</li>
)
})}
</ul>
</ConfirmationModal>
</>
)
}