{"id":1741,"date":"2026-08-10T12:25:32","date_gmt":"2026-08-10T12:25:32","guid":{"rendered":"https:\/\/vykhodtsev.dev\/?p=1741"},"modified":"2026-08-10T12:25:32","modified_gmt":"2026-08-10T12:25:32","slug":"%f0%9f%93%8a-ai-sql-agent-can-now-generate-charts-directly-from-natural-language-queries","status":"publish","type":"post","link":"https:\/\/vykhodtsev.dev\/?p=1741","title":{"rendered":"\ud83d\udcca AI SQL Agent can now generate charts directly from natural language queries"},"content":{"rendered":"\n

Aug 9 2026
Another exciting milestone for my AI SQL Agent!
The latest version goes beyond generating SQL and displaying tables\u2014it can now automatically create visualizations based on query results.
Users can simply ask questions like:
Show total sales by month
Display revenue by product group
Compare product sales in July
Create a pie chart of sales by category
The AI Agent will:
\u2705 Understand the natural language request
\u2705 Generate the appropriate SQL query
\u2705 Execute it against the database
\u2705 Return the data as an interactive chart
Current visualization capabilities include:
\ud83d\udcc8 Line charts for trends over time
\ud83d\udcca Bar charts for comparisons
\ud83e\udd67 Pie charts for category distributions
To make the experience even more intuitive, the website also provides a built-in Database Explorer where users can browse:
database schema
tables
columns
sample records
This allows users to understand the available data before asking questions and see exactly how the AI translates natural language into SQL.
The complete demo is built with:
Microsoft Azure App Service
Azure OpenAI
FastAPI
WordPress front end
Azure Database for MySQL
GitHub Actions CI\/CD
This is another step toward my vision of building AI-powered engineering assistants that simplify SQL development, analytics, ETL, and enterprise data workflows.<\/p>\n\n\n\n

#AI<\/strong><\/a>#ArtificialIntelligence<\/strong><\/a>#Azure<\/strong><\/a>#AzureOpenAI<\/strong><\/a>#DataEngineering<\/strong><\/a>#SQL<\/strong><\/a>#Python<\/strong><\/a>#FastAPI<\/strong><\/a>#WordPress<\/strong><\/a>#MySQL<\/strong><\/a>#DataVisualization<\/strong><\/a>#BusinessIntelligence<\/strong><\/a>#Analytics<\/strong><\/a>#GenerativeAI<\/strong><\/a>#EnterpriseAI<\/strong><\/a>#Automation<\/strong><\/a>#CloudComputing<\/strong><\/a>#GitHubActions<\/strong><\/a>#AIAgents<\/strong><\/a>#MicrosoftAzure<\/strong><\/a><\/p>\n\n\n\n

\"screenshot<\/figure>\n\n\n\n
\"screenshot<\/figure>\n\n\n\n
\"screenshot<\/figure>\n\n\n\n
\"screenshot<\/figure>\n","protected":false},"excerpt":{"rendered":"

Aug 9 2026Another exciting milestone for my AI SQL Agent!The latest version goes beyond generating SQL and displaying tables\u2014it can now automatically create visualizations based on query results.Users can simply ask questions like:Show total sales by monthDisplay revenue by product groupCompare product sales in JulyCreate a pie chart of sales by categoryThe AI Agent will:\u2705 […]<\/p>\n","protected":false},"author":1,"featured_media":1744,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1741","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"spectra_blocks_featured_image_url":{"thumbnail":{"url":"https:\/\/vykhodtsev.dev\/wp-content\/uploads\/2026\/08\/Screenshot-2026-08-09-190715-150x150.png","width":150,"height":150},"medium":{"url":"https:\/\/vykhodtsev.dev\/wp-content\/uploads\/2026\/08\/Screenshot-2026-08-09-190715-300x264.png","width":300,"height":264},"medium_large":{"url":"https:\/\/vykhodtsev.dev\/wp-content\/uploads\/2026\/08\/Screenshot-2026-08-09-190715-768x675.png","width":768,"height":675},"large":{"url":"https:\/\/vykhodtsev.dev\/wp-content\/uploads\/2026\/08\/Screenshot-2026-08-09-190715-1024x900.png","width":1024,"height":900},"full":{"url":"https:\/\/vykhodtsev.dev\/wp-content\/uploads\/2026\/08\/Screenshot-2026-08-09-190715.png","width":1300,"height":1143}},"spectra_blocks_author_info":{"display_name":"Aleksei","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/198b25ea575ebb3cbd0934cb05fd942d0f256a65d3ff388a161c857e00b092bf?s=96&d=mm&r=g","author_link":"https:\/\/vykhodtsev.dev\/?author=1","description":""},"_links":{"self":[{"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=\/wp\/v2\/posts\/1741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1741"}],"version-history":[{"count":1,"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=\/wp\/v2\/posts\/1741\/revisions"}],"predecessor-version":[{"id":1752,"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=\/wp\/v2\/posts\/1741\/revisions\/1752"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=\/wp\/v2\/media\/1744"}],"wp:attachment":[{"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vykhodtsev.dev\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}