Connect Supabase - Serpy SEO

Use the Supabase integration if your website stores content in Supabase.

How to connect Supabase

Go to Settings.
Open Integrations.
Choose Supabase.
Click Connect.
Enter the required Supabase project details.
Add the required key or credentials.
Choose the table or content destination if needed.
Save the connection.
Test publishing with a draft article.

Enter the following code in the SQL Editor if you did not have a blog/posts table created yet:

 create table public.posts (
  id bigint generated by default as identity primary key,
  title text not null,
  slug text not null unique,
  content text,
  excerpt text,
  status text not null default 'draft',
  published_at timestamptz,
  created_at timestamptz not null default now(),
  updated_at timestamptz not null default now()
);

alter table public.posts enable row level security;

If your website will retrieve published posts directly from Supabase, also run this policy:

 create policy "Public can read published posts"
on public.posts
for select
to anon, authenticated
using (status = 'published');

If you get a connection access error that looks like this: ![Strategy Screen](/images/Supabase_Integration---connection-error.png) Then run this code in the SQL editor:

grant usage on schema public to service_role;
grant select on table public.posts to service_role;

Tips for Supabase

This integration is best for technical teams. Make sure your database table is prepared to receive article content. Use the correct permissions for publishing content.