New: 98,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

Migrating Oracle To Postgres Stored Procedures

by boshi-xixixi in boshi-xixixi/TraeSkill

Migrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL.

MITAuto-check passedDatabases

Install Migrating Oracle To Postgres Stored Procedures

skills CLI
$ npx skills add boshi-xixixi/TraeSkill --skill migrating-oracle-to-postgres-stored-procedures -a claude-code

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

GitHub CLI
$ gh skill install boshi-xixixi/TraeSkill migrating-oracle-to-postgres-stored-procedures --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/boshi-xixixi/TraeSkill.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.trae/Skills/.agents/skills/migrating-oracle-to-postgres-stored-procedures .claude/skills/migrating-oracle-to-postgres-stored-procedures && 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
migrating-oracle-to-postgres-stored-procedures
GitHub stars
276
Token cost
~576 tokens
SKILL.md length
190 words
Files
1
Skills in repo
16
Repo updated
First seen
Licence
MIT

At a glance

Migrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL.

  • Converting Oracle stored procedures
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
  • Functions to PostgreSQL equivalents during a database migration

What it does

Migrating Oracle To Postgres Stored Procedures is an agent skill from boshi-xixixi/TraeSkill. Migrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL. Translates Oracle-specific syntax, preserves method signatures and type-anchored parameters, leverages orafce where appropriate, and applies COLLATE "C" for Oracle-compatible text sorting. Use when converting Oracle stored procedures or functions to PostgreSQL equivalents during a database migration.

Its SKILL.md is about 580 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 Database migrations and SQL. It works with PostgreSQL, SQL and GitHub. The repository describes itself as: 为 Trae IDE 打造的全流程标准化 AI 开发技能库，内置调度分发与多角色研发技能，一键导入规范 AI 编码工作流 🚀. The licence is MIT.

When your agent uses it

  • Converting Oracle stored procedures
  • Functions to PostgreSQL equivalents during a database migration

Example prompts

  • “Use the migrating-oracle-to-postgres-stored-procedures skill to migrate Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL”
  • “/migrating-oracle-to-postgres-stored-procedures”

What it can do on your machine

Read from SKILL.md and the folder at commit 9cf38e6. 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.

    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

Migrating Oracle To Postgres Stored Procedures loads about 576 tokens when it runs. Until then it costs about 103 tokens; SKILL.md has 190 words of instructions outside code blocks.

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

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 boshi-xixixi/TraeSkill at commit 9cf38e6, republished under its MIT licence (© boshi-xixixi). 190 words, ~576 tokens.

