{"id":"1fe1688e-018e-4506-97d8-ff99fc1d24e9","shortId":"kxcbyE","kind":"skill","title":"creating-oracle-to-postgres-migration-bug-report","tagline":"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.","description":"# Creating Bug Reports for Oracle-to-PostgreSQL Migration\n\n## When to Use\n\n- Documenting a defect caused by behavioral differences between Oracle and PostgreSQL\n- Writing or reviewing a bug report for an Oracle-to-PostgreSQL migration project\n\n## Bug Report Format\n\nUse the template in [references/BUG-REPORT-TEMPLATE.md](references/BUG-REPORT-TEMPLATE.md). Each report must include:\n\n- **Status**: ✅ RESOLVED, ⛔ UNRESOLVED, or ⏳ IN PROGRESS\n- **Component**: Affected endpoint, repository, or stored procedure\n- **Test**: Related automated test names\n- **Severity**: Low / Medium / High / Critical — based on impact scope\n- **Problem**: Expected Oracle behavior vs. observed PostgreSQL behavior\n- **Scenario**: Ordered reproduction steps with seed data, operation, expected result, and actual result\n- **Root Cause**: The specific Oracle/PostgreSQL behavioral difference causing the defect\n- **Solution**: Changes made or required, with explicit file paths\n- **Validation**: Steps to confirm the fix on both databases\n\n## Oracle-to-PostgreSQL Guidance\n\n- **Oracle is the source of truth** — frame expected behavior from the Oracle baseline\n- Call out data layer nuances explicitly: empty string vs. NULL, type coercion strictness, collation, sequence values, time zones, padding, constraints\n- Client code changes should be avoided unless required for correct behavior; when proposed, document and justify them clearly\n\n## Writing Style\n\n- Plain language, short sentences, clear next actions\n- Present or past tense consistently\n- Bullets and numbered lists for steps and validations\n- Minimal SQL excerpts and logs as evidence; omit sensitive data and keep snippets reproducible\n- Stick to existing runtime/language versions; avoid speculative fixes\n\n## Filename Convention\n\nSave bug reports as `BUG_REPORT_<DescriptiveSlug>.md` where `<DescriptiveSlug>` is a short PascalCase identifier (e.g., `EmptyStringNullHandling`, `RefCursorUnwrapFailure`).","tags":["creating","oracle","postgres","migration","bug","report","awesome","copilot","github","agent-skills","agents","custom-agents"],"capabilities":["skill","source-github","skill-creating-oracle-to-postgres-migration-bug-report","topic-agent-skills","topic-agents","topic-awesome","topic-custom-agents","topic-github-copilot","topic-hacktoberfest","topic-prompt-engineering"],"categories":["awesome-copilot"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/github/awesome-copilot/creating-oracle-to-postgres-migration-bug-report","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add github/awesome-copilot","source_repo":"https://github.com/github/awesome-copilot","install_from":"skills.sh"}},"qualityScore":"0.700","qualityRationale":"deterministic score 0.70 from registry signals: · indexed on github topic:agent-skills · 33270 github stars · SKILL.md body (1,949 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T18:52:08.971Z","embedding":null,"createdAt":"2026-04-18T20:30:50.450Z","updatedAt":"2026-05-18T18:52:08.971Z","lastSeenAt":"2026-05-18T18:52:08.971Z","tsv":"'action':32,232 'actual':138 'affect':99 'autom':107 'avoid':211,265 'base':115 'baselin':185 'behavior':25,59,122,126,145,181,216 'bug':7,11,33,43,69,79,271,274 'bullet':238 'call':186 'caus':38,57,141,147 'chang':151,208 'clear':223,230 'client':206 'code':207 'coercion':197 'collat':199 'compon':98 'confirm':162 'consist':237 'constraint':205 'convent':269 'correct':215 'creat':2,9,42 'creating-oracle-to-postgres-migration-bug-report':1 'critic':114 'data':133,188,255 'databas':167 'defect':14,56,149 'differ':26,60,146 'document':24,54,219 'e.g':283 'empti':192 'emptystringnullhandl':284 'endpoint':100 'evid':252 'excerpt':248 'exist':262 'expect':120,135,180 'explicit':156,191 'file':157 'filenam':268 'fix':164,267 'format':81 'found':15 'frame':179 'guidanc':172 'high':113 'identifi':282 'impact':117 'includ':91 'justifi':221 'keep':257 'languag':227 'layer':189 'list':241 'log':250 'low':111 'made':152 'md':276 'medium':112 'migrat':6,21,50,77 'minim':246 'must':90 'name':109 'next':231 'nuanc':190 'null':195 'number':240 'observ':124 'omit':253 'oper':134 'oracl':3,18,28,47,62,74,121,169,173,184 'oracle-to-postgresql':17,46,73,168 'oracle/postgresql':144 'order':128 'pad':204 'pascalcas':281 'past':235 'path':158 'plain':226 'postgr':5 'postgresql':20,30,49,64,76,125,171 'present':233 'problem':119 'procedur':104 'progress':97 'project':78 'propos':218 'refcursorunwrapfailur':285 'references/bug-report-template.md':86,87 'relat':106 'remedi':40 'report':8,12,34,44,70,80,89,272,275 'repositori':101 'reproduc':259 'reproduct':129 'requir':154,213 'resolv':93 'result':136,139 'review':67 'root':37,140 'runtime/language':263 'save':270 'scenario':127 'scope':118 'seed':132 'sensit':254 'sentenc':229 'sequenc':200 'sever':36,110 'short':228,280 'skill' 'skill-creating-oracle-to-postgres-migration-bug-report' 'snippet':258 'solut':150 'sourc':176 'source-github' 'specif':143 'specul':266 'sql':247 'status':92 'step':41,130,160,243 'stick':260 'store':103 'strict':198 'string':193 'structur':10 'style':225 'templat':84 'tens':236 'test':105,108 'time':202 'topic-agent-skills' 'topic-agents' 'topic-awesome' 'topic-custom-agents' 'topic-github-copilot' 'topic-hacktoberfest' 'topic-prompt-engineering' 'truth':178 'type':196 'unless':212 'unresolv':94 'use':22,53,82 'valid':159,245 'valu':201 'version':264 'vs':123,194 'write':65,224 'zone':203","prices":[{"id":"e37da987-16d9-4c56-a05b-14f4fab58f7d","listingId":"1fe1688e-018e-4506-97d8-ff99fc1d24e9","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"github","category":"awesome-copilot","install_from":"skills.sh"},"createdAt":"2026-04-18T20:30:50.450Z"}],"sources":[{"listingId":"1fe1688e-018e-4506-97d8-ff99fc1d24e9","source":"github","sourceId":"github/awesome-copilot/creating-oracle-to-postgres-migration-bug-report","sourceUrl":"https://github.com/github/awesome-copilot/tree/main/skills/creating-oracle-to-postgres-migration-bug-report","isPrimary":false,"firstSeenAt":"2026-04-18T21:48:57.468Z","lastSeenAt":"2026-05-18T18:52:08.971Z"},{"listingId":"1fe1688e-018e-4506-97d8-ff99fc1d24e9","source":"skills_sh","sourceId":"github/awesome-copilot/creating-oracle-to-postgres-migration-bug-report","sourceUrl":"https://skills.sh/github/awesome-copilot/creating-oracle-to-postgres-migration-bug-report","isPrimary":true,"firstSeenAt":"2026-04-18T20:30:50.450Z","lastSeenAt":"2026-05-07T22:40:31.315Z"}],"details":{"listingId":"1fe1688e-018e-4506-97d8-ff99fc1d24e9","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"github","slug":"creating-oracle-to-postgres-migration-bug-report","github":{"repo":"github/awesome-copilot","stars":33270,"topics":["agent-skills","agents","ai","awesome","custom-agents","github-copilot","hacktoberfest","prompt-engineering"],"license":"mit","html_url":"https://github.com/github/awesome-copilot","pushed_at":"2026-05-18T01:26:59Z","description":"Community-contributed instructions, agents, skills, and configurations to help you make the most of GitHub Copilot.","skill_md_sha":"dc3677d7fee9674629685837f207ef32048ca637","skill_md_path":"skills/creating-oracle-to-postgres-migration-bug-report/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/github/awesome-copilot/tree/main/skills/creating-oracle-to-postgres-migration-bug-report"},"layout":"multi","source":"github","category":"awesome-copilot","frontmatter":{"name":"creating-oracle-to-postgres-migration-bug-report","description":"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."},"skills_sh_url":"https://skills.sh/github/awesome-copilot/creating-oracle-to-postgres-migration-bug-report"},"updatedAt":"2026-05-18T18:52:08.971Z"}}