creating-oracle-to-postgres-migration-integration-tests SKILL.md skillA

creating-oracle-to-postgres-migration-integration-tests from github/awesome-copilot is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add github/awesome-copilot/creating-oracle-to-postgres-migration-integration-tests@git:20260811.f7e8aaa

Pins git:20260811.f7e8aaa in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
github/awesome-copilot
Path
skills/creating-oracle-to-postgres-migration-integration-tests/SKILL.md
Versions recorded
3
Latest version
git:20260811.f7e8aaa, committed Aug 11, 2026
First version recorded
Mar 10, 2026
Size
4,318 bytes
Repository stars
40,941
License
MIT

Creates integration test cases targeting Oracle for .NET data access artifacts. Tests capture Oracle expected behavior as the authoritative baseline; they are written once and later ported to PostgreSQL by migrating the test project in Phase 6. Use only during Phase 3, before any PostgreSQL migration work has begun. Do not invoke during Phase 6 or against a project that has already been migrated.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Creating Integration Tests for Oracle-to-PostgreSQL Migration

Generates integration test cases for data access artifacts in a single target project. Tests target Oracle and capture its behavior as the authoritative baseline. They are written to be logically portable — so they can survive Phase 6 migration without rewriting — but they do not run against PostgreSQL at this stage.

## 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**
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add github/awesome-copilot/creating-oracle-to-postgres-migration-integration-tests@sha256:4bb8ae9ca9d67426

The line at the top of this page pins the label git:20260811.f7e8aaa, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_e4jszcamxhs7ybwt.svg)](https://markdownregistry.com/a/art_e4jszcamxhs7ybwt)

4 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 3 versions of this file, between Mar 10, 2026 and Aug 11, 2026, about one every 77 days.

versioncommittedcommitsizeaudit
git:20260811.f7e8aaa latest2026-08-11 f7e8aaa 4,318 BA view · diff
git:20260714.0b950f92026-07-14 0b950f9 3,796 BA view · diff
git:20260310.623083f2026-03-10 623083f 3,053 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (4318 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

github/awesome-copilot · 40,941 stars · license MIT · pushed 2026-11-09 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_e4jszcamxhs7ybwt
GET https://markdownregistry.com/api/v1/resolve?ref=github/awesome-copilot/creating-oracle-to-postgres-migration-integration-tests
GET https://markdownregistry.com/api/v1/blob/4bb8ae9ca9d6742646f3bd51c81d2a47137762922bf800e965ba6540aadc6ec5

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from github/awesome-copilot

agentic-workflows SKILL.md skill
github/awesome-copilot · .github/skills/agentic-workflows/SKILL.md · Route gh-aw workflow design/create/debug/upgrade requests to the right prompts.
git:20261007.b55f76e · audit A · 40,941 stars
code-review SKILL.md skill
github/awesome-copilot · .github/skills/code-review/SKILL.md · Review pull requests for repository fit, meaningful value, trustworthy provenance, differentiation, and maintainability…
git:20261029.d47bdce · audit A · 40,941 stars
create-canvas-extension SKILL.md skill
github/awesome-copilot · .github/skills/create-canvas-extension/SKILL.md · Create or register a canvas extension in the awesome-copilot repository. Use when asked to scaffold a new canvas…
git:20260824.37dcfd2 · audit A · 40,941 stars
AGENTS.md AGENTS.md file
github/awesome-copilot · AGENTS.md
git:20261102.6da4f4d · audit A · 40,941 stars
acquire-codebase-knowledge SKILL.md skill
github/awesome-copilot · skills/acquire-codebase-knowledge/SKILL.md · Use this skill when the user explicitly asks to map, document, or onboard into an existing codebase. Trigger for…
v1.3 · audit B · 40,941 stars
acreadiness-assess SKILL.md skill
github/awesome-copilot · skills/acreadiness-assess/SKILL.md · Run the AgentRC readiness assessment on the current repository and produce a static HTML dashboard at…
git:20260504.ebd2249 · audit A · 40,941 stars
acreadiness-generate-instructions SKILL.md skill
github/awesome-copilot · skills/acreadiness-generate-instructions/SKILL.md · Generate tailored AI agent instruction files via AgentRC instructions command. Produces .github/copilot-instructions.md…
git:20260504.ebd2249 · audit A · 40,941 stars
acreadiness-policy SKILL.md skill
github/awesome-copilot · skills/acreadiness-policy/SKILL.md · Help the user pick, write, or apply an AgentRC policy. Policies customise readiness scoring by disabling irrelevant…
git:20260504.ebd2249 · audit A · 40,941 stars
ad-campaign-analyzer SKILL.md skill
github/awesome-copilot · skills/ad-campaign-analyzer/SKILL.md · Use this skill when the user shares ad campaign performance data and asks what to cut, scale, or test. Trigger for…
v1.0 · audit A · 40,941 stars
add-educational-comments SKILL.md skill
github/awesome-copilot · skills/add-educational-comments/SKILL.md · Add educational comments to the file specified, or prompt asking for file to comment if one is not provided.
git:20260224.caab1f6 · audit A · 40,941 stars
adobe-illustrator-integrations SKILL.md skill
github/awesome-copilot · skills/adobe-illustrator-integrations/SKILL.md · Build, debug, package, and document Adobe Illustrator integrations: CEP extension panels, C++ SDK plug-ins (.aip), the…
git:20261104.03c43ad · audit A · 40,941 stars
adobe-illustrator-scripting SKILL.md skill
github/awesome-copilot · skills/adobe-illustrator-scripting/SKILL.md · Write, debug, and optimize Adobe Illustrator automation scripts using ExtendScript (JavaScript/JSX). Use when creating…
git:20260528.9bdb742 · audit A · 40,941 stars

Every file in github/awesome-copilot

Browse by kind, by grade A, or by owner.