# Supabase MCP Server

This is a Model Context Protocol (MCP) server that connects to Supabase and allows you to query the feature_suggestions table.

## Prerequisites

- Node.js (v16 or higher)
- npm
- Supabase project with credentials

## Setup

1. Make sure your `.env` file contains the following Supabase credentials:

   ```
   SUPABASE_URL=your_supabase_url
   SUPABASE_ANON_KEY=your_supabase_anon_key
   ```

2. Install the required dependencies:
   ```
   npm install
   ```

## Running the Server

Run the MCP server using:

```bash
npx tsx mcp-server.ts
```

Or use the npm script:

```bash
npm run dev
```

## Connecting to AI Tools

### Cursor

1. Open Cursor and navigate to **Cursor Settings**.
2. Under the **Features** tab, tap **+ Add new MCP server** under the **MCP Servers** section.
3. Enter the following details:
   - **Name**: Supabase
   - **Type**: command
   - **Command**: `npx tsx /path/to/mcp-server.ts`
4. You should see a green active status after the server is successfully connected.

### Claude Desktop

1. Open Claude desktop and navigate to **Settings**.
2. Under the **Developer** tab, tap **Edit Config** to open the configuration file.
3. Add the following configuration:
   ```json
   {
     "mcpServers": {
       "supabase": {
         "command": "npx",
         "args": ["tsx", "/path/to/mcp-server.ts"]
       }
     }
   }
   ```
4. Save the configuration file and restart Claude desktop.

## Available Tools

### query_feature_suggestions

Query the feature_suggestions table in your Supabase database.

Parameters:

- `limit` (number, optional): Maximum number of records to return (default: 100)

Example usage in AI tool:

```
Can you show me feature suggestions from the database?
```

Or with a limit:

```
Can you show me the top 10 feature suggestions?
```

## Troubleshooting

- If you encounter connection issues, make sure your Supabase credentials are correct.
- Check the console output for any error messages.
- Ensure that the feature_suggestions table exists in your Supabase database.