New: 97,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

Type Mapping Encyclopedia

by revfactory in revfactory/harness-100

RDBMS 간 데이터 타입 매핑 테이블, RDBMS↔NoSQL 변환 패턴, 문자셋/콜레이션 변환, 특수 타입 처리 가이드.

Apache-2.0Auto-check passedDatabases

Install Type Mapping Encyclopedia

skills CLI
$ npx skills add revfactory/harness-100 --skill type-mapping-encyclopedia -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install revfactory/harness-100 type-mapping-encyclopedia --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/revfactory/harness-100.git skills-src && mkdir -p .claude/skills && cp -r skills-src/ko/34-data-migration/.claude/skills/type-mapping-encyclopedia .claude/skills/type-mapping-encyclopedia && rm -rf skills-src

Use ~/.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/

Facts

Skill name
type-mapping-encyclopedia
GitHub stars
1.3k
Token cost
~1.3k tokens
SKILL.md length
343 words
Files
1
Skills in repo
464
Repo updated
First seen
Licence
Apache-2.0

At a glance

RDBMS 간 데이터 타입 매핑 테이블, RDBMS↔NoSQL 변환 패턴, 문자셋/콜레이션 변환, 특수 타입 처리 가이드.

  • Tasks that involve NoSQL databases
  • SKILL.md covers MySQL → PostgreSQL 매핑, Oracle → PostgreSQL 매핑, RDBMS → MongoDB 변환 패턴 and 문자셋/콜레이션 변환, plus 2 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
  • Tasks that involve Data pipelines and ETL

What it does

Type Mapping Encyclopedia is an agent skill from revfactory/harness-100. RDBMS 간 데이터 타입 매핑 테이블, RDBMS↔NoSQL 변환 패턴, 문자셋/콜레이션 변환, 특수 타입 처리 가이드. '타입 매핑', '데이터 타입 변환', 'MySQL PostgreSQL 변환', 'Oracle 마이그레이션', '문자셋 변환', '콜레이션', 'AUTOINCREMENT 시퀀스', 'JSON 타입' 등 스키마 타입 변환 시 이 스킬을 사용한다. schema-mapper의 타입 변환 역량을 강화한다. 단, ETL 스크립트 작성이나 검증 쿼리는 이 스킬의 범위가 아니다.

Its SKILL.md is about 1.3k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering NoSQL databases and Data pipelines and ETL. It works with PostgreSQL and MySQL. The licence is Apache-2.0.

When your agent uses it

  • Tasks that involve NoSQL databases
  • Tasks that involve Data pipelines and ETL

Example prompts

  • “MySQL PostgreSQL 변환”
  • “Oracle 마이그레이션”
  • “AUTOINCREMENT 시퀀스”
  • “/type-mapping-encyclopedia”

What it can do on your machine

Read from SKILL.md and the folder at commit 8e8d35c. It shows what the files ask for, not the result of running them.

  • Tool permissions

    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.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are sql).

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Type Mapping Encyclopedia loads about 1.3k tokens when it runs. Until then it costs about 76 tokens; SKILL.md has 343 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~76
When it runs · the whole SKILL.md, loaded when a task matches
~1.3k

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.

Safety

Auto-check passed

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.

SKILL.md

The full file from revfactory/harness-100 at commit 8e8d35c, republished under its Apache-2.0 licence (© revfactory). 343 words, ~1,345 tokens.

