Cloud SQL Basics
google/skills
This file generates or explains Cloud SQL resources. An agent skill from google/skills.
Creates and manages Cloud SQL instances for MySQL, PostgreSQL, and SQL Server.
$ npx skills add davila7/claude-code-templates --skill cloud-sql-basics -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install davila7/claude-code-templates cloud-sql-basics --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/davila7/claude-code-templates.git skills-src && mkdir -p .claude/skills && cp -r skills-src/cli-tool/components/skills/database/cloud-sql-basics .claude/skills/cloud-sql-basics && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "cloud-sql-basics" agent skill from https://github.com/davila7/claude-code-templates/tree/main/cli-tool/components/skills/database/cloud-sql-basics into .claude/skills/cloud-sql-basics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cloud-sql-basics", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/davila7/claude-code-templates/tree/main/cli-tool/components/skills/database/cloud-sql-basicsType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add davila7/claude-code-templates --skill cloud-sql-basics -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install davila7/claude-code-templates cloud-sql-basics --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/davila7/claude-code-templates.git skills-src && mkdir -p .agents/skills && cp -r skills-src/cli-tool/components/skills/database/cloud-sql-basics .agents/skills/cloud-sql-basics && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "cloud-sql-basics" agent skill from https://github.com/davila7/claude-code-templates/tree/main/cli-tool/components/skills/database/cloud-sql-basics into .agents/skills/cloud-sql-basics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cloud-sql-basics", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add davila7/claude-code-templates --skill cloud-sql-basics -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install davila7/claude-code-templates cloud-sql-basics --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/davila7/claude-code-templates.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/cli-tool/components/skills/database/cloud-sql-basics .cursor/skills/cloud-sql-basics && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "cloud-sql-basics" agent skill from https://github.com/davila7/claude-code-templates/tree/main/cli-tool/components/skills/database/cloud-sql-basics into .cursor/skills/cloud-sql-basics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cloud-sql-basics", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/davila7/claude-code-templates.git --path cli-tool/components/skills/database/cloud-sql-basics--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add davila7/claude-code-templates --skill cloud-sql-basics -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install davila7/claude-code-templates cloud-sql-basics --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/davila7/claude-code-templates.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/cli-tool/components/skills/database/cloud-sql-basics .gemini/skills/cloud-sql-basics && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "cloud-sql-basics" agent skill from https://github.com/davila7/claude-code-templates/tree/main/cli-tool/components/skills/database/cloud-sql-basics into .gemini/skills/cloud-sql-basics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cloud-sql-basics", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install davila7/claude-code-templates cloud-sql-basicsInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add davila7/claude-code-templates --skill cloud-sql-basics -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/davila7/claude-code-templates.git skills-src && mkdir -p .github/skills && cp -r skills-src/cli-tool/components/skills/database/cloud-sql-basics .github/skills/cloud-sql-basics && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "cloud-sql-basics" agent skill from https://github.com/davila7/claude-code-templates/tree/main/cli-tool/components/skills/database/cloud-sql-basics into .github/skills/cloud-sql-basics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cloud-sql-basics", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add davila7/claude-code-templates --skill cloud-sql-basics -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install davila7/claude-code-templates cloud-sql-basics --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/davila7/claude-code-templates.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/cli-tool/components/skills/database/cloud-sql-basics .opencode/skills/cloud-sql-basics && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "cloud-sql-basics" agent skill from https://github.com/davila7/claude-code-templates/tree/main/cli-tool/components/skills/database/cloud-sql-basics into .opencode/skills/cloud-sql-basics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cloud-sql-basics", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
cloud-sql-basicsCreates and manages Cloud SQL instances for MySQL, PostgreSQL, and SQL Server.
Cloud SQL Basics is an agent skill from davila7/claude-code-templates. Creates and manages Cloud SQL instances for MySQL, PostgreSQL, and SQL Server. Handles backups, high availability, and secure connectivity for relational database workloads on Google Cloud.
Its SKILL.md is about 810 tokens, which your agent loads only when the skill is triggered. The skill folder holds 7 other files, including reference files (for example `references/cli-usage.md`, `references/client-library-usage.md` and `references/core-concepts.md`).
It sits in Databases, covering Backup and disaster recovery and SQL. It works with SQL, PostgreSQL, Google Cloud and Microsoft SQL Server. The repository describes itself as: CLI tool for configuring and monitoring Claude Code. The licence is MIT.
6 steps, taken from the first numbered list in SKILL.md.
Read from SKILL.md and the folder at commit 4c82aba. It shows what the files ask for, not the result of running them.
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Shell commands in SKILL.md call:
gcloudFrom the folder's file list and the shell code blocks in SKILL.md.
No URLs in SKILL.md. Its commands use gcloud, which can reach the network depending on how they are called.
From URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Cloud SQL Basics loads about 810 tokens when it runs, and up to ~4.1k if it reads all its reference files. Until then it costs about 52 tokens; SKILL.md has 318 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
The full file from davila7/claude-code-templates at commit 4c82aba, republished under its MIT licence (© davila7). 318 words, ~810 tokens.
.claude/skills/cloud-sql-basics/SKILL.md (or your agent's skills folder). This skill also uses 6 other files; get the full folder from GitHub.Cloud SQL is a fully managed relational database service for MySQL, PostgreSQL, and SQL Server. It automates time-consuming tasks like patches, updates, backups, and replicas, while providing high performance and availability for your applications.
Ensure you have the necessary IAM permissions to create and manage Cloud SQL
instances. The Cloud SQL Admin (roles/cloudsql.admin) role provides full
access to Cloud SQL resources.
Enable the API:
gcloud services enable sqladmin.googleapis.com --quietCreate an Instance:
gcloud sql instances create INSTANCE_NAME \
--database-version=POSTGRES_18 \
--cpu=2 \
--memory=7680MiB \
--region=REGION \
--quietSet a password for the default user:
Because this is a Cloud SQL for PostgreSQL instance, the default admin user
is postgres:
gcloud sql users set-password postgres \
--instance=INSTANCE_NAME --password=PASSWORD \
--quietCreate a database:
gcloud sql databases create DATABASE_NAME \
--instance=INSTANCE_NAME \
--quietGet the instance connection name:
You need the instance connection name (which is formatted as
PROJECT_ID:REGION:INSTANCE_NAME) to connect using the Cloud SQL Auth
Proxy. Retrieve it with the following command:
gcloud sql instances describe INSTANCE_NAME \
--format="value(connectionName)" \
--quietConnect to the instance:
The Cloud SQL Auth Proxy must be running to be able to connect to the instance. In a separate terminal, start the proxy using the connection name:
./cloud-sql-proxy INSTANCE_CONNECTION_NAMEWith the proxy running, connect using psql in another terminal:
psql "host=127.0.0.1 port=5432 user=postgres dbname=DATABASE_NAME password=PASSWORD sslmode=disable"Core Concepts: Instance architecture, high availability (HA), and supported database engines.
CLI Usage: Essential gcloud sql commands for
instance, database, and user management.
Client Libraries & Connectors: Connecting to Cloud SQL using Python, Java, Node.js, and Go.
MCP Usage: Using the Cloud SQL remote MCP server and Gemini CLI extension.
Infrastructure as Code: Terraform configuration for instances, databases, and users.
IAM & Security: Predefined roles, SSL/TLS certificates, and Auth Proxy configuration.
If you need product information not found in these references, use the
Developer Knowledge MCP server search_documents tool.
© davila7, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
SKILL.md and 6 other files (references) in cli-tool/components/skills/database/cloud-sql-basics of davila7/claude-code-templates.
Open the folder on GitHubat commit 4c82aba
Cloud SQL Basics next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Cloud SQL Basics this skilldavila7/claude-code-templates | 32k | — | ~810 | Automated safety check: Pass | MIT | |
| Cloud SQL Basicsgoogle/skills | 21k | — | ~973 | Automated safety check: Pass | Apache-2.0 | |
| GCP Cloud SQLsickn33/agentic-awesome-skills | 47k | 2 repos | ~2.4k | Automated safety check: Pass | MIT | |
| Alloydb Basicsgoogle/skills | 21k | — | ~1.7k | Automated safety check: Pass | Apache-2.0 | |
| Database Migrations SQL Migrationsrmyndharis/antigravity-skills | 1.7k | 2 repos | ~577 | Automated safety check: Notes | MIT | |
| SQL ProJeffallan/claude-skills | 12k | — | ~1.3k | Automated safety check: Pass | MIT |
google/skills
This file generates or explains Cloud SQL resources. An agent skill from google/skills.
sickn33/agentic-awesome-skills
Provision Cloud SQL and Spanner databases. An agent skill from sickn33/agentic-awesome-skills.
google/skills
Manages clusters, instances, and backups for AlloyDB for PostgreSQL, and integrates with AlloyDB Model Context Protocol (MCP) tools for automated database operations.
rmyndharis/antigravity-skills
SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server
Jeffallan/claude-skills
Optimizes SQL queries and designs schemas using CTEs, window functions, covering indexes and EXPLAIN ANALYZE, with notes on dialect differences between major databases.
github/awesome-copilot
Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server…
davila7/claude-code-templates
Runs web-grounded searches through Perplexity's Sonar models over OpenRouter for current events, recent literature and cited facts beyond the model's training cutoff.
davila7/claude-code-templates
Analyzes Neuropixels recordings from SpikeGLX or Open Ephys through preprocessing, drift correction, Kilosort4 spike sorting, quality metrics and curation.
davila7/claude-code-templates
Supplies LaTeX templates and formatting rules for journals, conferences, posters, and grant proposals, then can check a draft against them.
davila7/claude-code-templates
Analyzes a brand's existing writing to lock in a consistent voice, then builds SEO blog posts and platform-specific social content around it.
davila7/claude-code-templates
Guides corrective and preventive action (CAPA) work in a quality management system, from initiation and root cause analysis through effectiveness verification.
davila7/claude-code-templates
Senior FDA consultant and specialist for medical device companies including HIPAA compliance and requirement management.
Categories
Creates and manages Cloud SQL instances for MySQL, PostgreSQL, and SQL Server. Cloud SQL Basics is an agent skill from davila7/claude-code-templates. Creates and manages Cloud SQL instances for MySQL, PostgreSQL, and SQL Server.
Cloud SQL Basics fits situations like: tasks that involve Backup and disaster recovery; tasks that involve SQL.
Run `npx skills add davila7/claude-code-templates --skill cloud-sql-basics -a claude-code`. Or copy the skill folder (cli-tool/components/skills/database/cloud-sql-basics in davila7/claude-code-templates) into .claude/skills/cloud-sql-basics in your project. Claude Code loads it when a task matches its description.
Run `npx skills add davila7/claude-code-templates --skill cloud-sql-basics -a codex`. Or copy the skill folder (cli-tool/components/skills/database/cloud-sql-basics in davila7/claude-code-templates) into .agents/skills/cloud-sql-basics in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add davila7/claude-code-templates --skill cloud-sql-basics -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/cloud-sql-basics, .gemini/skills/cloud-sql-basics, .github/skills/cloud-sql-basics and .opencode/skills/cloud-sql-basics in your project.
Going by SKILL.md and its folder, Cloud SQL Basics needs the command-line tools its instructions call (gcloud). Our summary lists: Node.js.
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
Cloud SQL Basics is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
About 810 tokens (SKILL.md is roughly 3.2k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 3.3k tokens, read only when the agent opens those files.
Skills that share tags, products or a category with Cloud SQL Basics: Cloud SQL Basics (google/skills, 21k stars), GCP Cloud SQL (sickn33/agentic-awesome-skills, 47k stars), Alloydb Basics (google/skills, 21k stars) and Database Migrations SQL Migrations (rmyndharis/antigravity-skills, 1.7k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
davila7 (a GitHub user) maintains it in davila7/claude-code-templates, which has 32,432 GitHub stars. The repository holds 477 skills in this directory. The repository was last updated on October 7, 2026.
Source: davila7/claude-code-templates on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.