Fetch Supabase Postgres Schema String to Pass to OpenAI Assistant for SQL Queries

fetchSupabaseSchemaString.ts

/** Use this function to get a one-time dump of the database tables and columns to pass to OpenAI to come up with SQL queries.
 *  @link https://cookbook.openai.com/examples/how_to_call_functions_with_chat_models#executing-sql-queries
 */
const fetchSupabaseSchemaString = async () => {
  // make a get request to this route:
  const schemaResponse = await fetch(
    `${process.env.NEXT_PUBLIC_SUPABASE_URL}/rest/v1/?apikey=${process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY}`,
  )
  const schemaResponseData = await schemaResponse.json()
  const schemaDefinitions = schemaResponseData.definitions
  const schemaObject = Object.entries(schemaDefinitions).reduce(
    (acc, [tableName, tableDefinition]) => {
      const { properties, required } = tableDefinition
      const nextProperties = Object.entries(properties).reduce(
        (acc, [key, value]) => {
          return { ...acc, [key]: value.type }
        },
        {},
      )
      return {
        ...acc,
        [tableName]: { properties: nextProperties, required },
      }
    },
    {},
  )
  const schemaString = JSON.stringify(schemaObject)
  return schemaString.replaceAll('"', "'")
}