Windsurf Supabase MCP Server
remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
Integrations
Provides enhanced database interactions through Supabase, including SQL query processing, PostgREST API access, SQL to REST conversion, and optimized response formatting for UI components, with improved error handling and authentication.
Implements strict TypeScript types for response handling, providing type safety for database interactions and standardized JSON response formats.
Windsurf Supabase MCP Server
A Windsurf-optimized MCP server for Supabase integration
This repository contains a Windsurf-optimized version of the Supabase MCP server, specifically enhanced to work seamlessly with the Windsurf Editor. It builds upon the Model Context Protocol (MCP) standard, adding crucial improvements for better error handling, response formatting, and SQL query processing.
Key Modifications for Windsurf
1. Enhanced Error Handling
We faced several challenges with the original error handling system:
- Malformed SQL queries would cause silent failures
- Stream parsing errors were difficult to debug
- Error messages weren't LLM-friendly
Our solutions:
- Added structured error responses with detailed context
- Improved error messages for better LLM understanding
- Added validation for SQL query structure
- Enhanced stream error detection and recovery
2. Response Formatting
The original response format had limitations:
- Inconsistent JSON structure across different response types
- Missing metadata for UI components
- Limited type safety
Our improvements:
- Standardized JSON response format
- Added metadata for UI component generation
- Implemented strict TypeScript types
- Added support for streaming complex data structures
3. SQL to REST Conversion
We enhanced the SQL to REST conversion:
- Added support for more complex SQL operations
- Improved query validation
- Better handling of JOINs and subqueries
- Enhanced error messages for invalid SQL
4. Authentication & Headers
Key improvements in authentication handling:
- Flexible API key management
- Support for bearer token authentication
- Better header management for PostgREST requests
- Enhanced security validation
Integration with Windsurf
This MCP server is specifically designed to work with the Windsurf Editor, providing:
- Seamless database interactions through natural language
- Real-time query validation and correction
- Enhanced error messages for better debugging
- Optimized response formatting for UI components
Example Usage in Windsurf
Installation
- Clone this repository:
- Install dependencies:
- Configure your Supabase connection:
Usage with Windsurf
This server provides two main tools:
postgrestRequest
: Enhanced PostgREST API access
sqlToRest
: Improved SQL to REST conversion
Contributing
Contributions are welcome! Please read our Contributing Guidelines for details on our code of conduct and the process for submitting pull requests.
License
This project is licensed under the MIT License. See the LICENSE file for details.
This server cannot be installed
A Model Context Protocol server optimized for integrating Supabase with the Windsurf Editor, providing database interactions through natural language with enhanced error handling and response formatting.
- Key Modifications for Windsurf
- Integration with Windsurf
- Installation
- Usage with Windsurf
- Contributing
- License