# Supabase for AI agents. Managed auth, ready-made tools.

> List projects, run SQL, read logs and edge functions, and generate types in your users' Supabase projects.

- Page: https://www.agent200.com/tools/supabase/
- Category: Developer tools
- Authentication: Managed OAuth
- Identifier in code: `supabase`
- Create an API key: https://agent200.com/platform/apikeys/
- Updated: 2026-11-15

## Instructions for AI agents

Connector: Supabase, through Agent200. In code: "supabase".
What it does: List projects, run SQL, read logs and edge functions, and generate types in your users' Supabase projects.
Page: https://www.agent200.com/tools/supabase/

1. Get an Agent200 API key. If the developer has none, send them to https://agent200.com/platform/apikeys/ and ask them to choose "Create an API key". Read the key from the AGENT200_API_KEY environment variable. Never ask for it in chat, and never write it into code, prompts or logs.
2. Sign-in is managed OAuth. Each end user approves access once, on Supabase's own page, through the authorization link Agent200 returns. Never ask a user for a Supabase password or token in chat.
3. Give every request a stable id for the end user. Agent200 uses only that user's own connection.
4. Read tools: supabase_list_projects, supabase_run_read_only_query, supabase_list_functions, supabase_get_logs, supabase_get_typescript_types. Write tools: supabase_run_query. Name "supabase" in the tools of a request; the model decides which tool to call.
5. Stay within the project's settings. If a tool is turned off or a call is refused, tell the user. Do not work around it.
6. Before a write, confirm with the user, unless they asked for that exact change.
7. For setup with a specific framework, follow its guide:
   https://www.agent200.com/tools/supabase/framework/claude/
   https://www.agent200.com/tools/supabase/framework/chatgpt/
   https://www.agent200.com/tools/supabase/framework/claude-code/
   https://www.agent200.com/tools/supabase/framework/muse/
   https://www.agent200.com/tools/supabase/framework/grok-bot/
   https://www.agent200.com/tools/supabase/framework/openai-dots/
   https://www.agent200.com/tools/supabase/framework/claude-duet/
   https://www.agent200.com/tools/supabase/framework/hermes-agent/
   https://www.agent200.com/tools/supabase/framework/openclaw/

The code on the connector page is a conceptual example of the SDK. SDK reference: https://docs.igpt.ai/

## About

With the Supabase connector, your agent works with each user's own Supabase projects through Agent200: it lists projects, runs SQL against the database, reads logs and edge functions, and generates TypeScript types from the schema. Every user connects their own account through managed OAuth.

Supabase is a Postgres development platform that adds authentication, storage, edge functions and realtime to every project's database.

## Supabase tools

- **List projects** (`supabase_list_projects`, read): List the projects the connected user can access.
- **Run a read-only query** (`supabase_run_read_only_query`, read): Run a SQL query that can read but never change the database.
- **Run a SQL query** (`supabase_run_query`, write): Run a SQL statement, including ones that change data or schema.
- **List edge functions** (`supabase_list_functions`, read): List a project's edge functions and their status.
- **Get logs** (`supabase_get_logs`, read): Read a project's logs for a time range.
- **Generate TypeScript types** (`supabase_get_typescript_types`, read): Generate TypeScript types from the database schema.

## Limits you can set

**Turn single tools on or off.** Keep `supabase_run_read_only_query` and switch off `supabase_run_query` so your agent can read the database but never change it.

**Restrict what the agent reaches.** Choose the endpoints and scopes a project may use. A call outside them is refused.

## Get started

### Step 1: Set up the SDK

Add the Agent200 SDK to the codebase you already have and authenticate with your API key. The key covers every connector enabled for the project.

File `agent.js`:

```js
// One Agent200 API key covers every connector enabled for the project.
const agent200 = new Agent200({
  apiKey: process.env.AGENT200_API_KEY,
});
```

(Conceptual example of the Agent200 SDK.)

### Step 2: Let your user connect Supabase

Each end user authorizes their own Supabase account once. Agent200 runs the OAuth flow, handles the callback, stores the tokens and refreshes them.

File `connect.js`:

```js
// Each end user authorizes their own Supabase account, once.
const connection = await agent200
  .user("user_123")
  .connect("supabase");

if (connection.authorizationUrl) {
  // Show this link to your user; Agent200 handles the rest.
  console.log(connection.authorizationUrl);
}
```

