Community Команды Базы данных

Команда supabase-schema-sync

Claude Code
Открыть источник ↗ GitHub ↗
Установка 
npx claude-code-templates@latest --command database/supabase-schema-sync

Описание

supabase-schema-sync — slash-команда работы со схемой Supabase: синхронизация — приведение структуры базы в соответствие проекту, MCP-интеграция — взаимодействие с Supabase через Model Context Protocol, согласование изменений — контроль того, что мигрирует и когда. Для разработчиков на Supabase, ведущих схему через агента.

Что умеет:
— синхронизировать схему БД с проектом;
— работать с Supabase через MCP;
— согласовывать изменения структуры;
— запускаться одной командой.

Supabase Schema Sync

Synchronize database schema between local and Supabase with comprehensive validation: $ARGUMENTS

Current Supabase Context

  • MCP connection: Supabase MCP server with read-only access configured
  • Local schema: !find . -name "schema.sql" -o -name "migrations" -type d | head -3 local database files
  • Project config: !find . -name "supabase" -type d -o -name ".env*" | grep -v node_modules | head -3 configuration files
  • Git status: !git status --porcelain | grep -E "\\.sql$|\\.ts$" | head -5 database-related changes

Task

Execute comprehensive schema synchronization with Supabase integration:

Sync Action: Use $ARGUMENTS to specify pull from remote, push to remote, diff comparison, or schema validation

Schema Synchronization Framework:

  • MCP Integration – Connect to Supabase via MCP server, authenticate with project credentials, validate connection status
  • Schema Analysis – Compare local vs remote schema, identify structural differences, analyze migration requirements, assess breaking changes
  • Sync Operations – Execute pull/push operations, apply schema migrations, handle conflict resolution, validate data integrity
  • Validation Process – Verify schema consistency, validate foreign key constraints, check index performance, test query compatibility
  • Migration Management – Generate migration scripts, track version history, implement rollback procedures, optimize execution order
  • Safety Checks – Backup critical data, validate permissions, check production impact, implement dry-run mode

Advanced Features: Automated conflict resolution, schema version control, performance impact analysis, team collaboration workflows, CI/CD integration.

Quality Assurance: Schema validation, data integrity checks, performance optimization, rollback readiness, team synchronization.

Output: Complete schema sync with validation reports, migration scripts, conflict resolution, and team collaboration updates.