hello-perf
ไผๅๆง่ฝใๅค็ๆฐๆฎๅบๆฅ่ฏขใๅฎ็ฐ็ผๅญใๆๅ ่ฝฝใๅ้กตใๆๅ ไผๅ๏ผๆไปฃ็ ๆถๅๅคงๆฐๆฎ้ๅพช็ฏใๅนถๅๆไฝใๅ ๅญ็ฎก็ๆถไฝฟ็จใ
ไผๅๆง่ฝใๅค็ๆฐๆฎๅบๆฅ่ฏขใๅฎ็ฐ็ผๅญใๆๅ ่ฝฝใๅ้กตใๆๅ ไผๅ๏ผๆไปฃ็ ๆถๅๅคงๆฐๆฎ้ๅพช็ฏใๅนถๅๆไฝใๅ ๅญ็ฎก็ๆถไฝฟ็จใ
Google BigQuery data warehouse queries and schema inspection. Use when running SQL queries, listing datasets/tables, or inspecting table schemas in BigQuery.
PostgreSQL database inspection and queries. Use when investigating table schemas, running queries, checking locks, replication status, or long-running queries.
Snowflake data warehouse queries and schema inspection. Use when running SQL queries against Snowflake, listing tables, or inspecting schemas.
Analyze database query performance with execution plans and index recommendations
Redis backend for conversation state persistence and caching
Translate SQL queries between different database dialects with function mapping and optimization
Searches M&A and funding databases for relevant comparable transactions
PostgreSQL query optimization, indexing, full-text search, JSONB, and advanced features.
Prisma ORM schema design, migrations, relations, query optimization, and database integration patterns.
Database schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL databases. Use for designing schemas, writing migrations, or optimizing queries.
Migrate a codebase from @skyscanner/backpack-web v41.x to v42.0. Handles BpkButtonV2 โ BpkButton rename, deep import removal, and BpkAutosuggest legacy โ V2 API migration. Use when upgrading Backpack to v42.
Supabase specialist covering PostgreSQL 16, pgvector, RLS, real-time subscriptions, and Edge Functions. Use when building full-stack apps with Supabase backend.
Migration data validation patterns: row count comparison, checksums, sampling validation, FK integrity, and business rule validation query design guide. Use this skill for requests involving 'data validation', 'migration validation', 'checksum', 'row count comparison', 'integrity validation', 'regression testing', 'Go/No-Go checklist', etc. Enhances validation-engineer's validation design capabilities. Note: schema mapping and rollback planning are outside the scope of this skill.
caching strategy(Cache Aside, Write Through, Write Behind etc.) optional and Redis/Memcached for, TTL , cache invalid-ize pattern guide. 'caching strategy', 'Redis', 'cache invalid-ize', 'TTL', 'Cache Aside', 'Write Through', 'CDN caching', 'cache ' etc. caching this for. optimization-engineerof caching -ize. , before performance profilingthis benchmark this of scope .
์บ์ฑ ์ ๋ต(Cache Aside, Write Through, Write Behind ๋ฑ) ์ ํ ๋งคํธ๋ฆญ์ค์ Redis/Memcached ํ์ฉ, TTL ์ค๊ณ, ์บ์ ๋ฌดํจํ ํจํด ๊ฐ์ด๋. '์บ์ฑ ์ ๋ต', 'Redis', '์บ์ ๋ฌดํจํ', 'TTL', 'Cache Aside', 'Write Through', 'CDN ์บ์ฑ', '์บ์ ์คํฌํผ๋' ๋ฑ ์บ์ฑ ์ค๊ณ ์ ์ด ์คํฌ์ ์ฌ์ฉํ๋ค. optimization-engineer์ ์บ์ฑ ์ค๊ณ ์ญ๋์ ๊ฐํํ๋ค. ๋จ, ์ ์ฒด ์ฑ๋ฅ ํ๋กํ์ผ๋ง์ด๋ ๋ฒค์น๋งํฌ๋ ์ด ์คํฌ์ ๋ฒ์๊ฐ ์๋๋ค.
SQL/NoSQL query optimization pattern, execution plan analysis, index strategy, N+1 resolution etc. database performance optimization guide. 'query optimization', 'execution plan', 'EXPLAIN', 'index ', 'N+1 ', 'slow query', 'slow query', 'DB performance' etc. database query performance improvement this for. bottleneck-analystand optimization-engineerof DB performance analysis -ize. , before system profilingthis benchmark execution this of scope .
RDBMS-to-RDBMS data type mapping tables, RDBMS-to-NoSQL conversion patterns, character set/collation conversion, and special type handling guide. Use this skill for requests involving 'type mapping', 'data type conversion', 'MySQL PostgreSQL conversion', 'Oracle migration', 'character set conversion', 'collation', 'AUTO_INCREMENT sequence', 'JSON type', etc. Enhances schema-mapper's type conversion capabilities. Note: ETL script writing and validation queries are outside the scope of this skill.
DB ์ค๊ณ ํ ํ์ดํ๋ผ์ธ. ๋ฐ์ดํฐ ๋ชจ๋ธ๋งโ๋ง์ด๊ทธ๋ ์ด์ โ์ธ๋ฑ์ฑโ์ฟผ๋ฆฌ ์ต์ ํโ๋ณด์ ๊ฒ์ฆ์ ์์ด์ ํธ ํ์ด ํ์ ํ์ฌ ์ํํ๋ค. 'DB ์ค๊ณํด์ค', '๋ฐ์ดํฐ๋ฒ ์ด์ค ๋ชจ๋ธ๋ง', 'ํ ์ด๋ธ ์ค๊ณ', 'ERD', '๋ง์ด๊ทธ๋ ์ด์ ', '์ฟผ๋ฆฌ ์ต์ ํ', '์ธ๋ฑ์ค ์ค๊ณ', 'SQL ์คํค๋ง', 'PostgreSQL ์ค๊ณ', 'MySQL ์ค๊ณ' ๋ฑ DB ์ค๊ณ ์ ๋ฐ์ ์ด ์คํฌ์ ์ฌ์ฉํ๋ค. ๊ธฐ์กด ์คํค๋ง๊ฐ ์๋ ๊ฒฝ์ฐ์๋ ์ต์ ํ๋ ๋ณด์ ๊ฐ์ฌ๋ฅผ ์ง์ํ๋ค. ๋จ, ์ค์ DB ์๋ฒ ์ค์น/์ด์, ํด๋ผ์ฐ๋ ์ธํ๋ผ ํ๋ก๋น์ ๋, ๋ชจ๋ํฐ๋ง ๋์๋ณด๋ ๊ตฌ์ถ์ ์ด ์คํฌ์ ๋ฒ์๊ฐ ์๋๋ค.
RDBMS ๊ฐ ๋ฐ์ดํฐ ํ์ ๋งคํ ํ ์ด๋ธ, RDBMSโNoSQL ๋ณํ ํจํด, ๋ฌธ์์ /์ฝ๋ ์ด์ ๋ณํ, ํน์ ํ์ ์ฒ๋ฆฌ ๊ฐ์ด๋. 'ํ์ ๋งคํ', '๋ฐ์ดํฐ ํ์ ๋ณํ', 'MySQL PostgreSQL ๋ณํ', 'Oracle ๋ง์ด๊ทธ๋ ์ด์ ', '๋ฌธ์์ ๋ณํ', '์ฝ๋ ์ด์ ', 'AUTO_INCREMENT ์ํ์ค', 'JSON ํ์ ' ๋ฑ ์คํค๋ง ํ์ ๋ณํ ์ ์ด ์คํฌ์ ์ฌ์ฉํ๋ค. schema-mapper์ ํ์ ๋ณํ ์ญ๋์ ๊ฐํํ๋ค. ๋จ, ETL ์คํฌ๋ฆฝํธ ์์ฑ์ด๋ ๊ฒ์ฆ ์ฟผ๋ฆฌ๋ ์ด ์คํฌ์ ๋ฒ์๊ฐ ์๋๋ค.
Integrates Firebase Realtime Database into Flutter apps. Use when setting up Realtime Database, structuring JSON data, querying, performing read/write operations, implementing offline capabilities, or applying security rules.
Analyze and optimize SQL queries for better performance