# Supabase MCP Server Guide

> Complete tutorial for integrating Supabase with AI development tools using the Model Context Protocol (MCP).

This comprehensive guide covers setting up and using the Supabase MCP Server to enhance AI-powered development workflows with Cursor IDE and Claude. Learn how to manage Supabase projects, databases, and Edge Functions directly through AI assistants.

## Article Content

- **MCP Overview**: Understanding the Model Context Protocol and its benefits for AI development
- **Setup Instructions**: Step-by-step configuration of Supabase MCP Server with personal access tokens
- **Available Tools**: Complete reference of 24+ MCP tools for Supabase management
- **Integration Examples**: Practical usage with Cursor IDE and AI assistants

## Key Features Covered

### Project Management Tools
- list_projects, get_project, create_project
- pause_project, restore_project
- list_organizations, get_organization

### Database Operations
- list_tables, list_extensions, list_migrations
- apply_migration, execute_sql, get_logs

### Edge Functions
- list_edge_functions, deploy_edge_function

### Branching & Development
- create_branch, list_branches, delete_branch
- merge_branch, reset_branch, rebase_branch
- generate_typescript_types

### Project Configuration
- get_project_url, get_anon_key
- get_cost, confirm_cost

## Setup Configuration Example

```json
{
  "mcpServers": {
    "supabase": {
      "command": "npx",
      "args": [
        "-y",
        "@supabase/mcp-server-supabase@latest",
        "--access-token",
        "<personal-access-token>"
      ]
    }
  }
}
```

## Complete Tool Reference

### Project Management Tools
- **list_projects**: List all Supabase projects in your organization
- **get_project**: Retrieve detailed information about a specific project
- **create_project**: Create a new Supabase project
- **pause_project**: Pause a project to save costs
- **restore_project**: Restore a paused project
- **list_organizations**: List all organizations you have access to
- **get_organization**: Get details about a specific organization

### Database Operations
- **list_tables**: List all tables in the project database
- **list_extensions**: Show installed PostgreSQL extensions
- **list_migrations**: Display database migration history
- **apply_migration**: Apply pending migrations to the database
- **execute_sql**: Run custom SQL queries against the database
- **get_logs**: Retrieve database and application logs

### Edge Functions
- **list_edge_functions**: List all deployed Edge Functions
- **deploy_edge_function**: Deploy new or updated Edge Functions

### Branching & Development
- **create_branch**: Create a new database branch for development
- **list_branches**: Show all available branches
- **delete_branch**: Remove a development branch
- **merge_branch**: Merge changes from one branch to another
- **reset_branch**: Reset a branch to a previous state
- **rebase_branch**: Rebase a branch onto another branch
- **generate_typescript_types**: Generate TypeScript types from database schema

## Target Audience

- **Developers**: Using Supabase for backend services
- **AI Tool Users**: Working with Cursor IDE, Claude, or other MCP-compatible tools
- **DevOps Teams**: Managing Supabase infrastructure and deployments
- **Type Safety Advocates**: Leveraging automatic TypeScript generation

## Related Resources

- [Main HeapSoft Site](https://heapsoft.ch): Our Supabase expertise and services
- [Blog Home](https://heapsoft.ch/blog): More technical articles
- [Supabase pgTAP Testing](https://heapsoft.ch/blog/supabase-pgtap-testing): Database testing strategies
- [Contact](https://heapsoft.ch#contact): Supabase consultation and development services