Supabase MCP Server for local development use

Using development AI agents like Cursor, Windsurf, Kiro, etc., currently, I find I need to provide the AI with context on how to use the Supabase CLI to handle certain tasks:

• Creating migrations (supabase migrations new <name>)
• Applying migrations locally (supabase migration up)
• Creating/editing functions (supabase functions new <name>)

It would be great if the MCP server supported these tasks for local use. It seems very odd to me that the MCP by default connects to your production instance, since most of what you'd want to use it for would be development work locally.

It would also be useful if the MCP could:

• Deploy functions from local to production
• Push migrations from local to production
• Sync/reset the local database
• Pull down migrations from production to replace/create them locally
• Describe table schemas for both local and prod
• Run SQL statements against the local database