🗄️

Supabase

Work with Supabase Postgres, auth, and storage for app backends.

Category: Database
Difficulty: Medium
Rank: #7

Quick Configuration

Choose the setup that matches your environment.

Before You Start

  • Confirm you have the account, endpoint, or API key required for Supabase.
  • Start with minimum scopes and read-only access where possible.
  • Keep secrets in environment variables instead of hardcoding them in JSON.

This MCP does not have a tested config yet

Do not treat a generic endpoint placeholder as a real setup. Verify the official install path, command/url, env vars, and scopes first; if you already have sanitized config, run it through the checker.

Open config checker

Common Pitfalls & Fixes

  • ⚠️ Watch out: Service role keys vs anon keys, RLS policies, and environment separation.
  • 🔑 Always store API keys in environment variables, never hardcode them in JSON.
  • 🛡️ Start with read-only scopes if available to verify connection safely.

Example Prompts

Once connected, try these prompts to test capabilities:

  • List tables in the public schema and describe the most important ones.
  • Check RLS policies on the users table and explain the access rules.
  • Draft a safe migration plan for adding a new column with minimal downtime.

Verification Checklist

  • Run 1-2 real prompts to confirm Supabase returns usable data.
  • Check that error messages are clear enough for troubleshooting.
  • Document the required scopes, dependencies, and env vars for future reuse.