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

Creating Oracle To Postgres Migration Integration Tests

by boshi-xixixi in boshi-xixixi/TraeSkill

Creates integration test cases for .NET data access artifacts during Oracle-to-PostgreSQL database migrations.

MITAuto-check passedTesting & QA

Install Creating Oracle To Postgres Migration Integration Tests

skills CLI
$ npx skills add boshi-xixixi/TraeSkill --skill creating-oracle-to-postgres-migration-integration-tests -a claude-code

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

GitHub CLI
$ gh skill install boshi-xixixi/TraeSkill creating-oracle-to-postgres-migration-integration-tests --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/creating-oracle-to-postgres-migration-integration-tests .claude/skills/creating-oracle-to-postgres-migration-integration-tests && 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
creating-oracle-to-postgres-migration-integration-tests
GitHub stars
275
Token cost
~760 tokens
SKILL.md length
322 words
Files
1
Skills in repo
16
Repo updated
First seen
Licence
MIT

At a glance

Creates integration test cases for .NET data access artifacts during Oracle-to-PostgreSQL database migrations.

  • Creating integration tests for a migrated project
  • SKILL.md covers Prerequisites, Workflow and Key Constraints
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
  • Generating test coverage for data access layers

What it does

Creating Oracle To Postgres Migration Integration Tests is an agent skill from boshi-xixixi/TraeSkill. Creates integration test cases for .NET data access artifacts during Oracle-to-PostgreSQL database migrations. Generates DB-agnostic xUnit tests with deterministic seed data that validate behavior consistency across both database systems. Use when creating integration tests for a migrated project, generating test coverage for data access layers, or writing Oracle-to-PostgreSQL migration validation tests.

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

When your agent uses it

  • Creating integration tests for a migrated project
  • Generating test coverage for data access layers
  • Writing Oracle-to-PostgreSQL migration validation tests

Example prompts

  • “Use the creating-oracle-to-postgres-migration-integration-tests skill to create integration test cases for .NET data access artifacts during…”
  • “/creating-oracle-to-postgres-migration-integration-tests”

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

Creating Oracle To Postgres Migration Integration Tests loads about 760 tokens when it runs. Until then it costs about 116 tokens; SKILL.md has 322 words of instructions outside code blocks.

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

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). 322 words, ~760 tokens.

