--- title: Use VS Code Agents, GitHub Copilot, and the MSSQL... description: A walkthrough of building a semantic search app using VS Code's agentic experience, GitHub Copilot, and SQL Server 2025. The demo features a Next.js 'call for... canonical: https://daily.dev/posts/use-vs-code-agents-github-copilot-and-the-mssql-extension-to-build-ai-apps-data-exposed-unbblnx6m twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Use VS Code Agents, GitHub Copilot, and the MSSQL extension to build AI apps | Data Exposed | daily.dev og:description: A walkthrough of building a semantic search app using VS Code's agentic experience, GitHub Copilot, and SQL Server 2025. The demo features a Next.js 'call for... og:url: https://daily.dev/posts/use-vs-code-agents-github-copilot-and-the-mssql-extension-to-build-ai-apps-data-exposed-unbblnx6m og:image: https://api.daily.dev/og/posts/uNbBlnx6m.png og:image:alt: Use VS Code Agents, GitHub Copilot, and the MSSQL extension to build AI apps | Data Exposed 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. # Use VS Code Agents, GitHub Copilot, and the MSSQL extension to build AI apps | Data Exposed **[Microsoft Developer](https://daily.dev/sources/microsoftdeveloper)** · 19 min read · 0 upvotes · 0 comments ## Summary A walkthrough of building a semantic search app using VS Code's agentic experience, GitHub Copilot, and SQL Server 2025. The demo features a Next.js 'call for papers' app that uses SQL Server vector data types and vector distance for semantic search, with Prisma as the ORM for type safety. The workflow uses OpenSpec for spec-driven development inside VS Code's agent mode, allowing structured feature planning, proposal generation, and code application. The MSSQL extension is used to inspect the database schema, view embeddings, and verify data. A live bug fix is demonstrated where the agent modifies a SQL query to filter out past events, showing how GitHub Copilot agent mode integrates directly with SQL development. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [MSSQL Extension for VS Code: New Getting Started Page, Agent skills, SQL Formatter, and more](https://daily.dev/posts/mssql-extension-for-vs-code-new-getting-started-page-agent-skills-sql-formatter-and-more-yvnc8wtts) · DevBlogs · 0 upvotes · 0 comments - [How to build an app on Azure SQL with an AI coding agent](https://daily.dev/posts/how-to-build-an-app-on-azure-sql-with-an-ai-coding-agent-hyseem3y2) · DevBlogs · 0 upvotes · 0 comments --- Tags: [#github](https://daily.dev/tags/github), [#vscode](https://daily.dev/tags/vscode), [#microsoft-sql-server](https://daily.dev/tags/microsoft-sql-server), [#vector-search](https://daily.dev/tags/vector-search), [#prisma](https://daily.dev/tags/prisma) [View this post on daily.dev](https://daily.dev/posts/use-vs-code-agents-github-copilot-and-the-mssql-extension-to-build-ai-apps-data-exposed-unbblnx6m) ```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":"Use VS Code Agents, GitHub Copilot, and the MSSQL extension to build AI apps | Data Exposed","url":"https://daily.dev/posts/use-vs-code-agents-github-copilot-and-the-mssql-extension-to-build-ai-apps-data-exposed-unbblnx6m","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/use-vs-code-agents-github-copilot-and-the-mssql-extension-to-build-ai-apps-data-exposed-unbblnx6m"},"datePublished":"2026-05-21T20:32:25.130Z","dateModified":"2026-05-21T20:32:46.742Z","description":"A walkthrough of building a semantic search app using VS Code's agentic experience, GitHub Copilot, and SQL Server 2025. The demo features a Next.js 'call for...","image":"https://i.ytimg.com/vi/wZUPFCCByfw/sddefault.jpg","thumbnailUrl":"https://i.ytimg.com/vi/wZUPFCCByfw/sddefault.jpg","isAccessibleForFree":true,"articleSection":"Microsoft Developer","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":"Microsoft Developer","logo":"https://media.daily.dev/image/upload/s--xZzU3zUq--/f_auto/v1746714872/logos/microsoftdeveloper","url":"https://daily.dev/sources/microsoftdeveloper"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/use-vs-code-agents-github-copilot-and-the-mssql-extension-to-build-ai-apps-data-exposed-unbblnx6m","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"github,vscode,microsoft-sql-server,vector-search,prisma","timeRequired":"PT19M","video":{"@type":"VideoObject","name":"Use VS Code Agents, GitHub Copilot, and the MSSQL extension to build AI apps | Data Exposed","description":"A walkthrough of building a semantic search app using VS Code's agentic experience, GitHub Copilot, and SQL Server 2025. The demo features a Next.js 'call for...","thumbnailUrl":"https://i.ytimg.com/vi/wZUPFCCByfw/sddefault.jpg","uploadDate":"2026-05-21T20:32:25.130Z","duration":"PT19M","url":"https://api.daily.dev/r/uNbBlnx6m","embedUrl":"https://www.youtube.com/embed/wZUPFCCByfw"}} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Microsoft Developer","item":"https://daily.dev/sources/microsoftdeveloper"},{"@type":"ListItem","position":3,"name":"Use VS Code Agents, GitHub Copilot, and the MSSQL extension to build AI apps | Data Exposed"}]} ```