All skills
cloud-sql-basics
Create and connect a Cloud SQL instance, database, and user with gcloud commands.
- Part of google/skills
- 16.3k installs
- Data · Databases
When to use it
You have a Google Cloud project and need a managed PostgreSQL, MySQL, or SQL Server database but haven't provisioned the instance yet.
For example
You say
Use cloud-sql-basics to create a PostgreSQL instance named orders-db in us-central1, set the postgres password, and create an orders database.
You get
- gcloud instance create command
- postgres password set
- orders database created
How it works
- Connecting locally requires running the Cloud SQL Auth Proxy alongside psql.
- Covers editions, high availability, backups, and Terraform as reference material.
Before installing
You need IAM permissions to manage Cloud SQL, such as the Cloud SQL Admin (roles/cloudsql.admin) role.
More Databases skills
See all- cosmosdb-datamodeling8.7kGuides you through gathering NoSQL requirements and produces an Azure Cosmos DB data model design.
- database-optimizer6.5kSpeeds up slow PostgreSQL and MySQL queries through index design, query rewrites and configuration tuning.
- database-design2.3kGuides schema design, indexing strategy, ORM choice and serverless database decisions.
- wren1.7kPoints the agent to the Wren CLI workflow for querying 22+ databases and setting up connections.
Also in this pack
- cloud-run-basics19.4kDeploys and manages Cloud Run services, jobs and worker pools.
- gemini-api18.8kWrites code that calls Gemini models for text, images, video, audio, embeddings and more across languages.
- google-cloud-recipe-auth17.1kExplains how to authenticate and authorize users and services to Google Cloud APIs, including IAM and ADC.
- google-cloud-recipe-onboarding16.9kWalks a new developer through creating a Google Cloud account, setting up billing and deploying a first resource.