DEV Community

curatedmcp for CuratedMCP

Posted on • Originally published at curatedmcp.com

Supabase MCP Server: Query your database and manage auth through Claude

Install guide and config at curatedmcp.com

Supabase MCP Server: Query your database and manage auth through Claude

The Supabase MCP Server is the official bridge between AI agents and your Supabase project. Instead of switching between Claude and your dashboard, you can now ask your AI assistant to query tables, create schemas, manage authentication, deploy Edge Functions, and handle storage—all through natural language. It's the kind of integration that saves context switching and turns your AI into a genuine database assistant.

What It Does

This MCP server unlocks direct database access for Claude, Cursor, and other AI agents. You can execute SQL queries, create or alter tables, manage Row Level Security policies, invoke Edge Functions, inspect database performance, and generate TypeScript types from your schema—without leaving your chat interface.

The server handles the full Supabase stack: PostgreSQL databases, authentication user management, Edge Function deployment, and storage bucket operations. It also lets you manage environment variables and project settings programmatically. Because it's maintained by the Supabase team directly, it stays aligned with new platform features as they ship.

The most practical benefit? You can describe what you want in plain English—"Add a users table with email and name columns, then set up RLS so users only see their own data"—and let Claude handle the SQL and configuration.

How to Install

npx -y @supabase/mcp-server-supabase@latest
Enter fullscreen mode Exit fullscreen mode

Add to your Claude Desktop claude_desktop_config.json:

{
  "mcpServers": {
    "supabase-mcp-server": {
      "command": "npx -y @supabase/mcp-server-supabase@latest",
      "env": {
        "SUPABASE_ACCESS_TOKEN": "your-access-token-here",
        "SUPABASE_PROJECT_REFERENCE_ID": "your-project-id-here"
      }
    }
  }
}
Enter fullscreen mode Exit fullscreen mode

Generate your access token at app.supabase.com → Account → Access Tokens.

Real-World Use Cases

  • Rapid schema iteration: Ask Claude to design your database schema, create tables with appropriate indexes, and set up RLS policies—then review and deploy in seconds.
  • Debugging performance issues: Query slow-running queries, inspect index coverage, and get Claude's suggestions for optimization without leaving your terminal.
  • Automating auth workflows: Have Claude list authentication users, update provider settings, or generate migration scripts for user management without manual API calls.

Full install guides for Claude Desktop, Cursor, Windsurf, and more at CuratedMCP.

Top comments (0)