Supabase MCP Server

A powerful Model Context Protocol (MCP) server that provides full administrative control over your Supabase PostgreSQL database through both Cursor's Composer and Codeium's Cascade. This tool enables seamless database management with comprehensive features for table operations, record management, schema modifications, and more.

Table of Contents

• Prerequisites

• Quick Start

• Integrations

• Features

• Usage

• Security Notes

• Troubleshooting

• Contributing

• License

Prerequisites

• Node.js >= 16.x

• npm >= 8.x

• A Supabase project with:

• Cursor IDE or Codeium's Cascade (for paying users)

Quick Start

Installation

Configuration

1. Install dependencies and build the project:

2. In Cursor's MCP settings, add the server with this command:Replace:

Integrations

Cursor MCP Integration

Setting up in Cursor

1. Open Cursor Settings > Features > MCP

2. Click the "+ Add New MCP Server" button

3. Fill in the modal form:

4. Build the project first:

5. Get your Node.js path:

6. Add the server command:Replace:

7. Click "Add Server" and then click the refresh button in the top right corner

Using the Tools in Cursor

• "List all tables in my database"

• "Create a new users table"

• "Add an index to the email column"

1. A prompt to approve/deny the tool call

2. The tool call arguments (expandable)

3. The response after approval

Windsurf/Cascade Integration

Setting up with Cascade

1. Create or edit ~/.codeium/windsurf/mcp_config.json:

2. Quick access to config:

3. Replace in the configuration:

4. In Cascade:

Important Notes for Cascade Users

• Only tools functionality is supported (no prompts or resources)

• MCP tool calls will consume credits regardless of success or failure

• Image output is not supported

• Only stdio transport type is supported

• Tool calls can invoke code written by arbitrary server implementers

• Cascade does not assume liability for MCP tool call failures

Features

Available Database Tools

Table Management

• Tables: list_tables, create_table, drop_table, rename_table

• Columns: add_column, drop_column, alter_column

• Records: fetch_records, create_record, update_record, delete_record

Indexes & Constraints

• Indexes: list_indexes, create_index, delete_index, update_index

• Constraints: list_constraints, add_constraint, remove_constraint, update_constraint

Database Functions & Triggers

• Functions: list_functions, create_function, update_function, delete_function

• Triggers: list_triggers, create_trigger, update_trigger, delete_trigger

Security & Access Control

• Policies: list_policies, create_policy, update_policy, delete_policy

• Roles: list_roles, create_role, update_role, delete_role

Storage Management

• Buckets: list_buckets, create_bucket, delete_bucket

• Files: delete_file, bulk_delete_files

• Folders: list_folders

Data Types & Publications

• Enumerated Types: list_enumerated_types, create_enumerated_type, update_enumerated_type, delete_enumerated_type

• Publications: list_publications, create_publication, update_publication, delete_publication

Realtime Features

• Policies: list_realtime_policies, create_realtime_policy, update_realtime_policy, delete_realtime_policy

• Channels: list_realtime_channels, manage_realtime_channels, send_realtime_message, get_realtime_messages

• Management: manage_realtime_status, manage_realtime_views

User Management

• Auth: list_users, create_user, update_user, delete_user

Direct SQL Access

• Query: query - Execute custom SQL queries

Key Benefits

• Natural Language Control: Manage your Supabase database through simple conversational commands

• Comprehensive Coverage: Full suite of tools covering tables, records, indexes, functions, security, and more

• Seamless Integration: Works directly within Cursor's Composer and Codeium's Cascade

• Developer Friendly: Reduces context switching between IDE and database management tools

• Secure Access: Maintains your database security with proper authentication

Project Structure

Usage

• "Show me all tables in my database"

• "Create a new users table with id, name, and email columns"

• "Add an index on the email column of the users table"

Security Notes

• Keep your database connection string secure

• Never commit sensitive credentials to version control

• Use appropriate access controls and permissions

• Validate and sanitize all inputs to prevent SQL injection

Troubleshooting

Common Connection Issues

1. Node.js Path Issues

2. File Path Issues

3. MCP Not Detecting Tools

4. Permission Issues

Debug Mode

Platform-Specific Notes

Windows Users

Linux Users

• Your operating system

• Node.js version (node --version)

• Full error message

• Steps to reproduce

Contributing

License

