{"id":"b3d83c1c-0d43-4a20-9c81-7f6c60a762bd","shortId":"GTwGpK","kind":"skill","title":"planning-oracle-to-postgres-migration-integration-testing","tagline":"Creates an integration testing plan for .NET data access artifacts during Oracle-to-PostgreSQL database migrations. Analyzes a single project to identify repositories, DAOs, and service layers that interact with the database, then produces a structured testing plan. Use when plan","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","agent-skills","agents","custom-agents"],"capabilities":["skill","source-github","skill-planning-oracle-to-postgres-migration-integration-testing","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/planning-oracle-to-postgres-migration-integration-testing","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,654 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:19.644Z","embedding":null,"createdAt":"2026-04-18T20:30:52.253Z","updatedAt":"2026-05-18T18:52:19.644Z","lastSeenAt":"2026-05-18T18:52:19.644Z","tsv":"'1':84,101 '2':90,133 '3':95,163 'access':17,68,87,104 'action':78 'analyz':26,60 'applic':254 'artifact':18,69,88,105,138,176,184,215 'behavior':191,243 'busi':224 'caller':126 'captur':239 'case':182 'char':152 'class':113 'classifi':91,134 'coercion':155 'comparison':245 'connect':251 'constraint':207 'copi':256 'cover':172 'creat':9 'crud':130,161 'dao':33,123 'data':16,67,86,103,157,186 'databas':24,41,121,220,231,266 'differ':192 'direct':118 'e.g':259 'expect':242 'featur':149 'find':112 'found':158 'github/oracle-to-postgres-migration/reports':200 'golden':235 'har':252 'identifi':31,66,85,102 'implicit':153 'instanc':263 'integr':7,11,52,72,203 'interact':38,117,221 'key':206 'known':188 'layer':36,128 'list':173 'logic':225 'markdown':170 'method':115,143,178 'migrat':6,25,59,140,253 'multi':250 'multi-connect':249 'myapp.postgres':260 'net':15 'one':265 'oper':131 'oracl':3,21,56,147,189,232,240 'oracle-specif':146 'oracle-to-postgresql':20,55 'output':195 'per':183 'perform':129 'plan':2,13,47,50,51,80,99,167,171,198,212 'plan.md':205 'planning-oracle-to-postgres-migration-integration-test':1 'postgr':5 'postgresql':23,58,190,247 'priorit':142 'prioriti':93,136 'procedur':125 'produc':43,75 'progress':82 'project':29,64,110,202,209,219 'rank':137 'recommend':180 'refcursor':150 'renam':258 'repositori':32,122 'requir':71,187 'risk':141 'scope':106,210 'seed':185 'servic':35,127 'signatur':179 'simpl':160 'singl':28,62,208 'skill' 'skill-planning-oracle-to-postgres-migration-integration-testing' 'skip':223 'sourc':236 'source-github' 'specif':148 'step':83,89,94,100,132,162 'store':124 'structur':45,77 'target':63,109,201,218,264 'test':8,12,46,53,73,79,92,98,135,166,181,204,213,237 'testabl':175 'topic-agent-skills' 'topic-agents' 'topic-awesome' 'topic-custom-agents' 'topic-github-copilot' 'topic-hacktoberfest' 'topic-prompt-engineering' 'touch':229 'type':154 'use':48,145 'valid':194 'within':216 'workflow':81 'write':96,164,168,196","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-05-18T18:52:19.644Z"},{"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-05-07T22:40:31.474Z"}],"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","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":"448b9555bb7c1ceec42b5a976bf551becd657f81","skill_md_path":"skills/planning-oracle-to-postgres-migration-integration-testing/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/github/awesome-copilot/tree/main/skills/planning-oracle-to-postgres-migration-integration-testing"},"layout":"multi","source":"github","category":"awesome-copilot","frontmatter":{"name":"planning-oracle-to-postgres-migration-integration-testing","description":"Creates an integration testing plan for .NET data access artifacts during Oracle-to-PostgreSQL database migrations. Analyzes a single project to identify repositories, DAOs, and service layers that interact with the database, then produces a structured testing plan. Use when planning integration test coverage for a migrated project, identifying which data access methods need tests, or preparing for Oracle-to-PostgreSQL migration validation."},"skills_sh_url":"https://skills.sh/github/awesome-copilot/planning-oracle-to-postgres-migration-integration-testing"},"updatedAt":"2026-05-18T18:52:19.644Z"}}