Connect Supabase to AI: Let Claude and Cursor Query Tables, Auth, and Edge Functions

Why Connect Supabase to AI?

Your Supabase project holds everything: Postgres tables, auth users, storage buckets, Edge Functions, realtime subscriptions. When you're debugging in your editor and need to check a row, verify a user's auth state, or see if a function is erroring, you open the Supabase dashboard, navigate to the right section, and manually look it up.

With an MCP server pointed at your Supabase dashboard, AI agents can query your project directly. Check table data, auth state, function logs, and storage without switching windows.

What AI Agents Can Do With Supabase Access

Once connected, Claude, Cursor, or Codex can:

• Query tables — "Show me the last 10 orders for user X"
• Check auth — "Is this email already registered? What provider did they use?"
• Monitor functions — "What errors did the send-email function throw today?"
• Inspect storage — "What files are in the avatars bucket?"
• Check RLS policies — "What row-level security policies exist on the posts table?"
• Review schema — "What foreign keys does the orders table have?"

How It Works

1. Open DataFaucet and enter your Supabase project dashboard URL
2. Browse your project — click through Table Editor, Auth, Functions, Storage
3. DataFaucet captures the read operations as MCP tools
4. Deploy — your AI agents now have structured access to query Supabase

You're browsing the Supabase dashboard, not sharing database credentials or service role keys. DataFaucet captures HTTP interactions and replays them. Your connection strings and API keys stay where they are.

Example Queries

"What columns does the profiles table have?"
"How many users signed up in the last 7 days?"
"Show me the RLS policies on the documents table"
"What's in the error logs for the process-webhook function?"
"List all storage buckets and their sizes"

When This Saves Time

• Full-stack debugging — check database state while writing frontend code
• Auth troubleshooting — verify user status without opening dashboard
• RLS development — ask about existing policies while writing new ones
• Migration planning — get schema details while writing migrations

Security Model

DataFaucet connects through the Supabase dashboard web UI. Access is scoped to your dashboard login permissions. Read-only operations mean agents query but don't write. Your anon key, service role key, and connection string are never exposed to the MCP server.

Getting Started

Point DataFaucet at your Supabase project URL (supabase.com/dashboard/project/your-project). Browse through Table Editor, Auth, and Functions. Deploy. Your agents can now query Supabase project data from your terminal.

Create your Supabase MCP server →