Download SKILL.mdSave it as .claude/skills/type-mapping-encyclopedia/SKILL.md (or your agent's skills folder).
name
type-mapping-encyclopedia
description
RDBMS 간 데이터 타입 매핑 테이블, RDBMS↔NoSQL 변환 패턴, 문자셋/콜레이션 변환, 특수 타입 처리 가이드. '타입 매핑', '데이터 타입 변환', 'MySQL PostgreSQL 변환', 'Oracle 마이그레이션', '문자셋 변환', '콜레이션', 'AUTO_INCREMENT 시퀀스', 'JSON 타입' 등 스키마 타입 변환 시 이 스킬을 사용한다. schema-mapper의 타입 변환 역량을 강화한다. 단, ETL 스크립트 작성이나 검증 쿼리는 이 스킬의 범위가 아니다.

Type Mapping Encyclopedia — 데이터 타입 매핑 백과사전

RDBMS 간 데이터 타입 매핑, 특수 타입 변환, 문자셋 처리를 위한 종합 레퍼런스.

MySQL → PostgreSQL 매핑

MySQLPostgreSQL주의사항
TINYINTSMALLINTTINYINT UNSIGNED → SMALLINT
INTINTEGER
INT UNSIGNEDBIGINTPostgreSQL에 UNSIGNED 없음
BIGINTBIGINT
FLOATREAL
DOUBLEDOUBLE PRECISION
DECIMAL(M,N)NUMERIC(M,N)동일
VARCHAR(N)VARCHAR(N)
CHAR(N)CHAR(N)
TEXTTEXT
MEDIUMTEXTTEXTPostgreSQL TEXT 크기 제한 없음
LONGTEXTTEXT
BLOBBYTEA
LONGBLOBBYTEA또는 Large Object
DATEDATE
DATETIMETIMESTAMPMySQL: UTC 아님, PG: 타임존 옵션
TIMESTAMPTIMESTAMPTZMySQL: UTC 변환 자동
TIMETIME
YEARSMALLINT
ENUM('a','b')VARCHAR + CHECK또는 CREATE TYPE
SET('a','b')VARCHAR[]또는 정규화
JSONJSONBJSONB 권장 (인덱싱 가능)
BIT(N)BIT(N)
BOOLEANBOOLEANMySQL TINYINT(1) → BOOLEAN
AUTO_INCREMENTGENERATED ALWAYS AS IDENTITY또는 SERIAL (레거시)
특수 변환 패턴
sql
-- MySQL ENUM → PostgreSQL
-- 방법 1: CHECK 제약
CREATE TABLE orders (
    status VARCHAR(20) CHECK (status IN ('pending', 'paid', 'shipped'))
);

-- 방법 2: 사용자 정의 타입
CREATE TYPE order_status AS ENUM ('pending', 'paid', 'shipped');
CREATE TABLE orders (status order_status);

-- MySQL AUTO_INCREMENT → PostgreSQL IDENTITY
-- MySQL:
CREATE TABLE users (id INT AUTO_INCREMENT PRIMARY KEY);
-- PostgreSQL:
CREATE TABLE users (id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY);

-- MySQL ON UPDATE CURRENT_TIMESTAMP → PostgreSQL 트리거
CREATE OR REPLACE FUNCTION update_modified_column()
RETURNS TRIGGER AS $$
BEGIN NEW.updated_at = CURRENT_TIMESTAMP; RETURN NEW; END;
$$ LANGUAGE plpgsql;
CREATE TRIGGER update_timestamp BEFORE UPDATE ON users
FOR EACH ROW EXECUTE FUNCTION update_modified_column();

Oracle → PostgreSQL 매핑

OraclePostgreSQL주의사항
NUMBERNUMERIC정밀도 지정 필요
NUMBER(N,0)INTEGER/BIGINT크기에 따라 선택
VARCHAR2(N)VARCHAR(N)
CHAR(N)CHAR(N)
CLOBTEXT
BLOBBYTEA
DATETIMESTAMPOracle DATE는 시간 포함!
TIMESTAMP WITH TIME ZONETIMESTAMPTZ
RAWBYTEA
LONGTEXT사용 중단 권장
NVARCHAR2VARCHARPostgreSQL UTF-8 기본
ROWID없음ctid 또는 자체 키 사용
SEQUENCESEQUENCE구문 유사
SYSDATECURRENT_TIMESTAMP
NVL()COALESCE()
DECODE()CASE WHEN

RDBMS → MongoDB 변환 패턴

정규화 해제 전략
관계형:                          문서형:
┌─ users ─┐  ┌─ orders ─┐      {
│ id       │  │ id       │        _id: ObjectId,
│ name     │  │ user_id  │→       name: "홍길동",
│ email    │  │ total    │        email: "hong@test.com",
└──────────┘  │ items[]  │        orders: [
              └──────────┘          { total: 50000,
                                      items: [
                                        { product: "A", qty: 2 }
                                      ]
                                    }
                                  ]
                                }
임베딩 vs 참조 결정
기준임베딩 (내포)참조 (분리)
관계1:1, 1:Few1:Many, M:N
읽기 패턴항상 함께 조회독립 조회 빈번
변경 빈도부모와 동시 변경독립 변경 빈번
데이터 크기< 16MB (문서 제한)크기 무관
중복허용 가능중복 제거 필요

문자셋/콜레이션 변환

MySQL → PostgreSQL
sql
-- MySQL 문자셋 확인
SHOW VARIABLES LIKE 'character_set%';
SELECT character_set_name, collation_name
FROM information_schema.columns WHERE table_name = 'users';

-- PostgreSQL 콜레이션
-- MySQL utf8mb4_general_ci → PostgreSQL ICU 콜레이션
CREATE COLLATION korean_ci (
    provider = icu, locale = 'ko-u-ks-level1', deterministic = false
);

-- 대소문자 무시 비교
-- MySQL: utf8mb4_general_ci (기본)
-- PostgreSQL: citext 확장 또는 LOWER() 인덱스
CREATE EXTENSION IF NOT EXISTS citext;
ALTER TABLE users ALTER COLUMN email TYPE citext;
인코딩 변환 주의사항
이슈증상해결
MySQL utf8 (3바이트)이모지 깨짐utf8mb4로 변환 후 마이그레이션
Latin1 → UTF8한글 깨짐바이너리 중간 단계 경유
EUC-KR → UTF8특수 한자 손실매핑 테이블 사용
CP949 → UTF8확장 한글 확인iconv 사전 검증

비가역 변환 목록

변환비가역 이유대응
ENUM → VARCHAR허용 값 제약 손실CHECK 제약 추가
UNSIGNED INT → INT음수 범위 확장비즈니스 규칙으로 보강
DATETIME → TIMESTAMPTZ타임존 정보 추가 필요기본 TZ 가정 명시
ROWID → ctid물리적 위치 의존논리적 키로 대체
Oracle DATE → PG DATE시간 부분 손실TIMESTAMP 사용
CLOB → TEXT동작은 동일—

타입 매핑 검증 쿼리

sql
-- 소스 (MySQL)
SELECT column_name, data_type, column_type,
       character_maximum_length, numeric_precision, numeric_scale,
       is_nullable, column_default, extra
FROM information_schema.columns
WHERE table_schema = 'mydb' AND table_name = 'orders'
ORDER BY ordinal_position;

-- 타깃 (PostgreSQL)
SELECT column_name, data_type, udt_name,
       character_maximum_length, numeric_precision, numeric_scale,
       is_nullable, column_default
FROM information_schema.columns
WHERE table_schema = 'public' AND table_name = 'orders'
ORDER BY ordinal_position;

© revfactory, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in ko/34-data-migration/.claude/skills/type-mapping-encyclopedia of revfactory/harness-100.

Open the folder on GitHubat commit 8e8d35c

Compare with similar skills

Type Mapping Encyclopedia 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.

Type Mapping Encyclopedia compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Type Mapping Encyclopedia this skillrevfactory/harness-1001.3k—~1.3kAutomated safety check: PassApache-2.0
Database Adminaiskillstore/marketplace4306 repos~2.5kAutomated safety check: PassNone
Prisma Database Setupcurvenote/curvenote1693 repos~1.4kAutomated safety check: PassMIT
Golang Databaseunxed/f42402 repos~2.9kAutomated safety check: PassMIT
Database Expertcin12211/orca-q223—~2.8kAutomated safety check: PassMIT
DB SculptorEliasOulkadi/shokunin114—~3.1kAutomated safety check: NotesMIT

Similar skills

  • Database Admin

    aiskillstore/marketplace

    Expert database administrator specializing in modern cloud databases, automation, and reliability engineering.

    430 GitHub starsUsed in 6 repos~2.5k tokens
    DevOps & CloudAuto-check passed

  • Prisma Database Setup

    curvenote/curvenote

    Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.).

    169 GitHub starsUsed in 3 repos~1.4k tokens
    DatabasesAuto-check passed

  • Golang Database

    unxed/f4

    Comprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context…

    240 GitHub starsUsed in 2 repos~2.9k tokens
    DatabasesAuto-check passed

  • Database Expert

    cin12211/orca-q

    Database performance optimization, schema design, query analysis, and connection management across PostgreSQL, MySQL, MongoDB, and SQLite with ORM integration.

    223 GitHub stars~2.8k tokensUpdated 16 days ago
    DatabasesAuto-check passed

  • DB Sculptor

    EliasOulkadi/shokunin

    Design database schemas with Prisma/Drizzle, PostgreSQL index strategy (B-tree, GIN, GiST, BRIN, Hash), query optimization (EXPLAIN ANALYZE), migration safety (expand/contract, zero-downtime), and…

    114 GitHub stars~3.1k tokensUpdated 3 days ago
    DatabasesAuto-check: notes

  • Cosmosdb Nosql Query Generation

    microsoft/vscode-cosmosdb

    Official

    Generate, explain, edit, and fix Azure Cosmos DB for NoSQL (SQL API) queries.

    200 GitHub stars~4k tokensUpdated yesterday
    DatabasesAuto-check: warnings

