Supabase-Integrated Development Stack

A comprehensive, production-ready development stack with Supabase PostgreSQL integration, automated backups, and Tailscale networking.

🚀 Features

• AI & LLM: Ollama + OpenWebUI for local AI chat interface
• Automation: n8n workflow automation platform
• Storage: MinIO S3-compatible object storage
• Database: Supabase PostgreSQL with automated backups
• Monitoring: Grafana + Prometheus for comprehensive monitoring
• Notebooks: Kaggle Jupyter notebooks with GPU support
• Docker Management: Portainer for container management
• Networking: Tailscale mesh networking with static IPs
• Security: Let's Encrypt SSL certificates
• Backup: Automated daily database backups with 30-day retention
• Simplified Setup: Pre-configured credentials for personal use

🗄️ Supabase Integration

Database Backend

• Host: db.dwgsdbxkwjoyxywufbgf.supabase.co
• Port: 5432
• Database: postgres
• User: postgres
• Password: rGEQ1s1Nl0t6Sdus

Data Persistence

• OpenWebUI: User data, chat history, and configurations
• n8n: Workflow definitions and execution history
• Grafana: Dashboard configurations and user settings
• Jupyter: Database connections for data analysis

Automated Backups

• Schedule: Daily at 2:00 AM
• Retention: 30 days
• Format: Compressed SQL dumps
• Location: supabase_backups Docker volume

Centralized Storage

• All application data stored in Supabase PostgreSQL
• Consistent data access across all services
• Built-in Supabase features: real-time subscriptions, row-level security

🚀 Quick Start

Prerequisites

• Docker & Docker Compose
• Tailscale (for networking)
• Git

Deployment

1. Clone the repository:

   git clone https://github.com/Jblast94/Dev-Stack-Clean.git
   cd Dev-Stack-Clean

2. Run the deployment script:

   chmod +x deploy-supabase-stack.sh
   ./deploy-supabase-stack.sh

3. Configure DNS records:

   • Import cloudflare-dns-records.csv into Cloudflare
   • Replace [TAILSCALE_IP] with your actual Tailscale IP

🌐 Service URLs

Service	URL	Description
OpenWebUI	https://chat.bbj4u.xyz	AI Chat Interface
n8n	https://n8n.bbj4u.xyz	Workflow Automation
MinIO	https://s3.bbj4u.xyz	Object Storage
Adminer	https://db.bbj4u.xyz	Database Management
Grafana	https://monitor.bbj4u.xyz	Monitoring Dashboard
Prometheus	https://metrics.bbj4u.xyz	Metrics Collection
Jupyter	https://notebook.bbj4u.xyz	Data Science Notebooks
Portainer	https://docker.bbj4u.xyz	Docker Management

⚙️ Configuration

Environment Variables

A pre-configured .env file is included with simplified credentials:

• Username: jblast
• Password: password123
• Email: johnnyblast94@gmail.com

All services use these same credentials for simplicity in this personal stack.

DNS Configuration

1. Update cloudflare-dns-records.csv with your Tailscale IP
2. Import the CSV file into Cloudflare DNS
3. Ensure all domains point to your Tailscale node

🔄 Backup System

Automated Backups

• Frequency: Daily at 2:00 AM
• Retention: 30 days automatic cleanup
• Format: Compressed PostgreSQL dumps
• Monitoring: Logs available via Docker

Manual Backup

# Create immediate backup
docker exec supabase-backup /scripts/backup.sh

# View backup files
docker exec supabase-backup ls -la /backups/

# Check backup logs
docker logs supabase-backup

Backup Recovery

# Extract backup
docker exec supabase-backup gunzip /backups/backup_YYYYMMDD_HHMMSS.sql.gz

# Restore to Supabase (use with caution)
psql -h db.dwgsdbxkwjoyxywufbgf.supabase.co -p 5432 -U postgres -d postgres < backup_file.sql

🔒 Security Features

• SSL/TLS: Automatic Let's Encrypt certificates
• Network Isolation: Tailscale mesh networking
• Authentication: Basic auth for n8n, token-based for Jupyter
• Database Security: Supabase built-in security features
• Resource Limits: CPU and memory constraints for all services

📊 Monitoring

Grafana Dashboards

• System metrics and performance
• Application-specific monitoring
• Database connection and query metrics
• Backup system status

Prometheus Metrics

• Container resource usage
• Network performance
• Service health checks
• Custom application metrics

🖥️ GPU Support

Kaggle Jupyter notebooks include:

• NVIDIA GPU access
• CUDA toolkit
• Popular ML/AI libraries
• Direct database connectivity

🛠️ Troubleshooting

Common Issues

1. Services not accessible:

   # Check Tailscale status
   tailscale status
   
   # Verify DNS records
   nslookup chat.bbj4u.xyz

2. Database connection issues:

   # Test Supabase connectivity
   docker exec supabase-backup pg_isready -h db.dwgsdbxkwjoyxywufbgf.supabase.co -p 5432

3. Backup failures:

   # Check backup logs
   docker logs supabase-backup
   
   # Manual backup test
   docker exec supabase-backup /scripts/backup.sh

Service Logs

# View all services
docker-compose logs -f

# Specific service
docker-compose logs -f [service-name]

# Real-time monitoring
docker-compose ps

🔧 Maintenance

Updates

# Pull latest images
docker-compose pull

# Restart with updates
docker-compose up -d

Cleanup

# Remove old containers
docker system prune

# Clean unused volumes (careful!)
docker volume prune

Scaling

# Scale specific services
docker-compose up -d --scale prometheus=2

📝 License

MIT License - see LICENSE file for details.

🤝 Contributing

1. Fork the repository
2. Create a feature branch
3. Commit your changes
4. Push to the branch
5. Create a Pull Request

📞 Support

For issues and questions:

• Create an issue in this repository
• Check the troubleshooting section
• Review Docker and Tailscale documentation