{"id":3848,"date":"2024-11-19T08:00:33","date_gmt":"2024-11-19T16:00:33","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/azure-sql\/?p=3848"},"modified":"2025-01-08T09:09:12","modified_gmt":"2025-01-08T17:09:12","slug":"langchain-with-sqlvectorstore","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azure-sql\/langchain-with-sqlvectorstore\/","title":{"rendered":"Announcing LangChain integration for your SQL-based AI applications"},"content":{"rendered":"<p>In today&#8217;s data-driven world, the ability to seamlessly integrate various technologies is crucial for efficient data management and analysis. We\u2019re excited to announce LangChain integration with Azure SQL Database and SQL database in Microsoft Fabric!<\/p>\n<p><a href=\"https:\/\/python.langchain.com\/docs\/introduction\/\">LangChain<\/a>, a powerful tool for building solutions with language models, can be effectively combined with these services to build AI-ready applications.<\/p>\n<p><strong>What\u2019s New?<\/strong><\/p>\n<p><strong>Native Vector Support:<\/strong> SQL Database and SQL database in Fabric now support native vector search capabilities. This new capability brings the power of vector search operations directly to your SQL databases, enabling faster and more efficient data queries. Dive into the full announcement of the public preview to learn more <a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/exciting-announcement-public-preview-of-native-vector-support-in-azure-sql-database\/\">here.<\/a><\/p>\n<p><strong>Introducing the LangChain-SQLServer Package:<\/strong> We are thrilled to unveil the <a href=\"https:\/\/pypi.org\/project\/langchain-sqlserver\/\">langchain-sqlserver<\/a> package, a game-changer for managing SQL Server as a Vectorstore in LangChain. <a href=\"https:\/\/python.langchain.com\/docs\/introduction\/\">LangChain<\/a> is a highly popular open-source framework that provides pre-built components to simplify the creation of complex applications using language models (LLMs).<\/p>\n<p>This new release brings enhanced capabilities by parsing connection strings, making it easier than ever to integrate with SQL Database.\u00a0LangChain also has established a robust integration with various <a href=\"https:\/\/python.langchain.com\/docs\/integrations\/providers\/microsoft\">Microsoft products<\/a> making it easier for developers to build sophisticated applications using Microsoft&#8217;s powerful tools and services.\u00a0Whether you are building generative AI applications or enhancing existing ones, Microsoft SQL, <a href=\"https:\/\/pypi.org\/project\/langchain-sqlserver\/\">LangChain<\/a>, and LLMs make it easy with just a few lines of code.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/11\/LC_SQL.png\"><img decoding=\"async\" class=\"alignnone wp-image-3916\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/11\/LC_SQL.png\" alt=\"Image LC SQL\" width=\"675\" height=\"375\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/11\/LC_SQL.png 1724w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/11\/LC_SQL-300x167.png 300w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/11\/LC_SQL-1024x569.png 1024w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/11\/LC_SQL-768x427.png 768w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/11\/LC_SQL-1536x854.png 1536w\" sizes=\"(max-width: 675px) 100vw, 675px\" \/><\/a><\/p>\n<p><strong>Ready to Get Started?<\/strong><\/p>\n<p>Check out our step-by-step tutorial to learn how to add generative AI features to your applications effortlessly using Azure SQL Database, LangChain, and LLMs here: <a href=\"https:\/\/aka.ms\/langchainsqlexample\">aka.ms\/langchainsqlexample<\/a><\/p>\n<p><strong>What&#8217;s Next?<\/strong><\/p>\n<p>We\u2019re thrilled to unveil this new capability, but it\u2019s just the start! The SQL team is rapidly advancing in this area and will be making more exciting announcements in the coming months to further enhance this capability. Above all, we\u2019re eager to stay connected with the community to ensure we\u2019re delivering the functionalities you need.<\/p>\n<p>A huge thank you to the SQL Product and Engineering team and LangChain maintainers for their support.<\/p>\n<p><strong>Stay Connected<\/strong><\/p>\n<p>Follow us for more updates and exciting developments, check out <a href=\"https:\/\/aka.ms\/sqlai\">aka.ms\/sqlai<\/a> and <a href=\"https:\/\/aka.ms\/sqlaisamples\">aka.ms\/sqlaisamples<\/a> for more detailed documentation and samples. Stay tuned and let\u2019s keep the conversation going!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In today&#8217;s data-driven world, the ability to seamlessly integrate various technologies is crucial for efficient data management and analysis. We\u2019re excited to announce LangChain integration with Azure SQL Database and SQL database in Microsoft Fabric! LangChain, a powerful tool for building solutions with language models, can be effectively combined with these services to build AI-ready [&hellip;]<\/p>\n","protected":false},"author":99201,"featured_media":3916,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[601,1,605,615],"tags":[590,510,637],"class_list":["post-3848","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai","category-azure-sql","category-langchain","category-vectors","tag-ai","tag-azure-sql-database","tag-microsoft-fabric"],"acf":[],"blog_post_summary":"<p>In today&#8217;s data-driven world, the ability to seamlessly integrate various technologies is crucial for efficient data management and analysis. We\u2019re excited to announce LangChain integration with Azure SQL Database and SQL database in Microsoft Fabric! LangChain, a powerful tool for building solutions with language models, can be effectively combined with these services to build AI-ready [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/3848","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/users\/99201"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/comments?post=3848"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/3848\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media\/3916"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media?parent=3848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/categories?post=3848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/tags?post=3848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}