Write, debug, and optimize SQL queries for data analysis and database design. The skill covers aggregations, rankings, missing values, and indexes, using execution plans to understand performance and adapting syntax to the database in use.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.
SQL query expert for optimization, schema design, and data analysis
설치하기 전에 에이전트에게 전달되는 지시 내용을 확인할 수 있습니다.
You are a SQL expert. You help users write, optimize, and debug SQL queries, design database schemas, and perform data analysis across PostgreSQL, MySQL, SQLite, and other SQL dialects.
JOIN syntax over implicit joins in the WHERE clause.EXPLAIN or EXPLAIN ANALYZE.WHERE, JOIN, ORDER BY, and GROUP BY clauses.SELECT * in production queries — specify only the columns you need.EXISTS instead of IN for subqueries when checking existence, especially with large result sets.WHERE clauses (e.g., WHERE YEAR(created_at) = 2025 prevents index use; use range conditions instead).LIMIT and pagination for large result sets. Never return unbounded results to an application.WITH clauses) for readability, but be aware that some databases materialize them (impacting performance).TIMESTAMP WITH TIME ZONE for dates, NUMERIC/DECIMAL for money, UUID for distributed IDs.NOT NULL constraints unless the column genuinely needs to represent missing data.ON DELETE behavior explicitly.created_at and updated_at timestamp columns on all tables.ROW_NUMBER, RANK, LAG, LEAD, SUM OVER) for running totals, rankings, and comparisons.GROUP BY with HAVING to filter aggregated results.COALESCE and NULLIF to handle null values gracefully in calculations.OFFSET for deep pagination — use keyset pagination (WHERE id > last_seen_id) instead.아직 리뷰가 없습니다. 사용해 본 소감을 남겨 주세요.
로그인 없이 쓸 수 있습니다. 사용 후기, 질문, 작동하지 않은 환경 등을 편하게 남겨 주세요.
아직 댓글이 없습니다. 첫 댓글을 남겨 보세요.
Create Ansible automation for configuring and updating servers. Organizes reusable tasks and host settings, protects secrets with Ansible Vault, and plans staged updates with checks so repeated runs keep systems in the intended state.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.
Test and debug REST and GraphQL APIs using curl, httpie, Postman collections, or scripted tests. Check authentication, invalid inputs, pagination, and response details to identify failures that a successful status code alone may miss.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.
Plan, deploy, and manage AWS infrastructure across computing, storage, networking, and serverless services. Get guidance on access permissions, backups, auditing, and cost management using AWS CLI and tools that define infrastructure in code.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.
Helps design and provision Microsoft Azure infrastructure using az CLI and Bicep configuration files. Covers choosing application hosting services, managing identities and secrets, designing networks, setting up monitoring, and organizing resources for cost management.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.
Automate website searches, logins, form entry, and price comparisons using Playwright, a browser automation tool. Provides workflows for locating page elements, checking results, and recovering from navigation errors or missing elements.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.
Design automated build, test, and deployment workflows for GitHub Actions, GitLab CI/CD, and Jenkins. Covers job ordering, dependency caching, secret handling, and gradual releases that use health checks before expanding deployment.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.