--- title: Automate Oracle PL/SQL to PostgreSQL migration with... description: A detailed guide on building a generative AI-powered pipeline to automate the 'last mile' of Oracle PL/SQL to PostgreSQL migration. The solution uses Anthropic... canonical: https://daily.dev/posts/automate-oracle-pl-sql-to-postgresql-migration-with-amazon-bedrock-and-strands-agents-vu8tnpeha twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Automate Oracle PL/SQL to PostgreSQL migration with Amazon Bedrock and Strands Agents | daily.dev og:description: A detailed guide on building a generative AI-powered pipeline to automate the 'last mile' of Oracle PL/SQL to PostgreSQL migration. The solution uses Anthropic... og:url: https://daily.dev/posts/automate-oracle-pl-sql-to-postgresql-migration-with-amazon-bedrock-and-strands-agents-vu8tnpeha og:image: https://api.daily.dev/og/posts/vu8tNPehA.png og:image:alt: Automate Oracle PL/SQL to PostgreSQL migration with Amazon Bedrock and Strands Agents og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Automate Oracle PL/SQL to PostgreSQL migration with Amazon Bedrock and Strands Agents **[AWS Database Blog](https://daily.dev/sources/aws-database-blog)** · 18 min read · 0 upvotes · 0 comments ## Summary A detailed guide on building a generative AI-powered pipeline to automate the 'last mile' of Oracle PL/SQL to PostgreSQL migration. The solution uses Anthropic Claude Sonnet 4.6 on Amazon Bedrock, the Strands Agents framework, and the AWS Knowledge MCP Server to convert stored procedures, functions, and triggers that AWS DMS Schema Conversion leaves incomplete. The pipeline reads DMS SC assessment CSVs, fetches live PL/SQL from Oracle, converts each object, deploys to Aurora PostgreSQL via Lambda for immediate syntax validation, and runs 9 automated tests per object. Key lessons include handling model non-determinism at temperature 0, Lambda autocommit requirements for DDL persistence, and PostgreSQL's stricter compile-time dependency checking. Internal tests showed 92% average confidence at $0.15–$0.30 per 6 objects, with an estimated $15–$30 for 500 objects. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [How to migrate from Oracle to Amazon Aurora PostgreSQL using AWS CloudFormation \(Part 1\)](https://daily.dev/posts/how-to-migrate-from-oracle-to-amazon-aurora-postgresql-using-aws-cloudformation-part-1--rb6x7noud) · AWS Database Blog · 1 upvotes · 1 comments - [SQL Server to Aurora PostgreSQL conversion with AI agents for AWS DMS](https://daily.dev/posts/sql-server-to-aurora-postgresql-conversion-with-ai-agents-for-aws-dms-24wuiviyh) · AWS Database Blog · 0 upvotes · 0 comments - [AWS DMS Schema Conversion adds SAP \(Sybase\) ASE to PostgreSQL support with generative AI](https://daily.dev/posts/aws-dms-schema-conversion-adds-sap-sybase-ase-to-postgresql-support-with-generative-ai-6kkcht1lf) · AWS · 1 upvotes · 0 comments --- Tags: [#database](https://daily.dev/tags/database), [#postgresql](https://daily.dev/tags/postgresql), [#oracle](https://daily.dev/tags/oracle), [#amazon-bedrock](https://daily.dev/tags/amazon-bedrock) [View this post on daily.dev](https://daily.dev/posts/automate-oracle-pl-sql-to-postgresql-migration-with-amazon-bedrock-and-strands-agents-vu8tnpeha) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Automate Oracle PL/SQL to PostgreSQL migration with Amazon Bedrock and Strands Agents","url":"https://daily.dev/posts/automate-oracle-pl-sql-to-postgresql-migration-with-amazon-bedrock-and-strands-agents-vu8tnpeha","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/automate-oracle-pl-sql-to-postgresql-migration-with-amazon-bedrock-and-strands-agents-vu8tnpeha"},"datePublished":"2026-06-08T20:12:17.683Z","dateModified":"2026-06-08T20:17:07.801Z","description":"A detailed guide on building a generative AI-powered pipeline to automate the 'last mile' of Oracle PL/SQL to PostgreSQL migration. The solution uses Anthropic...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/cb8359e79d2425b25bf1c4d2f7849080?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/cb8359e79d2425b25bf1c4d2f7849080?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"AWS Database Blog","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"AWS Database Blog","logo":"https://media.daily.dev/image/upload/s--En-avd2a--/f_auto,q_auto/v1780213446/logos/aws-database-blog?_a=BAMAMiWQ0","url":"https://daily.dev/sources/aws-database-blog"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/automate-oracle-pl-sql-to-postgresql-migration-with-amazon-bedrock-and-strands-agents-vu8tnpeha","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"database,postgresql,oracle,amazon-bedrock","timeRequired":"PT18M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"AWS Database Blog","item":"https://daily.dev/sources/aws-database-blog"},{"@type":"ListItem","position":3,"name":"Automate Oracle PL/SQL to PostgreSQL migration with Amazon Bedrock and Strands Agents"}]} ```