The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { safeSql } from '@supabase/pg-meta'
import { Query } from '@supabase/pg-meta/src/query'
import { useQuery } from '@tanstack/react-query'
import { vaultSecretsKeys } from './keys'
import { executeSql } from '@/data/sql/execute-sql-mutation'
import type { ResponseError, UseCustomQueryOptions, VaultSecret } from '@/types'
export const getVaultSecretsSql = () => {
const sql = new Query()
.from('secrets', 'vault')
.select(safeSql`id,key_id,name,description,secret,created_at,updated_at`)
.toSql()
return sql
}
export type VaultSecretsVariables = {
projectRef?: string
connectionString?: string | null
}
export async function getVaultSecrets(
{ projectRef, connectionString }: VaultSecretsVariables,
signal?: AbortSignal
) {
const sql = getVaultSecretsSql()
const { result } = await executeSql(
{ projectRef, connectionString, sql, queryKey: ['vault-secrets'] },
signal
)
return result as VaultSecret[]
}
export type VaultSecretsData = Awaited<ReturnType<typeof getVaultSecrets>>
export type VaultSecretsError = ResponseError
export const useVaultSecretsQuery = <TData = VaultSecretsData>(
{ projectRef, connectionString }: VaultSecretsVariables,
{
enabled = true,
...options
}: UseCustomQueryOptions<VaultSecretsData, VaultSecretsError, TData> = {}
) =>
useQuery<VaultSecretsData, VaultSecretsError, TData>({
queryKey: vaultSecretsKeys.list(projectRef),
queryFn: ({ signal }) => getVaultSecrets({ projectRef, connectionString }, signal),
enabled: enabled && typeof projectRef !== 'undefined',
...options,
})