Arlet
Supabase

Connect Supabase to Copilot Studio

Search, read and write Supabase from Copilot Studio. Arlet links the two through one MCP connection and takes care of keys and authentication.

Enable Supabase in ArletCopilot Studio connection guide (docs)

Arlet makes Supabase's official MCP server available from the AI client you already use. Signing in completes the connection.

The AI can manage projects, run SQL and migrations, read logs and advisories, deploy Edge Functions and search the docs. Write tools are included, so keep tool-call confirmation enabled in your AI client when working against production projects. The available tools are those provided by Supabase's official server.

How to connect Supabase to Copilot Studio

  1. 1

    In the Arlet dashboard, open Integrations → Add an integration and choose Supabase. Sign in with Link Supabase, name the connection and click Create.

  2. 2

    Sign in to Copilot Studio with your work account, create a new agent (or open an existing one), and in the Build tab choose Tools → + → Add → Model Context Protocol (MCP) in the right panel.

  3. 3

    In the Add MCP server form, enter "Arlet" as the Server name, https://mcp.arlet.dev/mcp/ as the Server URL, choose OAuth 2.0 for Authentication and "Dynamic (detected)" for Configuration type, then click Add. No Client ID / Secret is needed.

  4. 4

    On the Select a connection screen, choose Create new connection → Create, then sign in with Google on the Arlet authorization screen and click Allow. Click Add to attach the tool to the agent, then Publish to use it from Microsoft 365 Copilot.

Requires a Microsoft work account and a Copilot Studio license (or trial). MCP is available only for agents using generative orchestration and not in Copilot Studio in Teams.

What you can do

Supabase tools that Copilot Studio can call.

  • list_projects

    List the projects in your organization.

  • get_project

    Get a project's details.

  • list_tables

    List tables.

  • execute_sql

    Run SQL.

  • apply_migration

    Apply a migration.

  • list_migrations

    List applied migrations.

  • list_extensions

    List enabled extensions.

  • query_logs

    Query project logs.

  • get_advisors

    Get security and performance advisories.

  • generate_typescript_types

    Generate TypeScript types from the schema.

  • list_edge_functions

    List Edge Functions.

  • deploy_edge_function

    Deploy an Edge Function.

  • get_project_url

    Get the project's API URL.

  • get_publishable_keys

    Get the publishable API keys.

  • search_docs

    Search Supabase's documentation.

The tool list follows what Supabase's official MCP server provides and may change.

Example uses

  • Investigate data

    Inspect the schema, write and run aggregation queries, and explain the results.

  • Change the schema

    Write a migration from requirements, apply it and regenerate TypeScript types.

  • Check logs and advisors

    Search error logs and combine them with security and performance advisories into an action list.

  • Update an Edge Function

    Fetch a function's code, fix it and deploy.

Prompts you can use as-is

  • Count new sign-ups in the users table per day for the last 7 days
  • Write and apply a migration adding a status text column with default 'pending' to orders
  • Look through the last hour of API error logs and summarize likely causes
  • List the security advisor findings and explain how to fix the highest-priority ones

Use Supabase with other AI clients