(Conceptual example of the Agent200 SDK.)

### Step 3: Run with the Supabase tools

Name the user, the model and the tools. The model decides which Supabase tools to call, and Agent200 executes them with that user's connection.

File `run.js`:

```js
const result = await agent200
  .user("user_123")
  .run({
    model: "openai/gpt-5.6-sol",
    input: "How many users signed up yesterday",
    tools: ["supabase"],
  });

console.log(result.output);
```

(Conceptual example of the Agent200 SDK.)

## Sign-in and permissions

**Who signs in.** Each of your users, once, on Supabase's own page. You never see or store their Supabase credentials.

**What access is requested.** The user picks the organization to connect, and Supabase shows the scopes requested, such as reading projects or reading and writing the database.

## Example requests

- "How many users signed up yesterday"
- "Show me the errors in the API logs from the last hour"
- "Generate TypeScript types for my production project"
- "Which edge functions are deployed on staging"

## Guides: Supabase with your AI framework

- [Supabase + Claude](https://www.agent200.com/tools/supabase/framework/claude.md): Connect Supabase to Claude through Agent200's MCP server: managed OAuth, ready-made tools and one API key.
- [Supabase + ChatGPT](https://www.agent200.com/tools/supabase/framework/chatgpt.md): ChatGPT cannot send an API key to a custom MCP server, so this guide builds Supabase into your own agent with OpenAI's models and the Agent200 SDK.
- [Supabase + Claude Code](https://www.agent200.com/tools/supabase/framework/claude-code.md): Have Claude Code build a Supabase agent with the Agent200 SDK: managed OAuth, ready-made tools and one API key.
- [Supabase + Muse](https://www.agent200.com/tools/supabase/framework/muse.md): Connect Supabase to Muse through Agent200's MCP server: managed OAuth, ready-made tools and one API key.
- [Supabase + Grok Bot](https://www.agent200.com/tools/supabase/framework/grok-bot.md): Connect Supabase to Grok Bot through Agent200's MCP server: managed OAuth, ready-made tools and one API key.
- [Supabase + OpenAI Dots](https://www.agent200.com/tools/supabase/framework/openai-dots.md): Dots cannot send an API key to a custom MCP server, so this guide builds an always-on Supabase agent with OpenAI's models and the Agent200 SDK.
- [Supabase + Claude Duet](https://www.agent200.com/tools/supabase/framework/claude-duet.md): Connect Supabase to Claude Duet through Agent200's MCP server: managed OAuth, ready-made tools and one API key.
- [Supabase + Hermes Agent](https://www.agent200.com/tools/supabase/framework/hermes-agent.md): Connect Supabase to Hermes Agent through Agent200's MCP server: managed OAuth, ready-made tools and one API key.
- [Supabase + OpenClaw](https://www.agent200.com/tools/supabase/framework/openclaw.md): Connect Supabase to OpenClaw through Agent200's MCP server: managed OAuth, ready-made tools and one API key.

## FAQ

### Who handles the Supabase OAuth flow and the tokens?

Agent200. It runs the authorization, handles the callback on its own domain, stores the tokens and refreshes them. You do not build or maintain an OAuth integration for Supabase.

### Does my agent act as the end user?

Within what that user authorized, yes. Every request names an end user, and Agent200 uses only that user's Supabase connection, never another user's. It cannot reach anything the user or Supabase has not authorized.

### Can I limit what my agent can do in Supabase?

Yes. You choose which services, endpoints and authorization scopes are allowed in your Agent200 configuration, and the agent works only within them.

## Related connectors

- [GitHub](https://www.agent200.com/tools/github.md): Read repositories and work with issues and pull requests as the connected user.
- [GitLab](https://www.agent200.com/tools/gitlab.md): Review merge requests, file issues, read code and check pipelines in your users' GitLab projects.
- [Bitbucket](https://www.agent200.com/tools/bitbucket.md): List and open pull requests, comment, read code and check pipelines in your users' Bitbucket workspaces.
- [Jira](https://www.agent200.com/tools/jira.md): Search, create and transition Jira issues for the connected user.

---

Agent200: https://www.agent200.com/ · API keys: https://agent200.com/platform/apikeys/ · Docs: https://docs.igpt.ai/
