FAQ de InsForge: base de datos, esquemas y edge functions

# lectura: parámetro ?schema=, o cabecera Accept-Profile
curl "$PROJECT_URL/api/database/records/mytable?schema=my_schema" \
  -H "Authorization: Bearer $TOKEN"

# escritura: envía Content-Profile
curl -X POST "$PROJECT_URL/api/database/records/mytable" \
  -H "Authorization: Bearer $TOKEN" \
  -H "Content-Profile: my_schema" \
  -H "Content-Type: application/json" \
  -d '{"name": "hello"}'

insforge db query "SELECT * FROM my_schema.mytable"

// lectura
const { data } = await client.database
  .schema('my_schema')
  .from('mytable')
  .select('*')

// escritura
await client.database
  .schema('my_schema')
  .from('mytable')
  .insert([{ name: 'hello' }])

// RPC
await client.database.schema('my_schema').rpc('my_function', { day: '2026-01-01' })

GRANT USAGE ON SCHEMA my_schema TO anon, authenticated;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA my_schema TO anon, authenticated;

-- desactivar RLS
ALTER TABLE public.mytable DISABLE ROW LEVEL SECURITY;

-- volver a activar RLS
ALTER TABLE public.mytable ENABLE ROW LEVEL SECURITY;

# puntual, mediante la CLI
insforge db query "ALTER TABLE public.mytable DISABLE ROW LEVEL SECURITY"

# o registrarlo como una migración
npx @insforge/cli db migrations new disable-rls-on-mytable
# coloca la sentencia ALTER TABLE en el archivo .sql generado y luego:
npx @insforge/cli db migrations up --all

import { createAdminClient } from '@insforge/sdk'

const admin = createAdminClient({
  baseUrl: process.env.INSFORGE_URL,
  apiKey: process.env.INSFORGE_API_KEY, // clave admin (ik_...), omite RLS
})

const { data, error } = await admin.storage
  .from('post-images')
  .upload('posts/post-123/cover.jpg', fileObject)

npx @insforge/cli login --user-api-key <your-user-api-key>
npx @insforge/cli link --project-id <your-project-id>

npx @insforge/cli db connection-string

postgresql://postgres:<password>@<appkey>.<region>.database.insforge.app:5432/insforge?sslmode=require

# Formato personalizado (recomendado: más pequeño y admite restauración en paralelo)
pg_dump -Fc your_local_db > local.dump

# ...o un archivo SQL plano
pg_dump your_local_db > local.sql

npx @insforge/cli db connection-string

# Volcado en formato personalizado
pg_restore --no-owner --single-transaction -d "postgresql://postgres:<password>@<appkey>.<region>.database.insforge.app:5432/insforge?sslmode=require" local.dump

# ...o un archivo SQL plano
psql --single-transaction "postgresql://postgres:<password>@<appkey>.<region>.database.insforge.app:5432/insforge?sslmode=require" < local.sql