2.2 Supabase Setup

From Zero to Database in 5 Minutes.

Follow this guide exactly to provision the memory for DealTrail. We are setting up a Postgres database in the cloud that will store every deal, agent, and document reference.

Step 1: Create the Project

We host our data in California (West US) because that is where our agents are. Latency matters.

1. Go to database.new (redirects to Supabase).

2. Sign in with GitHub.

3. Click "New Project".

4. Organization: Create a new one called "DealTrail Org."

5. Name: dealtrail-production.

6. Database Password: Generate a strong password. SAVE IT in your password manager immediately. You cannot see it again.

7. Region: Choose West US (California).

8. Click "Create New Project".

   • Wait ~2 minutes for the database to provision.

---

Step 2: Get your API Keys

We need these keys to connect n8n (The Brain) to Supabase (The Memory).

1. In the Supabase Dashboard, go to Settings (Cog icon at the bottom left) > API.

2. Project URL: Copy this. This is the address of your database.

3. anon / public Key: Copy this.

   • Context: This is safe for frontend apps. We won't use it much since we are headless, but keep it handy.

4. service_role / secret Key:

   • ⚠️ WARNING: This key bypasses all security. It is "God Mode."

   • Action: Copy this and mark it DANGER in your password manager.

   • Usage: We will use only this key inside n8n, because n8n needs full permission to read/write all deals.

---

Step 3: Disable "Confirm Email" (Crucial)

Since we are manually onboarding agents (Service-First model), we don't want to deal with email verification flows yet. We want to create users instantly.

1. Go to the Authentication tab (User icon on the left).

2. Click Providers > Email.

3. Confirm Email: Toggle OFF.

4. Secure Password Change: Toggle OFF (for now).

5. Click Save.

---

Step 4: The Handshake

Now, let's make sure n8n can talk to Supabase.

• Open your n8n instance.

• Go to Credentials > New.

• Search for Supabase.

• Host: Paste your Project URL.

• Key: Paste your service_role key (The DANGER key).

• Click Connect.

If it says "Connected," you have successfully wired the Brain to the Memory.

---

Next Up: Now that the server is running, we need to tell it how to think. We need to create the tables for Agents, Deals, and Stakeholders.