How to integrate Supabase with OpenAI Agent Builder

OpenAI's Agent Builder just changed the game. If you've been wanting to build AI agents that can actually interact with your databases without wrestling with APIs, this is it.
Now, let's make it even more powerful. We'll connect Supabase through Rube MCP. That means your agent can query databases, manage authentication, and handle storage operations, all without you writing a single line of backend code.

Sounds powerful? Let's dive in!

What is Agent Builder?

Agent Builder is OpenAI's tool for creating custom AI agents that can interact with external systems and perform actions beyond conversation. With Agent Builder, you can define tools, set up integrations, and deploy agents that automate workflows. Check out this blog post on how to work with Agent Builder.

The key limitation? Setting up integrations typically requires custom code and API management.

That's where MCP comes in.

What is Rube?

Rube is a universal MCP server implementation built on top of Composio’s tool infra. Instead of writing custom OAuth flows or managing API keys for every service, Rube provides a unified MCP interface for over 500 apps like Supabase, GitHub, Bitbucket, Jira, etc, that seamlessly works with OpenAI's Agent Builder out of the box.

App authentication, token refresh, and API calls are all handled automatically.

How to Add Supabase MCP to Agent Builder

Agent Builder comes with default MCP servers from OpenAI (Gmail, Drive, Outlook), but the real power is in adding custom servers. We'll use Rube MCP, which connects to 500+ apps, including Supabase. This lets you combine multiple apps to accomplish complex AI workflows.

Adding Rube MCP to Agent Builder

Step 1: Open MCP Servers

• In Agent Builder, click MCP Servers

• Click + Server

Step 2: Enter Server Details

• URL: https://rube.app/mcp

• Name: rube_mcp

• Authentication: API Key

Step 3: Get Your API Key

1. Go to rube.app

2. Click Install Rube

1. Open OpenAI Agent Builder tab

2. Click Generate Token

3. Copy the token

Step 4: Connect

• Paste the token in the API Key/Auth token field

• Click Connect

Step 5: Enable Supabase

• In Rube, go to Connected Apps

• Find Supabase and click Connect

• Enter your Supabase project URL and API key

• Complete the connection

  

Done! Your agent can now access Supabase through Rube MCP.

A Minimal Example: Basic Database Operations

Here's a simple example of an agent that can perform basic Supabase operations:

Agent Prompt Configuration

Example Interaction

User: "Add a new user to the users table with name 'John Doe' and email 'john@example.com'."

Agent: Uses Supabase MCP tool to insert record

Response: "I've successfully added John Doe to the users table with email john@example.com."

Overview of the Workflow

Click the "Preview" button in the top-right corner of the canvas. It will open a sidebar with a chat interface. You can test the workflow by typing in the chat input and seeing the results.

For deploying the agent, you can click the "Publish" button, give a name to your workflow, and click on the "Publish" button to deploy the workflow

Conclusion

Integrating Supabase MCP with Agent Builder transforms your AI agents from conversational assistants into database automation tools. With Rube handling authentication and API management, you can focus on building agent logic instead of wrestling with Supabase's API.

This setup works for simple operations (inserting records, querying data) and complex workflows (managing user authentication, handling storage operations, real-time subscriptions).

Next steps:

• Explore other Composio MCP integrations

• Check out the Rube documentation

• Join the Composio community for support

Your agents can now manage Supabase databases like a backend developer, no manual API calls required.

FAQs

1. How do I connect Supabase to Agent Builder using Rube MCP?

You first add the Rube MCP server inside Agent Builder using

https://rube.app/mcp and your API token.

Then in the Rube dashboard, enable the Supabase app and enter your Supabase project URL + service key. Once connected, your agent will be able to run Supabase queries directly through MCP without any client setup.

2. Do I still need the Supabase SDK if I’m using Rube MCP?

No, the MCP replaces the SDK layer.

You don’t need .env keys, no createClient() call, and no REST fetches.

The agent calls Supabase through Rube, and Rube handles authentication + execution.

3. Will the LLM hallucinate SQL or wrong table names?

No! MCP exposes your schema as metadata, so the agent pulls the table/column definitions from Rube. It is not generating SQL freeform, it is calling structured operations. So you avoid schema guessing and invalid queries.

4. Can the agent call Postgres functions, or only insert/select/update?

It can call both.

Supabase RPCs (Postgres functions) are supported through MCP, so anything you can do supabase.rpc() in code can also be triggered by the agent. This is useful when business logic lives inside the DB.