opengov-garden

🌱 OpenGov Garden

Universal DevOps automation toolkit for Supabase + Airflow + SQLite + Playwright stacks

A comprehensive Claude Code plugin that provides multi-agent orchestration, database schema synchronization, service wiring validation, automated testing, and intelligent code review for modern data pipeline development.

---

🎯 What is Garden?

Garden is a multi-agent DevOps automation system that helps you:

• 🔄 Synchronize SQLite and Supabase schemas automatically
• 🔍 Audit database integrity and security compliance
• 🧪 Test your code with comprehensive test orchestration
• 🔌 Validate service integrations and connectivity
• 📊 Generate resources following project conventions
• ⬆️ Upgrade systems safely with automated migrations
• 🐛 Debug issues with intelligent log analysis
• ✅ Review code for quality and security

Key Features

✨ 8 Specialized Agents:

• Audit Agent: System auditing and compliance checking
• Schema Agent: Database schema synchronization
• Debug Agent: Troubleshooting and error resolution
• Review Agent: Code and configuration review
• Scaffold Agent: Resource generation with conventions
• Wire Agent: Service integration validation
• Test Agent: Automated testing orchestration
• Upgrade Agent: System version upgrades

🎯 68 CLI Commands organized into 12 categories

🔌 Supabase MCP Integration for local and remote instances

📝 Config-Driven Architecture using YAML

🏗️ Scaffold Templates with automatic naming convention enforcement

🧪 Comprehensive Testing framework (unit, integration, smoke, E2E)

---

🚀 Quick Start

Installation

Install from the Diatonic AI marketplace:

# Add Diatonic AI marketplace to Claude Code
# In .claude/settings.json:
{
  "extraKnownMarketplaces": {
    "diatonic-ai-plugins": {
      "source": {
        "source": "github",
        "owner": "Diatonic-AI",
        "repo": "opengov-garden"
      }
    }
  },
  "enabledPlugins": {
    "opengov-garden@diatonic-ai-plugins": true
  }
}

First Commands

# Test service connectivity
garden wire test all

# Check database schemas
garden db diff

# Run system audit
garden db audit

# Check for plugin updates
garden upgrade check

---

🛠️ Common Workflows

Database Operations

# Compare local and remote schemas
garden db diff --detailed

# Synchronize schemas (SQLite → Postgres)
garden db sync

# Synchronize in reverse (Postgres → SQLite)
garden db sync --direction postgres_to_sqlite

# Audit database integrity
garden db audit

# Deep audit with comprehensive checks
garden db audit --deep

# Validate schema best practices
garden db schema validate

# Generate migration from changes
garden db migration generate add_versioning --type schema

# Apply specific migration
garden db migration apply --migration 20260125_add_versioning

# List all migrations
garden db migration list --status pending

Service Connectivity

# Test all services
garden wire test all

# Test specific service
garden wire test supabase-mcp
garden wire test database --verbose
garden wire test airflow
garden wire test auth

# Map service dependencies
garden wire map

# Generate architecture diagram
garden wire map --format svg --output docs/architecture.svg

Testing

# Run unit tests
garden test unit

# Run unit tests with coverage
garden test unit --coverage

# Run integration tests
garden test integration

# Run smoke tests (critical paths)
garden test smoke

# Run E2E tests
garden test e2e

# Generate coverage report
garden test coverage --min-coverage 90

Debugging

# Analyze logs
garden debug logs --service api --filter error

# Trace specific error
garden debug trace err_20260125_143052

# Ping service
garden debug ping database

# Inspect system state
garden debug inspect --component database

Security & Compliance

# Scan for vulnerabilities
garden security scan --severity critical

# Check Supabase advisors
garden security advisors --type security

# Check compliance
garden compliance check

Resource Generation

# Generate database table
garden scaffold table opengov_vendors

# Generate Airflow DAG
garden scaffold dag opengov_extraction_prod

# Generate skill definition
garden scaffold skill analytics/vendors:report

# Generate test suite
garden scaffold test integration/test_vendor_sync

System Upgrades

# Check for updates
garden upgrade check

# Plan upgrade
garden upgrade plan --to 0.3.0

# Execute upgrade
garden upgrade apply --to 0.3.0