Index of every page on this site: llms.txt
All skills
github avatar

/creating-oracle-to-postgres-migration-bug-report

@f10fdb8 official
by githubgithub/awesome-copilot41k stars
5,399
Run it yourself

Creates structured bug reports for defects found during Oracle-to-PostgreSQL migration. Use when documenting behavioral differences between Oracle and PostgreSQL as actionable bug reports with severity, root cause, and remediation steps.

Use this Skill: https://skilld.dev/gh/github/awesome-copilot/creating-oracle-to-postgres-migration-bug-report

Nothing lands on disk. Nothing to clean up.

Fork this Skill

Edit a local copy. It keeps the author and licence.

SKILL.md

≈72 tokens for metadata: the name and description. ≈539 when used: this file. ≈563 more on demand in 1 file.

Description uses 3.6% of example budget

Before choosing a Skill, your Agent reads its name and description. All available Skills share that space.

  • A shorter description leaves more room for other Skills. This entry exceeds our 1% size suggestion.

In our Claude Code example, all Skill names and descriptions share 8,000 characters. This Skill uses ≈288 characters, or 3.6%.

The 1% threshold is a size suggestion. Longer descriptions can still fit.

Your model, settings, and other Skills decide how much text your Agent can read.

Example settings and source

The example uses a 200k-token context and default Claude Code settings. The count includes the name, description, separators, and when_to_use when present. Codex also counts local file paths.

Skit's source and limits: Codex 0.160.1, Claude Code 2.1.292.

Creating Bug Reports for Oracle-to-PostgreSQL Migration

When to Use

  • Documenting a defect caused by behavioral differences between Oracle and PostgreSQL
  • Writing or reviewing a bug report for an Oracle-to-PostgreSQL migration project

Bug Report Format

Use the template in references/BUG-REPORT-TEMPLATE.md. Each report must include:

  • Status: ✅ RESOLVED, ⛔ UNRESOLVED, or ⏳ IN PROGRESS
  • Component: Affected endpoint, repository, or stored procedure
  • Test: Related automated test names
  • Severity: Low / Medium / High / Critical — based on impact scope
  • Problem: Expected Oracle behavior vs. observed PostgreSQL behavior
  • Scenario: Ordered reproduction steps with seed data, operation, expected result, and actual result
  • Root Cause: The specific Oracle/PostgreSQL behavioral difference causing the defect
  • Solution: Changes made or required, with explicit file paths
  • Validation: Steps to confirm the fix on both databases

Oracle-to-PostgreSQL Guidance

  • Oracle is the source of truth — frame expected behavior from the Oracle baseline
  • Call out data layer nuances explicitly: empty string vs. NULL, type coercion strictness, collation, sequence values, time zones, padding, constraints
  • Client code changes should be avoided unless required for correct behavior; when proposed, document and justify them clearly

Writing Style

  • Plain language, short sentences, clear next actions
  • Present or past tense consistently
  • Bullets and numbered lists for steps and validations
  • Minimal SQL excerpts and logs as evidence; omit sensitive data and keep snippets reproducible
  • Stick to existing runtime/language versions; avoid speculative fixes

Filename Convention

Save bug reports to .github/oracle-to-postgres-migration/Reports/{ProjectName}/BUG_REPORT_<DescriptiveSlug>.md where:

  • {ProjectName} is the project's assembly/folder name with spaces normalized to - (e.g. MyApp.DataAccess)
  • <DescriptiveSlug> is a short PascalCase identifier describing the defect (e.g., EmptyStringNullHandling, RefCursorUnwrapFailure)

Source: SKILL.md on GitHub

No rule matched.

skilld matched fixed text patterns in SKILL.md and file names. Patterns miss obfuscated code.

skilld run checks every file with the same patterns. It asks for approval before it loads a Skill with a behavior marked Needs approval.

No alerts2mo5 checks · Risk SAFE
  • Gen Agent Trust Hub2mo

    The skill provides structural guidelines and templates for documenting Oracle-to-PostgreSQL migration bug reports. It does not exhibit any malicious behaviors, execute shell commands, perform network requests, or handle untrusted active inputs.

  • Socket2mo

    No alerts

  • Snyk2mo

    Risk: LOW · No issues

  • Runlayer8mo

    2 files scanned · No issues

  • ZeroLeaks7mo

    Score: 93/100 · 2 sections analyzed

Signed by skilld at f10fdb8. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub yesterday.

Activeupdated 3 months ago

README badge

README badge for github/awesome-copilot/creating-oracle-to-postgres-migration-bug-report

Structures bug reports for Oracle-to-PostgreSQL migration issues, documenting behavioral differences with severity, root cause, and validation steps. Use when migration testing uncovers defects in data handling, type coercion, sequences, or stored procedure compatibility between the two databases.

Generated from the current SKILL.md.

What Oracle-to-PostgreSQL behavioral differences does this skill document?
The skill creates structured bug reports that capture defects caused by behavioral differences between Oracle and PostgreSQL, such as empty string vs. NULL handling, type coercion strictness, collation, sequence values, time zones, and constraints.
Does this skill provide a bug report template?
Yes. The skill includes a template at references/BUG-REPORT-TEMPLATE.md that mandates Status, Component, Test, Severity, Problem, Scenario, Root Cause, Solution, and Validation sections.
Should I document client code changes in the bug report?
Only if required for correct behavior. The skill guidance is to avoid client code changes when possible; if proposed, they must be documented and justified explicitly in the Solution section.
What severity levels does the bug report format use?
Four levels: Low, Medium, High, and Critical, based on impact scope.
What naming convention should I use for bug report files?
Save reports as BUG_REPORT_<DescriptiveSlug>.md using short PascalCase identifiers (for example, BUG_REPORT_EmptyStringNullHandling.md).

Generated from the current SKILL.md. These answers refresh after source changes.