Supabase MCP Server

A powerful Model Context Protocol (MCP) server that provides full administrative control over your Supabase PostgreSQL database through both Cursor's Composer and Codeium's Cascade. This tool enables seamless database management with comprehensive features for table operations, record management, schema modifications, and more.

Table of Contents

• Prerequisites

• Quick Start

• Integrations

• Features

• Usage

• Security Notes

• Troubleshooting

• Contributing

• License

Prerequisites

• Node.js >= 16.x

• npm >= 8.x

• A Supabase project with:

• Cursor IDE or Codeium's Cascade (for paying users)

Quick Start

Installation

Configuration

1. Install dependencies and build the project:

2. In Cursor's MCP settings, add the server with this command:Replace:

Integrations

Cursor MCP Integration

Setting up in Cursor

1. Open Cursor Settings > Features > MCP

2. Click the "+ Add New MCP Server" button

3. Fill in the modal form:

4. Build the project first:

5. Get your Node.js path:

6. Add the server command:Replace:

7. Click "Add Server" and then click the refresh button in the top right corner

Using the Tools in Cursor

• "List all tables in my database"

• "Create a new users table"

• "Add an index to the email column"

1. A prompt to approve/deny the tool call

2. The tool call arguments (expandable)

3. The response after approval

Windsurf/Cascade Integration

Setting up with Cascade

1. Create or edit ~/.codeium/windsurf/mcp_config.json:

2. Quick access to config:

3. Replace in the configuration:

4. In Cascade:

Important Notes for Cascade Users

• Only tools functionality is supported (no prompts or resources)

• MCP tool calls will consume credits regardless of success or failure

• Image output is not supported

• Only stdio transport type is supported

• Tool calls can invoke code written by arbitrary server implementers

• Cascade does not assume liability for MCP tool call failures

Features

Available Database Tools

Table Management

• Tables: list_tables, create_table, drop_table, rename_table

• Columns: add_column, drop_column, alter_column

• Records: fetch_records, create_record, update_record, delete_record

Indexes & Constraints

• Indexes: list_indexes, create_index, delete_index, update_index

• Constraints: list_constraints, add_constraint, remove_constraint, update_constraint

Database Functions & Triggers

• Functions: list_functions, create_function, update_function, delete_function

• Triggers: list_triggers, create_trigger, update_trigger, delete_trigger

Security & Access Control

• Policies: list_policies, create_policy, update_policy, delete_policy

• Roles: list_roles, create_role, update_role, delete_role

Storage Management

• Buckets: list_buckets, create_bucket, delete_bucket

• Files: delete_file, bulk_delete_files

• Folders: list_folders

Data Types & Publications

• Enumerated Types: list_enumerated_types, create_enumerated_type, update_enumerated_type, delete_enumerated_type

• Publications: list_publications, create_publication, update_publication, delete_publication

Realtime Features

• Policies: list_realtime_policies, create_realtime_policy, update_realtime_policy, delete_realtime_policy

• Channels: list_realtime_channels, manage_realtime_channels, send_realtime_message, get_realtime_messages

• Management: manage_realtime_status, manage_realtime_views

User Management

• Auth: list_users, create_user, update_user, delete_user

Direct SQL Access

• Query: query - Execute custom SQL queries

Key Benefits

• Natural Language Control: Manage your Supabase database through simple conversational commands

• Comprehensive Coverage: Full suite of tools covering tables, records, indexes, functions, security, and more

• Seamless Integration: Works directly within Cursor's Composer and Codeium's Cascade

• Developer Friendly: Reduces context switching between IDE and database management tools

• Secure Access: Maintains your database security with proper authentication

Project Structure

Usage

• "Show me all tables in my database"

• "Create a new users table with id, name, and email columns"

• "Add an index on the email column of the users table"

Security Notes

• Keep your database connection string secure

• Never commit sensitive credentials to version control

• Use appropriate access controls and permissions

• Validate and sanitize all inputs to prevent SQL injection

Troubleshooting

Common Connection Issues

1. Node.js Path Issues

2. File Path Issues

3. MCP Not Detecting Tools

4. Permission Issues

Debug Mode

Platform-Specific Notes

Windows Users

Linux Users

• Your operating system

• Node.js version (node --version)

• Full error message

• Steps to reproduce

Contributing

License