More from revfactory/harness-100

All 464 skills in this repo

  • Anti Bot Analyzer

    revfactory/harness-100

    A skill for analyzing website anti-bot defense mechanisms and developing legitimate evasion strategies.

    1.3k GitHub stars~1.1k tokensUpdated 6 mo ago
    Auto-check passed

  • API Error Design Patterns

    revfactory/harness-100

    Reference for designing how an API reports failures: structured error codes, response shapes, client-friendly messages, an error catalog and retry or fallback advice.

    1.3k GitHub stars~1.6k tokensUpdated 6 mo ago
    Auto-check passed

  • API Security Checklist

    revfactory/harness-100

    Walks a backend-dev agent through OWASP API Top 10 checks, authentication and authorization patterns, and defense code during API design.

    1.3k GitHub stars~1.7k tokensUpdated 6 mo ago
    Auto-check passed

  • Arg Parser Generator

    revfactory/harness-100

    Methodology for systematically designing and generating CLI tool argument parser structures.

    1.3k GitHub stars~1.2k tokensUpdated 6 mo ago
    Auto-check passed

  • Audience Segmentation

    revfactory/harness-100

    Audience segmentation skill used by the analyst and curator agents.

    1.3k GitHub stars~1.3k tokensUpdated 6 mo ago
    Auto-check passed

  • Audio Storytelling

    revfactory/harness-100

    Audio storytelling skill used by the podcast scriptwriter and show note editor.

    1.3k GitHub stars~1.6k tokensUpdated 6 mo ago
    Auto-check passed

