Custom MCP Servers for Vibin Coders SaaS Accelerator

This directory contains custom MCP (Model Context Protocol) servers for Supabase, Stripe, and Playwright integration.

Quick Setup

Install dependencies:
```
npm install --prefix ./mcp-servers
```

Configure environment variables:

cd mcp-servers
cp .env.example .env
# Edit .env with your actual values

Update Claude Code configuration: The MCP servers are already configured in Claude Code, but you need to update the environment variables in your ~/.claude.json file:

{
  "supabase": {
    "env": {
      "SUPABASE_URL": "https://your-project.supabase.co",
      "SUPABASE_SERVICE_ROLE_KEY": "your-service-role-key"
    }
  },
  "stripe": {
    "env": {
      "STRIPE_SECRET_KEY": "sk_test_your-secret-key"
    }
  },
  "playwright": {
    "env": {
      "PLAYWRIGHT_HEADLESS": "true"
    }
  }
}

MCP Server Capabilities

Supabase MCP Server

supabase_query - Execute raw SQL queries
supabase_insert - Insert data into tables
supabase_select - Select data with filters
supabase_update - Update table records
supabase_create_table - Create new tables
supabase_get_schema - Get database schema info

Stripe MCP Server

stripe_create_product - Create products
stripe_create_price - Create pricing plans
stripe_list_products - List all products
stripe_list_prices - List all prices
stripe_create_checkout_session - Create payment sessions
stripe_create_customer_portal - Create management portal
stripe_get_customer - Retrieve customer info
stripe_create_customer - Create new customer
stripe_get_subscription - Get subscription details
stripe_list_webhooks - List webhook endpoints

Playwright MCP Server

playwright_navigate - Navigate to URLs
playwright_click - Click elements
playwright_fill - Fill form fields
playwright_get_text - Get element text
playwright_screenshot - Take screenshots
playwright_wait_for_selector - Wait for elements
playwright_evaluate - Run JavaScript
playwright_get_title - Get page title
playwright_get_url - Get current URL
playwright_check_element_exists - Check if element exists
playwright_close_browser - Close browser instance
playwright_new_page - Create new page/tab

Testing MCP Servers

Test individual servers:

# Test Supabase server
node supabase-mcp/index.js

# Test Stripe server
node stripe-mcp/index.js

# Test Playwright server
node playwright-mcp/index.js

Environment Variables Required

Supabase

SUPABASE_URL - Your Supabase project URL
SUPABASE_SERVICE_ROLE_KEY - Service role key (has admin access)
SUPABASE_ANON_KEY - Anonymous key (optional)

Stripe

STRIPE_SECRET_KEY - Your Stripe secret key (use test key for development)
STRIPE_PUBLISHABLE_KEY - Your Stripe publishable key (optional)

Playwright

PLAYWRIGHT_HEADLESS - Run browser in headless mode (true/false)
PLAYWRIGHT_BROWSER - Browser type (chromium/firefox/webkit)

Usage in Claude Code

Once configured, you can use these tools in your prompts:

Use the Supabase MCP to create a subscription_plans table with these columns: id, name, price, stripe_price_id, features, active.

Then use the Stripe MCP to create products for Pro ($29/month) and Business ($99/month) plans.

Finally, use the Playwright MCP to test the pricing page loads correctly.

Troubleshooting

Connection failures: Check environment variables are set correctly
Permission errors: Ensure service role key has proper permissions
Module errors: Run npm install in the mcp-servers directory
Playwright browser errors: Run npx playwright install to install browsers

Manual Configuration Update

If you need to update the MCP server configuration manually, edit ~/.claude.json and update the environment variables in the mcpServers section.

Alternatively, remove and re-add servers:

claude mcp remove supabase
claude mcp add supabase --env SUPABASE_URL=your-url --env SUPABASE_SERVICE_ROLE_KEY=your-key -- node /path/to/supabase-mcp/index.js

MCP Servers