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-to-RDBMS data type mapping tables, RDBMS-to-NoSQL conversion patterns, character set/collation conversion, and special type handling guide.

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/en/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.7k tokens
SKILL.md length
365 words
Files
1
Skills in repo
464
Repo updated
First seen
Licence
Apache-2.0

At a glance

RDBMS-to-RDBMS data type mapping tables, RDBMS-to-NoSQL conversion patterns, character set/collation conversion, and special type handling guide.

  • Requests involving type mapping
  • SKILL.md covers MySQL to PostgreSQL Mapping, Oracle to PostgreSQL Mapping, RDBMS to MongoDB Conversion… and Character Set / Collation…, plus 2 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
  • Data type conversion

What it does

Type Mapping Encyclopedia is an agent skill from revfactory/harness-100. 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', 'AUTOINCREMENT 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.

Its SKILL.md is about 1.7k 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, Data pipelines and ETL and Talk and speech writing. It works with PostgreSQL and MySQL. The licence is Apache-2.0.

When your agent uses it

  • Requests involving type mapping
  • Data type conversion
  • MySQL PostgreSQL conversion
  • Oracle migration

Example prompts

  • “type mapping”
  • “data type conversion”
  • “MySQL PostgreSQL conversion”
  • “/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.7k tokens when it runs. Until then it costs about 132 tokens; SKILL.md has 365 words of instructions outside code blocks.

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

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). 365 words, ~1,672 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-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.

Type Mapping Encyclopedia — Data Type Mapping Reference

A comprehensive reference for RDBMS-to-RDBMS data type mapping, special type conversions, and character set handling.

MySQL to PostgreSQL Mapping

MySQLPostgreSQLNotes
TINYINTSMALLINTTINYINT UNSIGNED -> SMALLINT
INTINTEGER
INT UNSIGNEDBIGINTPostgreSQL has no UNSIGNED
BIGINTBIGINT
FLOATREAL
DOUBLEDOUBLE PRECISION
DECIMAL(M,N)NUMERIC(M,N)Identical
VARCHAR(N)VARCHAR(N)
CHAR(N)CHAR(N)
TEXTTEXT
MEDIUMTEXTTEXTPostgreSQL TEXT has no size limit
LONGTEXTTEXT
BLOBBYTEA
LONGBLOBBYTEAOr use Large Object
DATEDATE
DATETIMETIMESTAMPMySQL: not UTC; PG: timezone option
TIMESTAMPTIMESTAMPTZMySQL: auto UTC conversion
TIMETIME
YEARSMALLINT
ENUM('a','b')VARCHAR + CHECKOr CREATE TYPE
SET('a','b')VARCHAR[]Or normalize
JSONJSONBJSONB recommended (indexable)
BIT(N)BIT(N)
BOOLEANBOOLEANMySQL TINYINT(1) -> BOOLEAN
AUTO_INCREMENTGENERATED ALWAYS AS IDENTITYOr SERIAL (legacy)
Special Conversion Patterns
sql
-- MySQL ENUM -> PostgreSQL
-- Method 1: CHECK constraint
CREATE TABLE orders (
    status VARCHAR(20) CHECK (status IN ('pending', 'paid', 'shipped'))
);

-- Method 2: Custom type
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 trigger
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 to PostgreSQL Mapping

OraclePostgreSQLNotes
NUMBERNUMERICPrecision specification required
NUMBER(N,0)INTEGER/BIGINTChoose based on size
VARCHAR2(N)VARCHAR(N)
CHAR(N)CHAR(N)
CLOBTEXT
BLOBBYTEA
DATETIMESTAMPOracle DATE includes time!
TIMESTAMP WITH TIME ZONETIMESTAMPTZ
RAWBYTEA
LONGTEXTDeprecated — migration recommended
NVARCHAR2VARCHARPostgreSQL defaults to UTF-8
ROWIDN/AUse ctid or custom key
SEQUENCESEQUENCESimilar syntax
SYSDATECURRENT_TIMESTAMP
NVL()COALESCE()
DECODE()CASE WHEN

RDBMS to MongoDB Conversion Patterns

Denormalization Strategy
Relational:                      Document:
+- users -+  +- orders -+      {
| id       |  | id       |        _id: ObjectId,
| name     |  | user_id  |->      name: "John Doe",
| email    |  | total    |        email: "john@test.com",
+----------+  | items[]  |        orders: [
               +----------+          { total: 50000,
                                      items: [
                                        { product: "A", qty: 2 }
                                      ]
                                    }
                                  ]
                                }
Show full SKILL.md (160 more words)Show less
Embedding vs. Reference Decision
CriterionEmbedding (Nested)Reference (Separate)
Relationship1:1, 1:Few1:Many, M:N
Read patternAlways queried togetherFrequently queried independently
Update frequencyUpdated with parentUpdated independently
Data size< 16MB (document limit)Size independent
DuplicationAcceptableDeduplication required

Character Set / Collation Conversion

MySQL to PostgreSQL
sql
-- MySQL character set check
SHOW VARIABLES LIKE 'character_set%';
SELECT character_set_name, collation_name
FROM information_schema.columns WHERE table_name = 'users';

-- PostgreSQL collation
-- MySQL utf8mb4_general_ci -> PostgreSQL ICU collation
CREATE COLLATION korean_ci (
    provider = icu, locale = 'ko-u-ks-level1', deterministic = false
);

-- Case-insensitive comparison
-- MySQL: utf8mb4_general_ci (default)
-- PostgreSQL: citext extension or LOWER() index
CREATE EXTENSION IF NOT EXISTS citext;
ALTER TABLE users ALTER COLUMN email TYPE citext;
Encoding Conversion Notes
IssueSymptomSolution
MySQL utf8 (3-byte)Emojis breakConvert to utf8mb4 before migration
Latin1 to UTF8CJK characters corruptedRoute through binary intermediate step
EUC-KR to UTF8Rare CJK characters lostUse mapping tables
CP949 to UTF8Extended characters need verificationPre-validate with iconv

Irreversible Conversion Inventory

ConversionReason for IrreversibilityMitigation
ENUM -> VARCHARAllowed value constraint lostAdd CHECK constraint
UNSIGNED INT -> INTNegative range expandedReinforce with business rules
DATETIME -> TIMESTAMPTZTimezone info must be addedExplicitly state assumed TZ
ROWID -> ctidPhysical location dependentReplace with logical key
Oracle DATE -> PG DATETime portion lostUse TIMESTAMP instead
CLOB -> TEXTBehavior is identical--

Type Mapping Verification Queries

sql
-- Source (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;

-- Target (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 en/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.7kAutomated 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-to-RDBMS data type mapping tables, RDBMS-to-NoSQL conversion patterns, character set/collation conversion, and special type handling guide. Type Mapping Encyclopedia is an agent skill from revfactory/harness-100. RDBMS-to-RDBMS data type mapping tables, RDBMS-to-NoSQL conversion patterns, character set/collation conversion, and special type handling guide.

When should I use Type Mapping Encyclopedia?

Type Mapping Encyclopedia fits situations like: requests involving type mapping; data type conversion; mySQL PostgreSQL conversion; oracle migration.

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 (en/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 (en/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.7k tokens (SKILL.md is roughly 6.7k 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.