Skip to content

Supabase

Integration · Data and no-code

Supabase: the database and logins behind a custom portal

Supabase is a hosted Postgres database with logins, file storage and live updates built in. We use it behind custom portals and AI agents when a business outgrows spreadsheets: customers and staff log in, see only their own records, and agents read and write through the same rules.

What Supabase is, in business terms

Most business apps need the same foundations: somewhere to store records, a way for people to log in, rules about who can see what, a place for files and a way to show changes as they happen. Supabase bundles these around a standard Postgres database, so a custom build can spend its time on your workflow rather than on plumbing.

Supabase building blocks and what they are used for
Building blockTypical business use
Postgres databaseClients, bookings, orders, invoices and the history of every change.
AuthLogins for staff, customers or parents, with email, magic links or social sign-in.
Row level securityRules inside the database such as “a parent sees only their own child’s records”.
StorageUploaded documents, photos and signed forms, with access rules.
RealtimeLive updates: a new booking appearing on the front-desk screen, presence, or messages between devices.
Edge FunctionsSmall pieces of server code, for example to receive a webhook from Stripe or WhatsApp.

Because it is ordinary Postgres underneath, your data is not locked into a proprietary format. It can be exported, reported on with standard tools or moved to another Postgres host later.

When does a business need this rather than a spreadsheet?

A spreadsheet or Airtable base is fine while only your team touches the data. The case for a real database usually starts when outsiders need to log in: customers checking an order, parents seeing attendance, contractors uploading timesheets. At that point you need each person to see only their own rows, enforced by the system rather than by hiding columns.

Typical builds on this foundation include a customer onboarding portal that collects documents, an attendance tracking app used on a phone at the pitch side, or a back office where an agent logs every payment reconciliation it suggests for a person to confirm. See operations platforms for how these come together.

How AI agents use the database safely

An agent that works for a logged-in customer should act with that customer’s permissions, so the same row level security rules apply to it as to the app. If the agent is tricked into asking for someone else’s records, the database refuses. Background agents that need wider access, such as a nightly report, run on the server with a secret key and a narrow job.

Postgres can also store embeddings with the pgvector extension, so an agent’s searchable knowledge can sit in the same database as the records, under the same access rules. See AI agent security.

Before you connect Supabase: a checklist.

Checklist

Connecting Supabase safely

Setup, regions and data protection

  1. Create the Supabase organisation and project in your business’s name, with at least two owners from your side.
  2. Choose a region. Supabase offers specific regions in the EU, including Ireland and Frankfurt; choose a specific region rather than a general one if you need data to stay in a particular country.
  3. Agree the plan: backups, point-in-time recovery and support levels vary by plan, so check them against how critical the system is.
  4. Write the access policies and test them with real roles before launch.

Choosing an EU region decides where data is stored, but it is not a compliance certificate by itself. You still need a data processing agreement, retention rules and your own records. Check specifics with your advisor; AI agents and GDPR covers the questions to ask.

Limits and trade-offs

  • It is a developer platform. Your team will not edit it like a spreadsheet, so plan an admin screen for everyday changes.
  • Security depends on the policies being written correctly. Mistakes are silent until tested.
  • Plan limits on database size, storage and connections apply; check your plan as you grow, and watch for slow queries as tables get larger.
  • Supabase is a managed service. If you need full control of hosting, Postgres can be self-hosted, at the cost of running it yourself.

None of these are reasons to avoid it, but they are reasons to agree who looks after the project once it is live: who applies updates, who watches the usage, who restores a backup and who is told when something fails. Write those answers into the handover document so they survive a change of staff or supplier.

Common questions

Do we own the data if it is in Supabase?

Yes, provided the project sits in your organisation, not your developer’s. Because the database is standard Postgres, you can take a full export at any time and run it elsewhere. Ask for the project to be set up under your account from day one, with your own people as owners, and for the access keys to be documented.

Is Supabase suitable for an Irish business under GDPR?

It can be. You can choose an EU region, including Ireland, which keeps your stored data in that region. GDPR compliance also depends on your processing agreement with Supabase, the sub-processors involved, your retention rules and how the app is built. Those are questions for your advisor, but the technical options are there.

How is this different from Firebase?

Both are hosted backends with logins, storage and live updates. The main difference is that Supabase is built on a relational Postgres database, which suits business records with lots of relationships, such as clients, bookings, invoices and staff, and makes reporting with ordinary SQL straightforward. Either can be the right choice depending on the app.

Bring us the task.

Tell us what happens today, which tools are involved and where it goes wrong. On a free 30-minute review, we’ll work out whether an agent, an automation or neither is the right fix, and what a sensible first release would be.

Start a project.

Two people on a sofa with laptops, planning a project beside a whiteboard of sticky notes

Book a call or send us a message. We read everything.

tash@neu.ie
Working with teams in Ireland and worldwide.

Get in touch

Free 30-minute AI review.