Skip to main content

Migrate from Supabase to NaijaBase

NaijaBase is a drop-in replacement for Supabase. Your existing code works without changes.

Why migrate?​

  • 🇳🇬 Data stored in Nigeria — NDPA 2023 compliant
  • ₦ Pay in Naira — no forex risk or dollar billing
  • 🏦 Required for CBN-regulated fintechs and Nigerian data residency
  • 📞 Local support in WAT timezone (UTC+1)

What's compatible​

FeatureStatus
auth.uid(), auth.role(), auth.email()✅ Full support
auth.users table✅ Same schema
Row Level Security (RLS) policies✅ Full support
PostgreSQL functions and triggers✅ Full support
CREATE EXTENSION✅ Supported
storage schema✅ Same schema
extensions schema✅ Available
Realtime subscriptions🔜 Coming soon

Step 1 — Export your Supabase schema​

In the Supabase dashboard go to Settings → Database → Database backups, or use pg_dump:

pg_dump --schema-only \
  "postgresql://postgres:[password]@db.[ref].supabase.co:5432/postgres" \
  > my_schema.sql

Step 2 — Create a NaijaBase project​

Go to app.naijabase.dev → New Project.

Step 3 — Run your schema​

Open the Database tab → SQL Editor. Paste your schema SQL and click Run (or press Ctrl+Enter).

auth.uid(), auth.users, and RLS policies all work exactly the same — no changes needed.

Step 4 — Export your data​

pg_dump --data-only \
  "postgresql://postgres:[password]@db.[ref].supabase.co:5432/postgres" \
  > my_data.sql

Step 5 — Import your data​

Paste the data SQL into the NaijaBase SQL Editor and run it.

For large datasets, connect directly with psql using the connection string from the Database tab:

psql "postgresql://[user]:[password]@102.223.38.91:5432/[database]" \
  < my_data.sql

Step 6 — Update your connection string​

// Before (Supabase)
const client = createClient(
  'https://xxx.supabase.co',
  'your-anon-key'
)

// After (NaijaBase — same code, Nigerian servers)
const client = createClient(
  'https://api.naijabase.dev/v1/YOUR_PROJECT_ID',
  'your-naijabase-anon-key'
)

Your API key is on the API tab of your project dashboard.

RLS example​

RLS policies using auth.uid() work identically on NaijaBase:

-- This Supabase policy works unchanged on NaijaBase
CREATE TABLE posts (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  user_id UUID DEFAULT auth.uid(),
  content TEXT
);

ALTER TABLE posts ENABLE ROW LEVEL SECURITY;

CREATE POLICY "users see own posts" ON posts
  USING (user_id = auth.uid());

CREATE POLICY "users insert own posts" ON posts
  FOR INSERT WITH CHECK (user_id = auth.uid());

Common Migration Issues​

Role errors: "role anon does not exist"​

NaijaBase automatically creates Supabase-compatible roles (anon, authenticated, service_role) in every project database. If you see this error on an older project, go to your project Settings tab and click Initialize Supabase roles.

Enum casting errors​

If you see: operator does not exist: my_enum = text

Cast your enum column to text for string comparisons:

-- Instead of:
WHERE status = 'active'

-- Use:
WHERE status::TEXT = 'active'
-- or use the enum type directly:
WHERE status = 'active'::my_enum_type

Function return type conflicts​

If you see: cannot change return type of existing function

Drop and recreate the function:

DROP FUNCTION IF EXISTS my_function CASCADE;
CREATE OR REPLACE FUNCTION my_function() ...

NaijaBase's SQL editor automatically handles this for you in batch mode — multi-statement scripts retry function conflicts with an automatic DROP.

Need help migrating?​

Email ofatokun@telecitytech.com — we offer free migration assistance for Business and Compliance Pro customers.