How to connect Supabase to Codex

1. 1. Enable Supabase in Metorial

   In your Metorial portal, enable the Supabase MCP server and sign in with the account that owns the data. Access stays governed by your team policies.

2. 2. Add the server and sign in

   The Codex CLI, IDE extension and ChatGPT desktop app share this config.

   Copy

   codex mcp add metorial --url <your-magic-mcp-url>
   codex mcp login metorial

3. 3. Check the connection

   Type /mcp in Codex to see Metorial and its Supabase tools.

• Invoke Database Function: Call a PostgreSQL function (RPC) through the Supabase REST API.
• Manage Project: Create, pause, restore, or delete a Supabase project.
• Manage Storage Objects: List, inspect, upload, update, download, move, copy, or delete files in Supabase Storage buckets.
• Manage Edge Functions: List, get, create, update, or delete Supabase Edge Functions.
• Manage Table Rows: Insert, update, upsert, or delete rows in a Supabase table using the auto-generated REST API.
• List Projects: List all Supabase projects accessible to the authenticated user.
• Manage Storage Buckets: List, get, create, update, empty, or delete storage buckets in a Supabase project.
• Run SQL Query: Execute a raw SQL query against a Supabase project's PostgreSQL database via the Management API.
• List Organizations: List all Supabase organizations accessible to the authenticated user.
• Get Auth Config: Retrieve or update the authentication configuration for a Supabase project.
• Manage Secrets: List, create, or delete secrets (environment variables) for a Supabase project.
• Manage Auth Users: List, get, create, update, or delete authentication users in a Supabase project.
• Get Project: Retrieve detailed information about a specific Supabase project, including its configuration, status, database host, and API keys.
• Query Table: Query rows from a Supabase table using the auto-generated REST API (PostgREST).
• Get Project Logs: Query Supabase project logs through the Management API.
• And 2 more on the Supabase MCP server page.

• Limit which Supabase tools Codex sees with enabled_tools and disabled_tools on the metorial server in config.toml.
• Set default_tools_approval_mode to auto, prompt, writes or approve. writes prompts only for tools that are not marked read-only.
• Type /mcp in the composer to see the connected servers.
• Override the approval behavior for a single Supabase tool with tools.<tool>.approval_mode.

Metorial is listed but tools are missing

Codex can connect without credentials and then see nothing. Run codex mcp login metorial to complete the OAuth sign-in.

Metorial times out at startup

Codex waits 10 seconds by default. Raise startup_timeout_sec under [mcp_servers.metorial] in ~/.codex/config.toml.

Long tool calls fail after a minute

The default tool timeout is 60 seconds. Raise tool_timeout_sec for the metorial server in config.toml.

Based on the Codex MCP documentation.