스킬 찾기

Design and review Java database code using MyBatis and MyBatis-Spring. Covers mapping query results to objects, safe SQL parameters, transactions, pagination, batch writes, and investigating slow or unnecessarily repeated queries.

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

• Designing mapper interfaces and XML mappings
• Reviewing dynamic SQL and parameter safety
• Checking transactions across multiple updates

Build Bengali search and AI features with guidance on consistent character encoding, word splitting, digit conversion, and safe text display. Includes patterns for cleaning training data, storing text, and handling Bengali alongside English.

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

• Implementing Bengali search and text input
• Cleaning Bengali text for model training
• Handling Bengali and English in chatbots

Plan database structure changes and existing data updates for production systems. Provides migration patterns for adding columns and indexes, switching applications in stages, and documenting recovery steps while accounting for downtime and database locks.

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

• Adding columns or indexes to production tables
• Updating large datasets in batches
• Planning a staged column replacement without downtime

Build and review Python tests with pytest. Use reusable setup, simulated external services, and multiple input cases to check behavior, then measure coverage—the proportion of code exercised by tests—and follow a test-first development cycle.

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

• Writing tests before implementing a Python feature
• Sharing test setup through reusable fixtures
• Testing external API behavior with mocks

Review Laravel authentication, permissions, database operations, forms, APIs, and production settings for security weaknesses. Use implementation examples to address unsafe input handling, exposed secrets, session risks, and insufficient access controls.

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

• Reviewing login and permission controls
• Checking database queries and input validation
• Reviewing forms for forged requests and unsafe scripts

Review MySQL and MariaDB database designs and production problems, including slow queries, locking, connection pools, and replica delays. Get concrete SQL or code changes and a validation plan that accounts for differences between engines and versions.

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

• Designing tables and indexes
• Investigating slow queries and deadlocks
• Reviewing migrations for large production tables

Document major technical choices as Architecture Decision Records, or ADRs. Capture the context, alternatives, reasons, and consequences, then organize related records and track whether decisions are proposed, accepted, retired, or replaced.

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

• Recording reasons for choosing a framework or database
• Comparing design options and their trade-offs
• Sharing past decisions with new team members

Assess database security within an authorized scope by reviewing network exposure, authentication, access permissions, risky features, audit logs, and backup access. Distinguish configuration weaknesses from issues that can be demonstrated through safe validation.

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

• Reviewing database exposure and TLS settings
• Checking account privileges and sensitive table access
• Assessing dangerous features and configuration weaknesses

Plan and coordinate authorized penetration tests across multiple stages, from reconnaissance to access, privilege escalation, movement between systems, and impact assessment. Assign specialist skills, revise blocked paths, and maintain evidence and progress records for the final report.

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

• Plan a penetration test across multiple stages
• Assess how far a vulnerability could lead
• Replan from existing credentials or system access

Plan systems across AWS, Azure, GCP, and OCI by comparing services and architecture patterns. Helps guide service selection, disaster recovery, migration planning, and cost decisions while considering ways to reduce dependence on a single provider.

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

• Planning a system across multiple cloud providers
• Designing disaster recovery in another cloud
• Comparing cloud services for a workload

Set up MISP to collect threat feeds and centrally manage indicators such as suspicious IP addresses and domains. Configure automated synchronization, connect related findings, and export indicators to security monitoring platforms or blocklists.

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

• Centralizing threat indicators from multiple feeds
• Deploying MISP with Docker
• Automating threat feed synchronization

Document major technical decisions with their context, alternatives, reasoning, and consequences. The skill provides Architecture Decision Record templates and maintenance practices so teams can review past choices, track replacements, and explain decisions to new members.

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

• Recording reasons for technology choices
• Comparing design options and trade-offs
• Explaining past decisions to new team members

Design a database layer from business requirements, access patterns, and expected growth. Compare database technologies, define tables and relationships, and plan indexes, caching, scaling, migrations, backups, and recovery with clear reasons and trade-offs.

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

• Choosing a database for a new service
• Designing tables, relationships, and indexes
• Planning database migrations and rollback procedures

Plan and implement database structure changes and data transfers using Sequelize, TypeORM, or Prisma. Covers staged changes to keep services running, rollback procedures to undo changes, backups, and migration verification.

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

• Add, rename, or change database columns
• Transform data into a new structure
• Prepare and test rollback procedures

Create and manage MySQL, PostgreSQL, and SQL Server databases on Google Cloud. Covers instance setup, users, backups, availability, and secure connections, with a PostgreSQL walkthrough and references for application connectors and Terraform configuration.

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

• Create a PostgreSQL database on Google Cloud
• Manage database users and passwords
• Connect through Cloud SQL Auth Proxy

Investigate database slowdowns and plan measurable improvements to queries, indexes, caching, and scaling. The skill covers SQL and NoSQL systems, with guidance on monitoring, load testing, migrations, and balancing performance against cost.

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

• Analyze slow SQL queries and execution plans
• Resolve repeated database calls in APIs
• Plan indexes and caching for high traffic

Choose an authentication flow for a Zoom integration, define scopes that control access, and understand token renewal. Use the reference examples and error tables to investigate failed authorization or token requests.

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

• Choosing authentication for Zoom backend automation
• Planning token renewal for a user-facing app
• Investigating redirect URI and authorization errors

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

Turn plain language requirements into SQL, investigate slow queries, document database structures, and prepare migration templates with rollback plans. Support everyday database development and ORM use, where libraries connect application code to database tables.

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

• Writing SQL for reports and data retrieval
• Investigating slow queries and repeated database calls
• Preparing schema changes and rollback plans

Design and review system architecture, compare databases and structural approaches, and document technical decisions. Included tools generate architecture diagrams, inspect dependencies, and assess project structure to identify circular relationships, excessive coupling, and opportunities for improvement.

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

• Comparing monolith and microservices approaches
• Choosing a database for project requirements
• Generating diagrams from an existing project

Review database structures and relationships, identify design issues, and generate relationship diagrams. The skill recommends indexes, which help queries find data efficiently, and prepares migration steps with validation and rollback planning.

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

• Reviewing table structures and relationships
• Improving indexes for frequent queries
• Planning database changes without downtime

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

Verify OpenWork changes by running the real product and following user or client actions. Choose suitable tests, capture screenshots and reports, and demonstrate that the check fails on dev but passes on the changed branch.

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

• Verifying real product behavior before opening a PR
• Preparing screenshots and test evidence for a reviewer
• Checking a fix against dev and the changed branch

Manage OpenWork feature releases with feature flags, switches that control access to new behavior. Register features before coding, release them by organization and deployment, prepare a global shutdown option, and remove temporary flags after rollout.

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

• Registering a feature before implementation
• Releasing a feature to selected organizations
• Separating cloud and self-hosted availability