Aug 8 2026
Over the past few weeks, I’ve been moving my AI SQL Agent from my local laptop to a cloud-based architecture built on Microsoft Azure.
The project has reached another important milestone:
✅ Deployed the application to Azure App Service
✅ Built a public WordPress website as the front-end
✅ Integrated the AI SQL Agent directly into the website
✅ Connected the agent to a MySQL demonstration database
✅ Added support for both DML and DDL operations with role-based permissions
✅ Configured GitHub Actions for automated CI/CD deployments
✅ Registered a custom domain and enabled HTTPS/SSL
The current architecture includes:
☁️ Microsoft Azure App Service
🤖 Azure OpenAI
🗄️ Azure Database for MySQL
🌐 WordPress front-end
⚙️ FastAPI backend
🔄 GitHub Actions deployment pipeline
The AI agent can already:
• Generate SQL from natural language
• Execute secure SELECT, INSERT, UPDATE, and DELETE statements (depending on user permissions)
• Perform administrative DDL operations such as CREATE TABLE, ALTER TABLE for authorized users
• Explain generated SQL
• Return results as interactive tables
• Generate charts from query results
• Maintain conversation context throughout the session
To make the experience more transparent, the website also includes a demonstration database explorer. Visitors can browse the database schema, view tables and columns, and inspect sample records before interacting with the AI. This helps users better understand the available data and ask more meaningful questions using natural language.
This is still an early stage of the project, but the long-term vision is much broader than an SQL assistant.
Excited to continue building and sharing the journey.
#AI#ArtificialIntelligence#Azure#AzureOpenAI#MicrosoftAzure#WordPress#FastAPI#Python#SQL#DataEngineering#ETL#CloudComputing#MySQL#GitHubActions#Automation#OpenAI#EnterpriseAI#GenerativeAI#SoftwareEngineering#AIAgents
