Cursor uses MCP can only read supabase, says it is read-only, no editing permissions

[Mason-zy]

I understand that you want to enable write operations for the MCP tool, but I need to clarify: the MCP Supabase query tool (mcp_supabase_query) is provided as a built-in feature, and its read-only mode is a security feature that is hardcoded within the tool. This is not an option that can be modified through a configuration file or settings.
This restriction is intentional, mainly for the following reasons:
Security considerations: prevent accidental or harmful data modification operations
Avoiding permission abuse: ensure that database operations follow the correct permission controls
Prevent Data Corruption: Reduce the risk of data corruption due to incorrect operations
To enable write operations, you have the following alternative options:
Use frontend code:
You can use the Supabase client in the frontend code to perform write operations
This can modify data through the normal process and permission control of the application
Use Supabase Studio:
Access: https://app.supabase.com
Select your project
Execute write operations using the SQL editor
Create a database migration script:
Create SQL migration scripts in the /db/migrations directory
Execute these scripts using the Supabase CLI or other tools
Using a custom API:
Create Supabase Edge Functions or REST API
Execute database write operations via API calls
Due to MCP restrictions, direct modifications are not possible, I suggest using Supabase Studio for immediate data operations and implementing routine data operation features through frontend code.
What alternative solution do you want me to implement? I can provide specific steps and code examples.

But the official says it can be modified：
Next steps#
You are now connected to Supabase using MCP! You can now interact with the database using natural language commands. Try having your AI tool query your database, create new tables, or execute other SQL operations.

[GaryAustin1]

No one seems to have generated an issue, so I created one.
#34405

[Mattchew86]

The smithery api allows write. Execute postgres: https://smithery.ai/server/%40alexander-zuev%2Fsupabase-mcp-server/tools

"Due to MCP restrictions, direct modifications are not possible, I suggest using Supabase Studio for immediate data operations and implementing routine data operation features through frontend code."

[Crytojez]

Hi guys,
was there any fix to this? Extremely frustrating; I have looked and tried everything. Please let me know if you figure out ho to get it off of read only and into write as well.

[GaryAustin1]

The Supabase MCP server is read only. From the repository:

Some users recommend using a different MCP server: https://youtu.be/Aw2JqyshNsg?t=425