🌱 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

# Verify upgrade
garden upgrade verify

🔧 Configuration

Environment Variables

Create .env file in plugin root:

# Supabase Configuration
SUPABASE_URL=http://localhost:54321
SUPABASE_ANON_KEY=your-anon-key
SUPABASE_SERVICE_ROLE_KEY=your-service-role-key
SUPABASE_PROJECT_ID=your-project-id

# Airflow Configuration (Optional)
AIRFLOW_HOME=${PWD}/airflow
AIRFLOW_API_URL=http://localhost:8080
AIRFLOW_USERNAME=admin
AIRFLOW_PASSWORD=admin

# Logging
LOG_LEVEL=INFO

Garden Configuration

Edit config/garden.yml for advanced configuration:

version: "0.2.0"

project:
  name: "your-project"
  root: "/path/to/project"

databases:
  sqlite:
    - name: "main"
      path: "data/main.db"
      schema: "main"
      wal_mode: true

  supabase:
    project_id: "${SUPABASE_PROJECT_ID}"
    schemas: ["public", "custom"]

mcp_servers:
  supabase_local:
    enabled: true
    command: npx
    args: ["@modelcontextprotocol/server-supabase"]

  supabase_remote:
    enabled: true
    use_claude_mcp: true

agents:
  enabled:
    - audit-agent
    - schema-agent
    - debug-agent
    - review-agent
    - scaffold-agent
    - wire-agent
    - test-agent
    - upgrade-agent

🤖 Agent Details

Audit Agent

Purpose: Proactive system health monitoring

Capabilities:

Database integrity checks (PRAGMA integrity_check)
Orphaned index detection
Security vulnerability scanning
Performance bottleneck identification
Compliance validation

Schedule: Every 6 hours + on-demand

Schema Agent

Purpose: Database schema consistency

Capabilities:

Schema diffing (SQLite ↔ Supabase)
Migration generation
Safe migration application
Foreign key verification

MCP Integration: list_tables, apply_migration, list_migrations

Debug Agent

Purpose: Fast issue resolution

Capabilities:

Log pattern analysis
Stack trace interpretation
Connectivity testing
Root cause identification

MCP Integration: get_logs for all Supabase services

Wire Agent

Purpose: Service integration confidence

Capabilities:

Connectivity testing
Health check execution
Dependency mapping
Architecture diagram generation

Triggers: On startup, before deploy, on-demand

Test Agent

Purpose: Comprehensive quality validation

Test Types:

Unit: Fast, isolated, mocked
Integration: Multi-component, real connections
Smoke: Critical paths, quick validation
E2E: Full workflows, browser automation

Coverage Threshold: 80%

Scaffold Agent

Purpose: Consistent resource generation

Templates:

Database tables
Airflow DAGs
Skill definitions
Agent prompts
Test suites
Migrations

Review Agent

Purpose: Code quality assurance

Capabilities:

Skill validation
Migration safety review
DAG validation
Code linting

Upgrade Agent

Purpose: Safe system evolution

Features:

Automatic backups
Migration automation
Rollback on failure
Verification checks

📚 Documentation

ARCHITECTURE.md: Detailed multi-agent architecture
prompts/: Agent system prompts
prompts/examples/: Practical usage examples
config/: Configuration references
scaffolds/: Template documentation

📊 Architecture

┌─────────────────────────────────────────────────────────────┐
│                     CLI Interface Layer                      │
│  garden [command] [subcommand] [options]                    │
└─────────────────────────────────────────────────────────────┘
                              │
┌─────────────────────────────────────────────────────────────┐
│                   Agent Orchestration Layer                  │
│  ┌─────────┐  ┌─────────┐  ┌─────────┐  ┌─────────┐       │
│  │  Audit  │  │ Schema  │  │  Debug  │  │ Review  │       │
│  │  Agent  │  │  Agent  │  │  Agent  │  │  Agent  │       │
│  └─────────┘  └─────────┘  └─────────┘  └─────────┘       │
│  ┌─────────┐  ┌─────────┐  ┌─────────┐  ┌─────────┐       │
│  │Scaffold │  │ Upgrade │  │  Wire   │  │  Test   │       │
│  │  Agent  │  │  Agent  │  │  Agent  │  │  Agent  │       │
│  └─────────┘  └─────────┘  └─────────┘  └─────────┘       │
└─────────────────────────────────────────────────────────────┘
                              │