Download SKILL.mdSave it as .claude/skills/migrating-oracle-to-postgres-stored-procedures/SKILL.md (or your agent's skills folder).
name
migrating-oracle-to-postgres-stored-procedures
description
Migrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL. Translates Oracle-specific syntax, preserves method signatures and type-anchored parameters, leverages orafce where appropriate, and applies COLLATE "C" for Oracle-compatible text sorting. Use when converting Oracle stored procedures or functions to PostgreSQL equivalents during a database migration.

Migrating Stored Procedures from Oracle to PostgreSQL

Translate Oracle PL/SQL stored procedures and functions to PostgreSQL PL/pgSQL equivalents.

Workflow

Progress:
- [ ] Step 1: Read the Oracle source procedure
- [ ] Step 2: Translate to PostgreSQL PL/pgSQL
- [ ] Step 3: Write the migrated procedure to Postgres output directory

Step 1: Read the Oracle source procedure

Read the Oracle stored procedure from .github/oracle-to-postgres-migration/DDL/Oracle/Procedures and Functions/. Consult the Oracle table/view definitions at .github/oracle-to-postgres-migration/DDL/Oracle/Tables and Views/ for type resolution.

Step 2: Translate to PostgreSQL PL/pgSQL

Apply these translation rules:

  • Translate all Oracle-specific syntax to PostgreSQL equivalents.
  • Preserve original functionality and control flow logic.
  • Keep type-anchored input parameters (e.g., PARAM_NAME IN table_name.column_name%TYPE).
  • Use explicit types (NUMERIC, VARCHAR, INTEGER) for output parameters passed to other procedures — do not type-anchor these.
  • Do not alter method signatures.
  • Do not prefix object names with schema names unless already present in the Oracle source.
  • Leave exception handling and rollback logic unchanged.
  • Do not generate COMMENT or GRANT statements.
  • Use COLLATE "C" when ordering by text fields for Oracle-compatible sorting.
  • Leverage the orafce extension when it improves clarity or fidelity.

Consult the PostgreSQL table/view definitions at .github/oracle-to-postgres-migration/DDL/Postgres/Tables and Views/ for target schema details.

Step 3: Write the migrated procedure to Postgres output directory

Place each migrated procedure in its own file under .github/oracle-to-postgres-migration/DDL/Postgres/Procedures and Functions/{PACKAGE_NAME_IF_APPLICABLE}/. One procedure per file.

© boshi-xixixi, MIT. 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 .trae/Skills/.agents/skills/migrating-oracle-to-postgres-stored-procedures of boshi-xixixi/TraeSkill.

Open the folder on GitHubat commit 9cf38e6

Compare with similar skills

Migrating Oracle To Postgres Stored Procedures 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.

Migrating Oracle To Postgres Stored Procedures compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Migrating Oracle To Postgres Stored Procedures this skillboshi-xixixi/TraeSkill276—~576Automated safety check: PassMIT
Migrating Oracle To Postgres Stored Proceduresgithub/awesome-copilot40k—~788Automated safety check: PassMIT
Diesel Guardayarotsky/diesel-guard121—~3.1kAutomated safety check: PassMIT
Database Migrations SQL Migrationsrmyndharis/antigravity-skills1.7k3 repos~577Automated safety check: NotesMIT
DB ContextSilvioBaratto/optimizer176—~6.4kAutomated safety check: NotesCustom licence
Postgrestimescale/pg-aiguide1.9k—~941Automated safety check: PassApache-2.0

Similar skills

  • Diesel Guard

    ayarotsky/diesel-guard

    Lints Diesel and SQLx Postgres migrations for unsafe schema changes that lock tables or cause downtime, and authors custom Rhai checks.

    121 GitHub stars~3.1k tokensUpdated yesterday
    DatabasesAuto-check passed

  • Database Migrations SQL Migrations

    rmyndharis/antigravity-skills

    SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server

    1.7k GitHub starsUsed in 3 repos~577 tokens
    DatabasesAuto-check: notes

  • DB Context

    SilvioBaratto/optimizer

    Complete knowledge of the optimizer PostgreSQL database: 57 ingestion tables, schema, relationships, live row counts, query patterns, and conventions.

    176 GitHub stars~6.4k tokensUpdated 3 days ago
    DatabasesAuto-check: notes

  • Postgres

    timescale/pg-aiguide

    A skill your agent uses for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations.

    1.9k GitHub stars~941 tokensUpdated 3 days ago
    DatabasesAuto-check passed

  • Database Migration

    Rain-kl/OpenFlare

    Wavelet 项目专用：当新增或修改数据库表结构、索引、初始化数据、系统配置 seed、模板 seed、默认管理员、goose SQL 迁移、internal/infra/persistence/migrator、ClickHouse 分析库 DDL 或数据库升级流程时必须使用。本技能指导在 internal/infra/persistence/migrator/goose 下编写…

    289 GitHub stars~1.3k tokensUpdated 3 days ago
    DatabasesAuto-check passed

More from boshi-xixixi/TraeSkill

All 16 skills in this repo

  • AI Team Orchestration

    boshi-xixixi/TraeSkill

    Bootstrap and run a multi-agent AI development team. An agent skill from boshi-xixixi/TraeSkill.

    276 GitHub stars~1.4k tokensUpdated 5 mo ago
    Auto-check passed

  • Arize Instrumentation

    boshi-xixixi/TraeSkill

    INVOKE THIS SKILL when adding Arize AX tracing or observability to an app for the first time, or when the user wants to instrument their LLM app or get started with LLM observability.

    276 GitHub stars~5.1k tokensUpdated 5 mo ago
    Auto-check: notes

  • Dotnet MCP Builder

    boshi-xixixi/TraeSkill

    Build Model Context Protocol (MCP) servers in C/.NET against the current ModelContextProtocol 1.x NuGet packages.

    276 GitHub stars~1.7k tokensUpdated 5 mo ago
    Auto-check passed

  • Skill Creator

    boshi-xixixi/TraeSkill

    当用户需要创建新 Skill 或更新现有 Skill 时使用。此 Skill 提供技能创建的完整工作流指导，包括需求分析、编写规范、工程化构建、质量评估和迭代优化。

    276 GitHub stars~3.9k tokensUpdated 5 mo ago
    Auto-check passed

  • Trae Project Setup

    boshi-xixixi/TraeSkill

    Trae 项目规范化配置专家。用于快速初始化 Trae 项目配置文件、生成项目规则、用户偏好设置和 Skill 模板。当用户需要：(1) 初始化新项目的 Trae 配置 (2) 生成 .trae 目录结构 (3) 创建 USERPREFERENCES.md 用户偏好文件 (4) 创建 projectrules.md 项目规则文件 (5) 创建新的 Skill 模板 时使用此 Skill。

    276 GitHub stars~708 tokensUpdated 5 mo ago
    Auto-check: notes

  • Web Coder

    boshi-xixixi/TraeSkill

    Expert 10x engineer with comprehensive knowledge of web development, internet protocols, and web standards.

    276 GitHub starsUsed in 1 repo~5.2k tokens
    Auto-check passed

Works with

Categories

Questions about Migrating Oracle To Postgres Stored Procedures

What does Migrating Oracle To Postgres Stored Procedures do?

Migrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL. Migrating Oracle To Postgres Stored Procedures is an agent skill from boshi-xixixi/TraeSkill. Migrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL.

When should I use Migrating Oracle To Postgres Stored Procedures?

Migrating Oracle To Postgres Stored Procedures fits situations like: converting Oracle stored procedures; functions to PostgreSQL equivalents during a database migration.

How do I install Migrating Oracle To Postgres Stored Procedures in Claude Code?

Run `npx skills add boshi-xixixi/TraeSkill --skill migrating-oracle-to-postgres-stored-procedures -a claude-code`. Or copy the skill folder (.trae/Skills/.agents/skills/migrating-oracle-to-postgres-stored-procedures in boshi-xixixi/TraeSkill) into .claude/skills/migrating-oracle-to-postgres-stored-procedures in your project. Claude Code loads it when a task matches its description.

How do I install Migrating Oracle To Postgres Stored Procedures in Codex?

Run `npx skills add boshi-xixixi/TraeSkill --skill migrating-oracle-to-postgres-stored-procedures -a codex`. Or copy the skill folder (.trae/Skills/.agents/skills/migrating-oracle-to-postgres-stored-procedures in boshi-xixixi/TraeSkill) into .agents/skills/migrating-oracle-to-postgres-stored-procedures in your project. Codex loads it when a task matches its description.

Can I use Migrating Oracle To Postgres Stored Procedures 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 boshi-xixixi/TraeSkill --skill migrating-oracle-to-postgres-stored-procedures -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/migrating-oracle-to-postgres-stored-procedures, .gemini/skills/migrating-oracle-to-postgres-stored-procedures, .github/skills/migrating-oracle-to-postgres-stored-procedures and .opencode/skills/migrating-oracle-to-postgres-stored-procedures in your project.

What does Migrating Oracle To Postgres Stored Procedures need to run?

SKILL.md names no scripts, command-line tools or credentials: Migrating Oracle To Postgres Stored Procedures is instructions for the agent only.

Does Migrating Oracle To Postgres Stored Procedures 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 Migrating Oracle To Postgres Stored Procedures 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 Migrating Oracle To Postgres Stored Procedures use?

Migrating Oracle To Postgres Stored Procedures is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Migrating Oracle To Postgres Stored Procedures use?

About 576 tokens (SKILL.md is roughly 2.3k 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 Migrating Oracle To Postgres Stored Procedures?

Skills that share tags, products or a category with Migrating Oracle To Postgres Stored Procedures: Migrating Oracle To Postgres Stored Procedures (github/awesome-copilot, 40k stars), Diesel Guard (ayarotsky/diesel-guard, 121 stars), Database Migrations SQL Migrations (rmyndharis/antigravity-skills, 1.7k stars) and DB Context (SilvioBaratto/optimizer, 176 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Migrating Oracle To Postgres Stored Procedures?

boshi-xixixi (a GitHub user) maintains it in boshi-xixixi/TraeSkill, which has 276 GitHub stars. The repository holds 16 skills in this directory. The repository was last updated on May 12, 2026.

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