Works with

Categories

Questions about Type Mapping Encyclopedia

What does Type Mapping Encyclopedia do?

RDBMS 간 데이터 타입 매핑 테이블, RDBMS↔NoSQL 변환 패턴, 문자셋/콜레이션 변환, 특수 타입 처리 가이드. Type Mapping Encyclopedia is an agent skill from revfactory/harness-100. RDBMS 간 데이터 타입 매핑 테이블, RDBMS↔NoSQL 변환 패턴, 문자셋/콜레이션 변환, 특수 타입 처리 가이드.

When should I use Type Mapping Encyclopedia?

Type Mapping Encyclopedia fits situations like: tasks that involve NoSQL databases; tasks that involve Data pipelines and ETL.

How do I install Type Mapping Encyclopedia in Claude Code?

Run `npx skills add revfactory/harness-100 --skill type-mapping-encyclopedia -a claude-code`. Or copy the skill folder (ko/34-data-migration/.claude/skills/type-mapping-encyclopedia in revfactory/harness-100) into .claude/skills/type-mapping-encyclopedia in your project. Claude Code loads it when a task matches its description.

How do I install Type Mapping Encyclopedia in Codex?

Run `npx skills add revfactory/harness-100 --skill type-mapping-encyclopedia -a codex`. Or copy the skill folder (ko/34-data-migration/.claude/skills/type-mapping-encyclopedia in revfactory/harness-100) into .agents/skills/type-mapping-encyclopedia in your project. Codex loads it when a task matches its description.

Can I use Type Mapping Encyclopedia in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add revfactory/harness-100 --skill type-mapping-encyclopedia -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/type-mapping-encyclopedia, .gemini/skills/type-mapping-encyclopedia, .github/skills/type-mapping-encyclopedia and .opencode/skills/type-mapping-encyclopedia in your project.

What does Type Mapping Encyclopedia need to run?

SKILL.md names no scripts, command-line tools or credentials: Type Mapping Encyclopedia is instructions for the agent only.

Does Type Mapping Encyclopedia access the network?

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.

Is Type Mapping Encyclopedia safe to install?

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.

What licence does Type Mapping Encyclopedia use?

Type Mapping Encyclopedia is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Type Mapping Encyclopedia use?

About 1.3k tokens (SKILL.md is roughly 5.4k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Type Mapping Encyclopedia?

Skills that share tags, products or a category with Type Mapping Encyclopedia: Database Admin (aiskillstore/marketplace, 430 stars), Prisma Database Setup (curvenote/curvenote, 169 stars), Golang Database (unxed/f4, 240 stars) and Database Expert (cin12211/orca-q, 223 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Type Mapping Encyclopedia?

revfactory (a GitHub user) maintains it in revfactory/harness-100, which has 1,290 GitHub stars. The repository holds 464 skills in this directory. The repository was last updated on March 22, 2026.

Source: revfactory/harness-100 on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.