ignitionstack.pro v1.0 is out! Read the announcement →
Skip to Content

Supabase MCP Integration

We have configured the Supabase MCP (Model Context Protocol) server for Cursor. This allows the AI assistant to interact directly with your Supabase project.

Configuration

The configuration file is located at .cursor/mcp.json:

{
  "mcpServers": {
    "supabase": {
      "url": "https://mcp.supabase.com/mcp"
    }
  }
}

Add Figma MCP (Design)

To enable Figma tooling for agents, add the official Figma MCP server:

{
  "mcpServers": {
    "supabase": { "url": "https://mcp.supabase.com/mcp" },
    "figma": {
      "type": "http",
      "url": "https://mcp.figma.com/mcp"
    }
  }
}

Set your token in .env.local:

FIGMA_PERSONAL_ACCESS_TOKEN=your_figma_pat

The Figma server exposes tools to fetch files, frames, components and assets via the Figma API.

How to Use

  1. Ensure you are using a version of Cursor that supports MCP
  2. The supabase tool should now be available to the AI
  3. You may need to authenticate with Supabase when the AI first tries to use the tool

Manual Setup (if needed)

If the automatic configuration doesn’t work, you can manually add the Supabase MCP server in Cursor settings:

  1. Go to Cursor Settings > Features > MCP
  2. Add a new server:
    • Name: supabase
    • Type: SSE (Server-Sent Events)
    • URL: https://mcp.supabase.com/mcp

For local development with supabase start, you might need to use the local MCP URL provided by the CLI output.

Consolidated Scripts

We have consolidated all migration files into a single schema script for easier management.

1. Schema (docs/supabase/schema.sql)

Contains the complete database schema, including:

Usage: Run this script in the Supabase SQL Editor to set up the entire database structure.

2. Seed Data (docs/supabase/seed.sql)

Contains initial data for:

Usage: Run this script after the schema script to populate the database with initial data.

3. Rollback (docs/supabase/rollback.sql)

WARNING: This script drops ALL tables and functions. Use only if you need to completely reset the database.

Useful Resources