google-cloud-solution-n-tier-serverless-web-app

Generates secure n-tier serverless web application architectures with Terraform for Google Cloud.

Updated Jul 24, 2026
One-click install
npx skills add https://github.com/oliverconstance/webapp-scrum-team --skill google-cloud-solution-n-tier-serverless-web-app-oliverconstance
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: google-cloud-solution-n-tier-serverless-web-app
Source: https://github.com/oliverconstance/webapp-scrum-team/tree/main/.agent/skills/google-cloud-solution-n-tier-serverless-web-app
Command: npx skills add https://github.com/oliverconstance/webapp-scrum-team --skill google-cloud-solution-n-tier-serverless-web-app-oliverconstance

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and assets (resource) components.

What problem does it solve? Designing a secure multi-tier serverless web application on Google Cloud requires coordinating Cloud Run, Cloud SQL, load balancers, VPC networking, and WAF rules, which is error-prone when done manually. This Skill guides an agent through requirements discovery, architecture design, Terraform generation, and deployment validation for such systems. ## Core Features & Use Cases - Guided Requirements Discovery: Uses an opinionated 80% golden-path baseline (3-tier Cloud Run plus Cloud SQL PostgreSQL in us-central1) with at most two disambiguation questions to avoid interview fatigue. - Architecture & IaC Generation: Produces a Mermaid architecture diagram, a structured solution report, complete Terraform code based on assets/main.tf, and bottom-up gcloud CLI deployment commands. - Security-First Design: Enforces 9 architectural security boundaries including private ingress, Direct VPC Egress, Cloud Armor WAF, Private Service Connect, and optional VPC Service Controls. - Use Case: A platform engineer asks the agent to design a secure 3-tier web app with a global load balancer and Redis caching; the Skill produces the architecture report, Terraform code, deployment steps, and a custom validation script. ## Quick Start Ask the agent to design a secure n-tier serverless web application on Google Cloud with Cloud Run and Cloud SQL, and confirm the proposed golden-path architecture.

Frequently Asked Questions about google-cloud-solution-n-tier-serverless-web-app

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a secure serverless web application on Google Cloud?▼

Use this Skill to walk through a four-phase workflow: requirements discovery, solution design with Terraform generation, implementation planning, and validation. It produces a 3-tier Cloud Run and Cloud SQL architecture with private networking, Cloud Armor WAF, and a load balancer by default.

How to deploy a multi-tier Cloud Run architecture with Terraform?▼

The Skill generates complete Terraform code based on its assets/main.tf template, covering VPC, Cloud Run services, Cloud SQL PostgreSQL 18 via Private Service Connect, and load balancing. It also provides equivalent bottom-up gcloud CLI commands and recommends running them in Google Cloud Shell.

Does this architecture support Memorystore Redis caching?▼

Yes, Memorystore for Redis is offered as an optional caching tier during requirements discovery, connected via Private Services Access. It is only provisioned if you confirm the need for in-memory caching alongside Cloud SQL.

When should I not use this serverless n-tier approach?▼

Do not use this Skill when designing VM-based or GKE-based architectures, or when the workload is not hosted on Google Cloud. It is specifically scoped to Cloud Run and Cloud SQL serverless deployments.

How is security enforced between Cloud Run tiers?▼

Internal tiers use INGRESS_TRAFFIC_INTERNAL_ONLY with Direct VPC Egress, a Cloud DNS private zone for run.app resolution, and least-privilege egress firewalls. The Skill validates 9 security boundaries including WAF SQL injection blocking and private server-to-server connectivity.