{"id":"1fe1688e-018e-4506-97d8-ff99fc1d24e9","shortId":"kxcbyE","kind":"skill","title":"Creating Oracle To Postgres Migration Bug Report","tagline":"Awesome Copilot skill by Github","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"],"capabilities":["skill","source-github","category-awesome-copilot"],"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":{"install_from":"skills.sh"}},"qualityScore":"0.300","qualityRationale":"deterministic score 0.30 from registry signals: · indexed on skills.sh · published under github/awesome-copilot","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:v1","enrichmentVersion":1,"enrichedAt":"2026-04-22T05:40:31.029Z","embedding":null,"createdAt":"2026-04-18T20:30:50.450Z","updatedAt":"2026-04-22T05:40:31.029Z","lastSeenAt":"2026-04-22T05:40:31.029Z","tsv":"'action':203 'actual':109 'affect':70 'autom':78 'avoid':182,236 'awesom':8 'base':86 'baselin':156 'behavior':30,93,97,116,152,187 'bug':6,14,40,50,242,245 'bullet':209 'call':157 'category-awesome-copilot' 'caus':28,112,118 'chang':122,179 'clear':194,201 'client':177 'code':178 'coercion':168 'collat':170 'compon':69 'confirm':133 'consist':208 'constraint':176 'convent':240 'copilot':9 'correct':186 'creat':1,13 'critic':85 'data':104,159,226 'databas':138 'defect':27,120 'differ':31,117 'document':25,190 'e.g':254 'empti':163 'emptystringnullhandl':255 'endpoint':71 'evid':223 'excerpt':219 'exist':233 'expect':91,106,151 'explicit':127,162 'file':128 'filenam':239 'fix':135,238 'format':52 'frame':150 'github':12 'guidanc':143 'high':84 'identifi':253 'impact':88 'includ':62 'justifi':192 'keep':228 'languag':198 'layer':160 'list':212 'log':221 'low':82 'made':123 'md':247 'medium':83 'migrat':5,21,48 'minim':217 'must':61 'name':80 'next':202 'nuanc':161 'null':166 'number':211 'observ':95 'omit':224 'oper':105 'oracl':2,18,33,45,92,140,144,155 'oracle-to-postgresql':17,44,139 'oracle/postgresql':115 'order':99 'pad':175 'pascalcas':252 'past':206 'path':129 'plain':197 'postgr':4 'postgresql':20,35,47,96,142 'present':204 'problem':90 'procedur':75 'progress':68 'project':49 'propos':189 'refcursorunwrapfailur':256 'references/bug-report-template.md':57,58 'relat':77 'report':7,15,41,51,60,243,246 'repositori':72 'reproduc':230 'reproduct':100 'requir':125,184 'resolv':64 'result':107,110 'review':38 'root':111 'runtime/language':234 'save':241 'scenario':98 'scope':89 'seed':103 'sensit':225 'sentenc':200 'sequenc':171 'sever':81 'short':199,251 'skill':10 'snippet':229 'solut':121 'sourc':147 'source-github' 'specif':114 'specul':237 'sql':218 'status':63 'step':101,131,214 'stick':231 'store':74 'strict':169 'string':164 'style':196 'templat':55 'tens':207 'test':76,79 'time':173 'truth':149 'type':167 'unless':183 'unresolv':65 'use':24,53 'valid':130,216 'valu':172 'version':235 'vs':94,165 'write':36,195 'zone':174","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-04-22T00:52:07.104Z"},{"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-04-22T05:40:31.029Z"}],"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","source":"skills_sh","category":"awesome-copilot","skills_sh_url":"https://skills.sh/github/awesome-copilot/creating-oracle-to-postgres-migration-bug-report"},"updatedAt":"2026-04-22T05:40:31.029Z"}}