스킬 찾기

Write and improve SQL for major data warehouses, accounting for differences in their syntax. Use it to build analytical queries, translate existing SQL, investigate errors, and review slow queries for performance improvements.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Translate SQL from PostgreSQL to BigQuery
• Review slow queries for performance improvements
• Calculate retention rates and funnel conversion

Turn a plain-language data request into SQL tailored to your database. Build queries that combine tables, filter records, and calculate summaries, with explanations of each step, performance considerations, and suggestions for adjusting dates or other conditions.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Create SQL for order counts by status
• Analyze retention by signup month
• Query large tables with date-based partitions

Create or improve a company-specific data analysis skill by gathering analysts’ knowledge and examining database structures. Document business terms, metric formulas, table relationships, and common query patterns in reusable reference files.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Create a data analysis skill for a company
• Document metric formulas and standard exclusions
• Add knowledge about a new business domain

Turn repeated workflows into reusable Picoclaw skills, or update and review existing ones. Organize SKILL.md instructions, scripts, reference documents, and output assets, then check the structure and test representative tasks.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Turning a repeated workflow into a reusable skill
• Updating or reviewing an existing SKILL.md
• Organizing scripts, references, and templates

Plan a prospective clinical study by ranking endpoints, estimating participant numbers and statistical power, and assessing feasibility. Outputs include assumptions and named reviewers, providing material for expert review before a protocol is finalized.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Choosing primary and secondary study endpoints
• Estimating sample size with dropout allowance
• Assessing feasibility before a study review

Automate Google Workspace tasks with the gws command-line tool, including email, file management, spreadsheets, and scheduling. Get guidance on installation, authentication, reusable workflow templates, and security audits of sharing and account settings.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Automating Gmail sending and inbox organization
• Managing Drive files and sharing permissions
• Reading and updating Sheets data

Design and operate shared secret storage with HashiCorp Vault or cloud services. The skill guides access policies, automated credential rotation, temporary credentials, audit analysis, and secret delivery to applications and deployment pipelines.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Setting up Vault or a cloud secret store
• Automating database password and API key rotation
• Auditing access to secrets

Design Google Cloud infrastructure around application needs, scale, and budget. Get service recommendations, cost estimates, infrastructure configuration files, and deployment guidance, with support for automated delivery and security configuration reviews.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Designing a mobile backend on Cloud Run
• Planning a SaaS architecture on GKE
• Building an event analytics pipeline with BigQuery

Create CI/CD configurations, which automate build, test, and deployment steps, alongside Terraform infrastructure templates and Kubernetes deployment files. Generate health-check and rollback instructions to review before applying changes to cloud infrastructure or application environments.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Setting up GitHub Actions or CircleCI pipelines
• Creating Terraform modules for AWS, GCP, or Azure
• Preparing blue/green or rolling deployments

Review cloud permissions, public storage access, network rules, and infrastructure definitions for security gaps. The skill helps identify risky configurations, rank findings by severity, and suggest narrower permissions, with fuller coverage for AWS than Azure or GCP.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Reviewing cloud settings before deployment
• Finding excessive permissions and privilege escalation paths
• Checking public storage and exposed ports

Design systems that collect, transform, and store data. Choose between scheduled and continuous processing, generate workflow configurations, validate data quality, and analyze performance using guidance for tools including Python, SQL, Spark, Airflow, dbt, and Kafka.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Designing data ingestion and transformation pipelines
• Choosing scheduled or real-time data processing
• Checking data freshness, completeness, and uniqueness

Audit environment files and repository contents for possible credential leaks, then prioritize findings by severity. Plan credential replacement, improve configuration examples, and establish checks in development and delivery pipelines to reduce accidental exposure.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Checking configuration files before a commit
• Planning credential replacement after a leak
• Keeping environment examples safe for new contributors

