{"id":"b3d83c1c-0d43-4a20-9c81-7f6c60a762bd","shortId":"GTwGpK","kind":"skill","title":"Planning Oracle To Postgres Migration Integration Testing","tagline":"Awesome Copilot skill by Github","description":"# Planning Integration Testing for Oracle-to-PostgreSQL Migration\n\nAnalyze a single target project to identify data access artifacts that require integration testing, then produce a structured, actionable testing plan.\n\n## Workflow\n\n```\nProgress:\n- [ ] Step 1: Identify data access artifacts\n- [ ] Step 2: Classify testing priorities\n- [ ] Step 3: Write the testing plan\n```\n\n**Step 1: Identify data access artifacts**\n\nScope to the target project only. Find classes and methods that interact directly with the database — repositories, DAOs, stored procedure callers, service layers performing CRUD operations.\n\n**Step 2: Classify testing priorities**\n\nRank artifacts by migration risk. Prioritize methods that use Oracle-specific features (refcursors, `TO_CHAR`, implicit type coercion, `NO_DATA_FOUND`) over simple CRUD.\n\n**Step 3: Write the testing plan**\n\nWrite a markdown plan covering:\n- List of testable artifacts with method signatures\n- Recommended test cases per artifact\n- Seed data requirements\n- Known Oracle→PostgreSQL behavioral differences to validate\n\n## Output\n\nWrite the plan to: `.github/oracle-to-postgres-migration/Reports/{TARGET_PROJECT} Integration Testing Plan.md`\n\n## Key Constraints\n\n- **Single project scope** — only plan tests for artifacts within the target project.\n- **Database interactions only** — skip business logic that does not touch the database.\n- **Oracle is the golden source** — tests should capture Oracle's expected behavior for comparison against PostgreSQL.\n- **No multi-connection harnessing** — migrated applications are copied and renamed (e.g., `MyApp.Postgres`), so each instance targets one database.","tags":["planning","oracle","postgres","migration","integration","testing","awesome","copilot","github"],"capabilities":["skill","source-github","category-awesome-copilot"],"categories":["awesome-copilot"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/github/awesome-copilot/planning-oracle-to-postgres-migration-integration-testing","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.200Z","embedding":null,"createdAt":"2026-04-18T20:30:52.253Z","updatedAt":"2026-04-22T05:40:31.200Z","lastSeenAt":"2026-04-22T05:40:31.200Z","tsv":"'1':46,63 '2':52,95 '3':57,125 'access':30,49,66 'action':40 'analyz':22 'applic':216 'artifact':31,50,67,100,138,146,177 'awesom':8 'behavior':153,205 'busi':186 'caller':88 'captur':201 'case':144 'category-awesome-copilot' 'char':114 'class':75 'classifi':53,96 'coercion':117 'comparison':207 'connect':213 'constraint':169 'copi':218 'copilot':9 'cover':134 'crud':92,123 'dao':85 'data':29,48,65,119,148 'databas':83,182,193,228 'differ':154 'direct':80 'e.g':221 'expect':204 'featur':111 'find':74 'found':120 'github':12 'github/oracle-to-postgres-migration/reports':162 'golden':197 'har':214 'identifi':28,47,64 'implicit':115 'instanc':225 'integr':6,14,34,165 'interact':79,183 'key':168 'known':150 'layer':90 'list':135 'logic':187 'markdown':132 'method':77,105,140 'migrat':5,21,102,215 'multi':212 'multi-connect':211 'myapp.postgres':222 'one':227 'oper':93 'oracl':2,18,109,151,194,202 'oracle-specif':108 'oracle-to-postgresql':17 'output':157 'per':145 'perform':91 'plan':1,13,42,61,129,133,160,174 'plan.md':167 'postgr':4 'postgresql':20,152,209 'priorit':104 'prioriti':55,98 'procedur':87 'produc':37 'progress':44 'project':26,72,164,171,181 'rank':99 'recommend':142 'refcursor':112 'renam':220 'repositori':84 'requir':33,149 'risk':103 'scope':68,172 'seed':147 'servic':89 'signatur':141 'simpl':122 'singl':24,170 'skill':10 'skip':185 'sourc':198 'source-github' 'specif':110 'step':45,51,56,62,94,124 'store':86 'structur':39 'target':25,71,163,180,226 'test':7,15,35,41,54,60,97,128,143,166,175,199 'testabl':137 'touch':191 'type':116 'use':107 'valid':156 'within':178 'workflow':43 'write':58,126,130,158","prices":[{"id":"fe2c139b-788b-4fb0-9e09-c54d108ccc83","listingId":"b3d83c1c-0d43-4a20-9c81-7f6c60a762bd","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:52.253Z"}],"sources":[{"listingId":"b3d83c1c-0d43-4a20-9c81-7f6c60a762bd","source":"github","sourceId":"github/awesome-copilot/planning-oracle-to-postgres-migration-integration-testing","sourceUrl":"https://github.com/github/awesome-copilot/tree/main/skills/planning-oracle-to-postgres-migration-integration-testing","isPrimary":false,"firstSeenAt":"2026-04-18T21:50:29.171Z","lastSeenAt":"2026-04-22T00:52:14.036Z"},{"listingId":"b3d83c1c-0d43-4a20-9c81-7f6c60a762bd","source":"skills_sh","sourceId":"github/awesome-copilot/planning-oracle-to-postgres-migration-integration-testing","sourceUrl":"https://skills.sh/github/awesome-copilot/planning-oracle-to-postgres-migration-integration-testing","isPrimary":true,"firstSeenAt":"2026-04-18T20:30:52.253Z","lastSeenAt":"2026-04-22T05:40:31.200Z"}],"details":{"listingId":"b3d83c1c-0d43-4a20-9c81-7f6c60a762bd","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"github","slug":"planning-oracle-to-postgres-migration-integration-testing","source":"skills_sh","category":"awesome-copilot","skills_sh_url":"https://skills.sh/github/awesome-copilot/planning-oracle-to-postgres-migration-integration-testing"},"updatedAt":"2026-04-22T05:40:31.200Z"}}