The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { env } from "../../env.config.js"
/**
* Execute a SQL query against the local Supabase database via pg-meta.
*
* Uses the local Supabase API gateway to route to pg-meta, which executes
* the query against PostgreSQL using the default local connection.
*
* @param sql - The SQL query to execute
* @param params - Optional array of parameters for parameterized queries
* @returns Array of result rows
* @throws Error if the query fails
*/
export async function query<T>(sql: string, params?: Array<unknown>): Promise<Array<T>> {
const response = await fetch(`${env.API_URL}/pg/query`, {
method: 'POST',
headers: {
'Content-Type': 'application/json',
apikey: env.SERVICE_ROLE_KEY,
},
body: JSON.stringify({ query: sql, parameters: params }),
})
if (!response.ok) {
const error = await response.json()
throw new Error(`Database query failed: ${error.message || JSON.stringify(error)}`)
}
return response.json()
}