{"kind":"Skill","metadata":{"namespace":"community","name":"planning-oracle-to-postgres-migration-integration-testing","version":"0.1.0"},"spec":{"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.","files":{"SKILL.md":"---\nname: planning-oracle-to-postgres-migration-integration-testing\ndescription: '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.'\n---\n\n# 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.\n"},"import":{"commit_sha":"541b7819d8c3545c6df122491af4fa1eae415779","imported_at":"2026-05-18T20:05:35Z","license_text":"MIT License\n\nCopyright GitHub, Inc.\n\nPermission is hereby granted, free of charge, to any person obtaining a copy\nof this software and associated documentation files (the \"Software\"), to deal\nin the Software without restriction, including without limitation the rights\nto use, copy, modify, merge, publish, distribute, sublicense, and/or sell\ncopies of the Software, and to permit persons to whom the Software is\nfurnished to do so, subject to the following conditions:\n\nThe above copyright notice and this permission notice shall be included in all\ncopies or substantial portions of the Software.\n\nTHE SOFTWARE IS PROVIDED \"AS IS\", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR\nIMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,\nFITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE\nAUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER\nLIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,\nOUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE\nSOFTWARE.","owner":"github","repo":"github/awesome-copilot","source_url":"https://github.com/github/awesome-copilot/tree/541b7819d8c3545c6df122491af4fa1eae415779/plugins/oracle-to-postgres-migration-expert/skills/planning-oracle-to-postgres-migration-integration-testing"}},"content_hash":[61,146,131,185,40,118,179,170,59,231,69,159,254,55,194,69,25,4,87,196,200,25,62,233,114,13,222,160,186,52,177,152],"trust_level":"unsigned","yanked":false}