You’ve probably heard a lot of hype around MCP - Model Context Protocol - and how it’s changing AI development. MCP is essentially the USB hub of the internet for AI agents, allowing them to connect with a whole range of different tools and actually use them.
I’ll cover connecting MCP to Cursor (the most popular AI coding assistant) and hooking it into Supabase (a popular database provider) to unlock full-stack application development from a single prompt. This is the exact setup I use for NZ client projects.
Setting Up Supabase
Head over to Supabase and set up a free account. Create a project and organisation - the free tier is more than enough for side projects. For this demo, I started with a completely blank project: no authentication, no tables, nothing.
Configuring MCP in Cursor
Follow the Supabase MCP guide (linked in the description) for Cursor setup. The steps are:
- Open Cursor and go to File → Preferences → Cursor Settings
- Navigate to the MCP tab
- Click “Add a new global server”
- Paste in the configuration from the Supabase guide
Getting Your Personal Access Token
Back in Supabase, go to the homepage, then Access Tokens. Generate a new token with a descriptive name like “MCP Cursor.” Important: keep this token private - it accesses your entire Supabase account, all projects and organisations.
Replace the placeholder in Cursor’s MCP configuration with your token and save. You should see a green light next to Supabase in your Cursor settings, indicating a successful connection.
Building a Login Page with MCP
Starting with a blank React project, I switched to Agent Mode in Cursor and entered: “Build out a basic login screen that hooks into Supabase using MCP in this current project.”
In about 3 to 5 minutes, it completed everything:
- Read the project files and directory structure
- Called the MCP tool to list Supabase projects and organisations
- Installed Supabase libraries and packages
- Created a login page with register functionality
- Set up a profiles table in Supabase
- Ran SQL code to link everything together
Testing the Result
The generated login page had both login and register forms. After registering a test user, the authentication appeared in Supabase’s dashboard with a unique ID, name, and email. The profiles table was also populated automatically.
Final Thoughts
MCP for Supabase inside Cursor is incredibly powerful for connecting your backend to your frontend. A single prompt can generate a complete user login page in under 3 minutes. You can continue building out your entire project this way, and it works remarkably well.