Download SKILL.mdSave it as .claude/skills/creating-oracle-to-postgres-migration-integration-tests/SKILL.md (or your agent's skills folder).
name
creating-oracle-to-postgres-migration-integration-tests
description
Creates integration test cases for .NET data access artifacts during Oracle-to-PostgreSQL database migrations. Generates DB-agnostic xUnit tests with deterministic seed data that validate behavior consistency across both database systems. Use when creating integration tests for a migrated project, generating test coverage for data access layers, or writing Oracle-to-PostgreSQL migration validation tests.

Creating Integration Tests for Oracle-to-PostgreSQL Migration

Generates integration test cases for data access artifacts in a single target project. Tests validate behavior consistency when running against Oracle or PostgreSQL.

Prerequisites

  • The test project must already exist and compile (scaffolded separately).
  • Read the existing base test class and seed manager conventions before writing tests.

Workflow

Test Creation:
- [ ] Step 1: Discover the test project conventions
- [ ] Step 2: Identify testable data access artifacts
- [ ] Step 3: Create seed data
- [ ] Step 4: Write test cases
- [ ] Step 5: Review determinism

Step 1: Discover the test project conventions

Read the base test class, seed manager, and project file to understand inheritance patterns, transaction management, and seed file conventions.

Step 2: Identify testable data access artifacts

Scope to the target project only. List data access methods that interact with the database — repositories, DAOs, stored procedure callers, query builders.

Step 3: Create seed data

  • Follow seed file location and naming conventions from the existing project.
  • Reuse existing seed files when possible.
  • Avoid TRUNCATE TABLE — keep existing database data intact.
  • Do not commit seed data; tests run in transactions that roll back.
  • Ensure seed data does not conflict with other tests.
  • Load and verify seed data before assertions depend on it.

Step 4: Write test cases

  • Inherit from the base test class to get automatic transaction create/rollback.
  • Assert logical outputs (rows, columns, counts, error types), not platform-specific messages.
  • Assert specific expected values — never assert that a value is merely non-null or non-empty when a concrete value is available from seed data.
  • Avoid testing code paths that do not exist or asserting behavior that cannot occur.
  • Avoid redundant assertions across tests targeting the same method.

Step 5: Review determinism

Re-examine every assertion against non-null values. Confirm each is deterministic against the seeded data. Fix any assertion that depends on database state outside the test's control.

Key Constraints

  • Oracle is the golden source — tests capture Oracle's expected behavior.
  • DB-agnostic assertions — no platform-specific error messages or syntax in assertions.
  • Seed only against Oracle — test project will be migrated to PostgreSQL later.
  • Scoped to one project — do not create tests for artifacts outside the target project.

© 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/creating-oracle-to-postgres-migration-integration-tests of boshi-xixixi/TraeSkill.

Open the folder on GitHubat commit 9cf38e6

Compare with similar skills

Creating Oracle To Postgres Migration Integration Tests 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.

Creating Oracle To Postgres Migration Integration Tests compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Creating Oracle To Postgres Migration Integration Tests this skillboshi-xixixi/TraeSkill275—~760Automated safety check: PassMIT
Scaffolding Oracle To Postgres Migration Test Projectgithub/awesome-copilot40k—~687Automated safety check: PassMIT
Airbyte Postgres Source E2E Testsairbytehq/airbyte22k—~2.5kAutomated safety check: PassCustom licence
Aspire Integration TestingDevBetterCom/DevBetterWeb1572 repos~2.3kAutomated safety check: PassNone
Planning Oracle To Postgres Migration Integration Testinggithub/awesome-copilot40k1 repos~669Automated safety check: PassMIT
Creating Oracle To Postgres Migration Integration Testsgithub/awesome-copilot40k—~1.1kAutomated safety check: PassMIT

Similar skills

  • Airbyte Postgres Source E2E Tests

    airbytehq/airbyte

    Official

    Starts a local PostgreSQL 16 container, loads SQL fixtures and runs the Airbyte spec, check, discover and read commands against a chosen source-postgres image.

    22k GitHub stars~2.5k tokensUpdated today
    Testing & QAAuto-check passed

  • Aspire Integration Testing

    DevBetterCom/DevBetterWeb

    Write integration tests using .NET Aspire's testing facilities with xUnit.

    157 GitHub starsUsed in 2 repos~2.3k tokens
    Testing & QAAuto-check passed

  • Database Testing

    petrkindlmann/qa-skills

    Validate database integrity, test migrations forward and backward, verify schema constraints, manage seed data, detect migration drift, and identify query performance issues.

    168 GitHub stars~4.2k tokensUpdated 4 mo 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.

    275 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.

    275 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.

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

  • Skill Creator

    boshi-xixixi/TraeSkill

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

    275 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。

    275 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.

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

Works with

Categories

Questions about Creating Oracle To Postgres Migration Integration Tests

What does Creating Oracle To Postgres Migration Integration Tests do?

Creates integration test cases for .NET data access artifacts during Oracle-to-PostgreSQL database migrations. Creating Oracle To Postgres Migration Integration Tests is an agent skill from boshi-xixixi/TraeSkill.NET data access artifacts during Oracle-to-PostgreSQL database migrations.

When should I use Creating Oracle To Postgres Migration Integration Tests?

Creating Oracle To Postgres Migration Integration Tests fits situations like: creating integration tests for a migrated project; generating test coverage for data access layers; writing Oracle-to-PostgreSQL migration validation tests.

How do I install Creating Oracle To Postgres Migration Integration Tests in Claude Code?

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

How do I install Creating Oracle To Postgres Migration Integration Tests in Codex?

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

Can I use Creating Oracle To Postgres Migration Integration Tests 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 creating-oracle-to-postgres-migration-integration-tests -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/creating-oracle-to-postgres-migration-integration-tests, .gemini/skills/creating-oracle-to-postgres-migration-integration-tests, .github/skills/creating-oracle-to-postgres-migration-integration-tests and .opencode/skills/creating-oracle-to-postgres-migration-integration-tests in your project.

What does Creating Oracle To Postgres Migration Integration Tests need to run?

SKILL.md names no scripts, command-line tools or credentials: Creating Oracle To Postgres Migration Integration Tests is instructions for the agent only.

Does Creating Oracle To Postgres Migration Integration Tests 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 Creating Oracle To Postgres Migration Integration Tests 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 Creating Oracle To Postgres Migration Integration Tests use?

Creating Oracle To Postgres Migration Integration Tests 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 Creating Oracle To Postgres Migration Integration Tests use?

About 760 tokens (SKILL.md is roughly 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 Creating Oracle To Postgres Migration Integration Tests?

Skills that share tags, products or a category with Creating Oracle To Postgres Migration Integration Tests: Scaffolding Oracle To Postgres Migration Test Project (github/awesome-copilot, 40k stars), Airbyte Postgres Source E2E Tests (airbytehq/airbyte, 22k stars), Aspire Integration Testing (DevBetterCom/DevBetterWeb, 157 stars) and Planning Oracle To Postgres Migration Integration Testing (github/awesome-copilot, 40k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Creating Oracle To Postgres Migration Integration Tests?

boshi-xixixi (a GitHub user) maintains it in boshi-xixixi/TraeSkill, which has 275 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.