# MCP Dataverse Server
MCP server for performing CRUD operations on Microsoft Dataverse databases using service principal authentication.
## Prerequisites
1. **Azure AD App Registration:**
- Register an application in Azure AD
- Create a client secret
- Note the Tenant ID, Client ID, and Client Secret
2. **Dataverse Setup:**
- Grant the app "Dynamics CRM" API permissions in Azure AD
- Add the application as a user in Dataverse
- Assign appropriate security role (e.g., System Administrator)
## Environment Variables
```bash
DATAVERSE_URL=https://yourorg.crm.dynamics.com
TENANT_ID=your-tenant-id
CLIENT_ID=your-client-id
CLIENT_SECRET=your-client-secret
```
## Local Development
```bash
# Install dependencies
npm install
# Build
npm run build
# Run
npm start
```
## Docker Deployment
```bash
# Build image
docker build -t mcp-dataverse-server .
# Run container
docker run -i \
-e DATAVERSE_URL=https://yourorg.crm.dynamics.com \
-e TENANT_ID=your-tenant-id \
-e CLIENT_ID=your-client-id \
-e CLIENT_SECRET=your-client-secret \
mcp-dataverse-server
```
## Available Tools
- **create_record**: Create new records in tables
- **update_record**: Update existing records
- **delete_record**: Delete records
- **query_records**: Query records with OData filters
- **list_tables**: List all available tables
- **get_table_schema**: Get column metadata for a table
## Usage with bolt.new
Configure your bolt.new app to connect to this MCP server via stdio transport. The server handles all authentication transparently.
## Example Operations
**Create a record:**
```json
{
"table": "accounts",
"data": {
"name": "Contoso Ltd",
"telephone1": "555-0100"
}
}
```
**Query records:**
```json
{
"table": "accounts",
"select": ["name", "telephone1"],
"filter": "revenue gt 1000000",
"top": 10
}
```
# dataverse_mcp_server
"# dataverse_mcp_server"
