Arlet
Supabase

Connect Supabase to Codex

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

Enable Supabase in ArletCodex 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 Codex

  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

    In your terminal, run codex mcp add arlet --url https://mcp.arlet.dev/mcp/ to add Arlet as an MCP server.

  3. 3

    Codex detects OAuth support and opens your browser. Sign in with Google and click Allow on the consent screen.

  4. 4

    Once connected, both the CLI and the IDE extension can call Arlet tools (the configuration is shared).

If the browser does not open, run codex mcp login arlet to redo the authentication.

What you can do

Supabase tools that Codex 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