Helps startup leaders make strategic data decisions: assess permission to train AI on customer data, choose data architecture, evaluate customer data as a business asset, and sequence hiring around the decisions the business needs to make.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Assessing customer data for AI training
• Choosing data architecture and what to build or buy
• Evaluating data assets before fundraising or M&A

Create or update Codex skills that package specialized knowledge, repeatable workflows, and tool instructions. The guide covers concrete use cases, folder structure, reusable resources, starter generation, and basic validation of names and required metadata.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Turning recurring work into a reusable skill
• Packaging company knowledge and API instructions
• Reorganizing an existing skill and its reference files

Turn everyday questions into SQL queries, the commands used to retrieve and summarize database records. Uses your database structure and platform to produce queries with explanations, performance notes, and optional validation scripts.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Extract users who meet specific activity conditions
• Build revenue reports by region and customer tier
• Create queries from database diagrams

Match Google Cloud data residency and access requirements to available data boundary frameworks and cloud controls. Compare ranked recommendations in a table, see requirement gaps, and receive deployment guidance with built-in frameworks prioritized.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Finding frameworks for data residency requirements
• Comparing framework coverage and major requirement gaps
• Planning deployment for existing or new projects

Design and create custom cloud controls and frameworks for Google Cloud data boundary requirements that existing resources cannot meet. Receive prepared configuration fields for manual setup, or approve creation through the agent.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Designing controls for requirements existing frameworks cannot meet
• Preparing configuration fields for the Google Cloud console
• Creating a framework that groups newly authored controls

Diagnose GKE TPU node pool creation or expansion failures despite reserved capacity. Trace which virtual machines and unhealthy node pools occupy reservation slots, check automatic repair settings, and provide remediation steps for the user to apply.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Investigate TPU capacity errors despite a reservation
• Identify node pools occupying reserved TPU capacity
• Check automatic repair settings on unhealthy TPU nodes

Configure authentication and per-project request limits for Google Cloud API Gateway. Secure access to Cloud Run backends, validate quota changes against existing configurations, and investigate HTTP 429 or Service Control Quota errors, including on MCP-enabled gateways.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Configure API key and JWT authentication
• Restrict direct access to Cloud Run backends
• Validate request quota changes before deployment

Diagnose GKE TPU virtual machines that remain in repair by checking instance status, host events, and automatic repair history. Understand the impact on grouped TPU nodes and identify recovery steps for the user to apply.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Investigating TPU VMs that remain in REPAIRING
• Assessing how a failed node affects a TPU slice
• Checking automatic repair history and failure reasons

Assess existing Google Cloud folders and projects through read-only discovery. Compare resource locations, service usage, and customer-managed encryption requirements with Assured Workloads frameworks, then report suitable options and policy readiness findings.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Assess an existing folder or project's policy readiness
• Compare EU or US data boundary frameworks
• Review location, service, and encryption readiness

Expose REST APIs as tools for AI agents through Google Cloud API Gateway using MCP, a protocol for connecting agents to tools. Covers OpenAPI migration, authentication, client connections, validation, and troubleshooting.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Expose existing REST APIs as agent tools
• Migrate OpenAPI 2.0 specifications for MCP
• Protect tool listings with JWTs or API keys

Creates Terraform configuration for Google Cloud Monitoring notification channels, including email, Slack, and Pub/Sub, and attaches channels to existing alert policies. It also checks Pub/Sub topic compatibility and publishing permissions when inspecting the cloud environment.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Configuring email or Slack alert notifications
• Adding notification channels to existing alert policies
• Checking Pub/Sub topic compatibility and publishing permissions

Implement Google sign-in for web applications using Google Identity Services. Add sign-in buttons or One Tap, verify ID tokens as proof of identity, configure browser security policies, and handle sessions, sign-out, and account disconnection.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Adding Google sign-in to a React or Next.js application
• Verifying ID tokens and restricting Workspace domains
• Configuring One Tap and preventing automatic sign-in after logout