Mission: open mission administrative works with rowlevel security through agents

Mission/open goal Description

Mission Goal

Build an AI-assisted database workflow using GitHub Copilot Agent Mode, Model Context Protocol (MCP), and Microsoft Data API Builder.

---

Project Description

This project demonstrates integrating GitHub Copilot Agent Mode with MCP and Microsoft Data API Builder to interact with SQL Server data.

The workflow connects AI assistance with backend database services using AdventureWorksLT2025 as the sample database.

The solution includes MCP configuration, DAB setup, SQL Server connectivity, and supporting documentation.

---

Harness and Model

• GitHub Copilot Chat (Agent Mode)
• GPT-5.5
• Visual Studio Code
• Model Context Protocol (MCP)
• Microsoft Data API Builder
• SQL Server
• AdventureWorksLT2025

---

Turn-by-turn Journey

Prompt

Configure an AI-assisted database workflow using GitHub Copilot Agent Mode, MCP, DAB, and SQL Server.

Agent Response / Action

The agent assisted with:

• Understanding project requirements
• Creating MCP workflow configuration
• Configuring Microsoft Data API Builder
• Connecting SQL Server database
• Creating supporting documentation and artifacts

Result

Successfully created an AI-assisted workflow where GitHub Copilot can work with MCP and database services.

---

Completion

✅ Yes, the agent completed the mission.

---

Bonus Work

Additional improvements:

• Added project documentation
• Added architecture documentation
• Added artifact files and evidences stating the outputs
• Added SQL configuration files and sql files for rowlevel security
• Structured repository for submission

---

Source Code Repository

https://github.com/brinda-lax/Mission-open-mission-mcp-copilot

Harness and model

GitHub Copilot Chat

Turn-by-turn journey

used github copilot chat to complete my mission

Completion

• Yes, the agent completed the mission or goal.
• No, the agent did not complete the mission or goal.

Bonus work

No response

Review the MCP configuration, Microsoft Data API Builder setup, SQL configuration files, SQL files for row-level security, and supporting documentation described in the issue. Start by examining the linked source repository and verify that the Copilot Agent Mode workflow connects to SQL Server and completes the documented database operations.