aktonay/skillz / skills/cloud/cloud-sql-basics
cloud-sql-basics
VerifiedThis file generates or explains Cloud SQL resources. Use this file when the user asks to create a Cloud SQL instance or database for MySQL, PostgreSQL, or SQL Server. Cloud SQL manages third-party MySQL, PostgreSQL, and SQL Server instances as resources in Cloud SQL. For example, when Cloud SQL creates an open-source MySQL instance, the resulting resource is a Cloud SQL for MySQL instance that Google Cloud manages. Cloud SQL handles backups, high availability, and secure connectivity for relational database workloads.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 3.5 KB |
| references/cli-usage.md | markdown | 1.5 KB |
| references/client-library-usage.md | markdown | 2.9 KB |
| references/core-concepts.md | markdown | 2.0 KB |
| references/iac-usage.md | markdown | 1.2 KB |
| references/iam-security.md | markdown | 2.9 KB |
| references/mcp-usage.md | markdown | 2.4 KB |
references/cli-usage.md
View on GitHub# Cloud SQL CLI Usage
The `gcloud sql` command group is used to manage Cloud SQL instances and
related resources.
## Basic Syntax
```bash
gcloud sql [GROUP] [COMMAND] [FLAGS]
```
## Essential Commands
### Instance Management
- **Create an instance:**
```bash
gcloud sql instances create my-instance --database-version=MYSQL_8_0 \
--tier=db-f1-micro --region=us-central1 \
--quiet
```
- **List instances:**
```bash
gcloud sql instances list --quiet
```
- **Describe an instance:**
```bash
gcloud sql instances describe my-instance --quiet
```
- **Restart an instance:**
```bash
gcloud sql instances restart my-instance --quiet
```
### Database and User Management
- **Create a database:**
```bash
gcloud sql databases create my-db --instance=my-instance --quiet
```
- **Create a user:**
```bash
gcloud sql users create my-user --instance=my-instance \
--password=my-password \
--quiet
```
### Operations and Backups
- **List operations:**
```bash
gcloud sql operations list --instance=my-instance --quiet
```
- **Create a backup:**
```bash
gcloud sql backups create --instance=my-instance --quiet
```
- **Restore from a backup:**
```bash
gcloud sql backups restore backup_id --restore-instance=my-instance --quiet
```
## Common Flags
- `--project`: Specifies the project ID.
- `--region`: The region where the instance is located.
- `--format`: Changes output format (e.g., `json`, `yaml`).
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| Agent Cost Reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| Agent Cost Reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |