microsoft/Modernize-your-code-solution-accelerator

microsoft/Modernize-your-code-solution-accelerator

Description: Designed to help customers transition their SQL queries to new environments quickly and efficiently. This accelerator is particularly useful for organizations modernizing their data estates, as it simplifies the process of translating SQL queries from various dialects.

Language: Python

License: MIT

Stars: 133

Forks: 514

Open issues: 8

Created: 2025-02-03T23:02:38Z

Pushed: 2026-06-11T06:31:11Z

Default branch: main

Fork: no

Archived: no

README:

Modernize your code solution accelerator

Welcome to the *Modernize your code* solution accelerator, designed to help customers transition their SQL queries to new environments quickly and efficiently. This accelerator is particularly useful for organizations modernizing their data estates, as it simplifies the process of translating SQL queries from various dialects.

When dealing with legacy code, users often face significant challenges, including the absence of proper documentation, loss of knowledge of outdated languages, and missing business logic that explains functional requirements.

The Modernize your code solution accelerator allows users to specify a group of SQL queries and the target SQL dialect for translation. It then initiates a batch process where each query is translated using a group of Large Language Model (LLM) agents. This automation not only saves time but also ensures accuracy and consistency in query translation.

---

[SOLUTION OVERVIEW](#solution-overview) \| [QUICK DEPLOY](#quick-deploy) \| [BUSINESS SCENARIO](#business-scenario) \| [SUPPORTING DOCUMENTATION](#supporting-documentation)

---

Note: With any AI solutions you create using these templates, you are responsible for assessing all associated risks and for complying with all applicable laws and safety standards. Learn more in the transparency documents for Agent Service and Agent Framework.

Solution overview

The solution leverages Azure AI Foundry, Azure OpenAI Service, Azure Container Apps, Azure Cosmos DB, and Azure Storage to create an intelligent code modernization pipeline. It uses a multi-agent approach where specialized AI agents work together to translate, validate, and optimize SQL queries for the target environment.

Solution architecture

|| |---|

This architecture will be deployed with the 'sandbox' setting of our deployment process. Optionally you can deploy Well-Architected Framework (WAF) aligned architecture, described in [WAF-Aligned Solution Architecture](./docs/ArchitectureWAF.md), with the WAF-Aligned deployment option described in [Deployment Guide](./docs/DeploymentGuide.md).

Agentic architecture

|| |---|

Additional resources

If you'd like to customize the solution accelerator, here are some common areas to start:

[Custom scenario](./docs/CustomizingScenario.md)

For detailed technical information, see the component documentation:

Azure AI Foundry documentation

Semantic Kernel Agent Framework

Azure OpenAI Service Documentation

---

Features

Key features

Click to learn more about the key features this solution enables

• Code language modernization

Modernizing outdated code ensures compatibility with current technologies, reduces reliance on legacy expertise, and keeps businesses competitive.

• Summary and review of new code

Generating summaries and translating code files keeps humans in the loop, enhances their understanding, and facilitates timely interventions, ensuring the files are ready to export.

• Business logic analysis

Leveraging AI to decipher business logic from legacy code helps minimizes the risk of human error.

• Efficient code transformation

Streamlining the process of analyzing, converting, and iterative error testing reduces time and effort required to modernize the systems.

---

Getting Started

Quick deploy

How to install or deploy

Follow the quick deploy steps on the deployment guide to deploy this solution to your own Azure subscription.

> Note: This solution accelerator requires Azure Developer CLI (azd) version 1.18.0 or higher. Please ensure you have the latest version installed before proceeding with deployment. Download azd here.

> Note: This solution accelerator also requires Bicep CLI version 0.33.0 or higher for compiling infrastructure templates. Install Bicep.

[Click here to launch the deployment guide](./docs/DeploymentGuide.md)

|---|---|---|

> Note: Some tenants may have additional security restrictions that run periodically and could impact the application (e.g., blocking public network access). If you experience issues or the application stops working, check if these restrictions are the cause. In such cases, consider deploying the WAF-supported version to ensure compliance. To configure, [Click here](./docs/DeploymentGuide.md#31-choose-deployment-type-optional).

> ⚠️ Important: Check Azure OpenAI Quota Availability > To ensure sufficient quota is available in your subscription, please follow [quota check instructions guide](./docs/quota_check.md) before you deploy the solution.

Guidance

Prerequisites and costs

To deploy this solution accelerator, ensure you have access to an Azure subscription with the necessary permissions to create resource groups, resources, app registrations, and assign roles at the resource group level. This should include Contributor role at the subscription level and Role Based Access Control role on the subscription and/or resource group level. Follow the steps in [Azure Account Set Up](./docs/AzureAccountSetUp.md).

Here are some example regions where the services are available: East US, East...