┌─────────────────────────────────────────────────────────────┐
│                    Integration Layer                         │
│  ┌──────────────┐  ┌──────────────┐  ┌──────────────┐      │
│  │   Supabase   │  │   Airflow    │  │   SQLite     │      │
│  │  MCP Local   │  │     API      │  │   Direct     │      │
│  └──────────────┘  └──────────────┘  └──────────────┘      │
└─────────────────────────────────────────────────────────────┘

See ARCHITECTURE.md for detailed architecture documentation.

🎓 Use Cases

Development Workflow

# 1. Start services
garden wire test all

# 2. Make schema changes
# ... edit schema ...

# 3. Compare with remote
garden db diff

# 4. Generate migration
garden db migration generate sync_local_changes

# 5. Apply migration
garden db migration apply

# 6. Run tests
garden test unit
garden test integration

# 7. Pre-commit checks
garden compliance check

Production Deployment

# 1. Connectivity validation
garden wire test all

# 2. Security audit
garden security scan --severity critical

# 3. Database audit
garden db audit --deep

# 4. Smoke tests
garden test smoke --environment production

# 5. Deploy
# ... deployment ...

# 6. Verification
garden upgrade verify

🔍 Troubleshooting

MCP Server Not Connected

# Test MCP connectivity
garden wire test supabase-mcp

# If failed, check Supabase:
supabase status

# Start if needed:
supabase start

Database Locked Errors

# Inspect database
garden debug inspect --component database

# Enable WAL mode in connections

Agent Execution Failures

# Check logs
garden debug logs --filter "agent"

# Verify configuration
garden compliance check

🤝 Contributing

We welcome contributions!

Fork the repository
Create a feature branch
Follow naming conventions
Add tests
Update documentation
Submit a pull request

📄 License

MIT License - see LICENSE file

🙏 Acknowledgments

Built with:

📞 Support

Issues: https://github.com/Diatonic-AI/opengov-garden/issues
Discussions: https://github.com/Diatonic-AI/opengov-garden/discussions
Email: ai@diatonic.ai

Version: 0.2.0 Last Updated: 2026-01-26 Maintained By: Diatonic AI

Name		Name	Last commit message	Last commit date
Latest commit History 10 Commits
.claude-plugin		.claude-plugin
agents		agents
commands		commands
config		config
hooks		hooks
prompts		prompts
scaffolds		scaffolds
scripts		scripts
skills		skills
.gitignore		.gitignore
.mcp.json		.mcp.json
ARCHITECTURE.md		ARCHITECTURE.md
CHANGELOG.md		CHANGELOG.md
LICENSE		LICENSE
QUICKSTART.md		QUICKSTART.md
README.md		README.md

Uh oh!

Folders and files

Latest commit

History

Repository files navigation

🌱 OpenGov Garden

🎯 What is Garden?

Key Features

🚀 Quick Start

Installation

First Commands

🛠️ Common Workflows

Database Operations

Service Connectivity

Testing

Debugging

Security & Compliance

Resource Generation

System Upgrades

🔧 Configuration

Environment Variables

Garden Configuration

🤖 Agent Details

Audit Agent

Schema Agent

Debug Agent

Wire Agent

Test Agent

Scaffold Agent

Review Agent

Upgrade Agent

📚 Documentation

📊 Architecture

🎓 Use Cases

Development Workflow

Production Deployment

🔍 Troubleshooting

MCP Server Not Connected

Database Locked Errors

Agent Execution Failures

🤝 Contributing

📄 License

🙏 Acknowledgments

📞 Support

About

Resources

License

Code of conduct

Contributing

Security policy

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Uh oh!

Contributors

Uh oh!

Languages

Packages