skills.rest
2nth-ai
2nth-aiOFFICIAL
Explore all skills by this author →
GitHub

tech/google/cloud/database

Manage and deploy GCP databases including Cloud SQL, AlloyDB, Spanner, Firestore, Bigtable, and Memorystore.

1|Updated Apr 1, 2026
Search Tags:#database management#GCP#Spanner#Firestore#AlloyDB#Cloud SQL#Bigtable
One-click install
npx skills add https://github.com/2nth-ai/skills --skill tech-google-cloud-database
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: tech/google/cloud/database
Source: https://github.com/2nth-ai/skills/tree/main/tech/google/cloud/database
Command: npx skills add https://github.com/2nth-ai/skills --skill tech-google-cloud-database

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill streamlines the management of various GCP databases, including Cloud SQL, AlloyDB, Spanner, Firestore, Bigtable, and Memorystore, simplifying the process of setting up and maintaining these services.

Core Features & Use Cases

  • Cloud SQL Management: Set up and manage managed databases like Postgres, MySQL, and SQL Server on Cloud SQL.
  • AlloyDB and Spanner: Deploy and manage high-performance databases for OLTP and globally-distributed SQL.
  • Firestore: Utilize Firestore for serverless document storage, suitable for mobile and web clients.
  • Bigtable: Store and process vast amounts of wide-column data at petabyte scale.
  • Memorystore: Implement in-memory caching with Redis, Memcached, and Valkey for improved performance.
  • Use Case: For a company looking to deploy a scalable database solution with high availability and performance, this Skill provides the necessary tools and guidance to set up and manage Cloud SQL, Spanner, and Firestore services.

Quick Start

Set up a Cloud SQL instance for PostgreSQL on GCP with the following command:

gcloud sql instances create my-pg \
  --database-version POSTGRES_16 \
  --region africa-south1 \
  --tier db-custom-2-7680 \
  --storage-type SSD --storage-size 20 --storage-auto-increase \
  --availability-type ZONAL \
  --backup --enable-point-in-time-recovery

Frequently Asked Questions about tech/google/cloud/database

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

FAQPage Schema
How do I deploy a Postgres database on Cloud SQL?▼

You can deploy a Postgres database on Cloud SQL using a gcloud command to create an instance, specifying the database version, region, tier, and storage configurations for optimal performance.

What's the best way to manage globally distributed SQL databases on GCP?▼

Managing globally distributed SQL databases on GCP is best handled through Spanner, which provides high-performance, horizontally scalable relational databases with strong consistency.

Can I use Bigtable for petabyte scale wide-column data processing?▼

Yes, Bigtable is designed to store and process vast amounts of wide-column data at petabyte scale, making it suitable for massive analytical and operational workloads.

Does this approach support serverless document storage for web clients?▼

Firestore supports serverless document storage, providing a fully managed, scalable database solution suitable for mobile and web client applications.

When do I need in-memory caching with Redis or Memcached?▼

You need in-memory caching with Redis or Memcached via Memorystore when optimizing database performance and reliability for use cases requiring low-latency data access.

How does AlloyDB compare to Cloud SQL for OLTP workloads?▼

AlloyDB is tailored for high-performance OLTP workloads with PostgreSQL compatibility, whereas Cloud SQL provides managed relational databases for standard deployments.

Related Skills

Explore More Software Engineering Skills→
JuanMS20JuanMS20

github-auth

Configure GitHub authentication for Hermes Agent using git, gh CLI, or SSH credentials.

Community
Intermediate
NicholasSutinNicholasSutin

supabase-postgres-best-practices

Apply Postgres performance and security best practices for schema design and query execution.

Community
Advanced
h4vzzh4vzz
33

infrastructure-as-code

Generate Terraform, Pulumi, CloudFormation, or CDK configurations for cloud infrastructure.

Community
Advanced
BagelHoleBagelHole
46

gcp-cloud-sql

Provision and configure Google Cloud SQL and Spanner instances with high availability and automated backups.

Community
Intermediate