My Access AI Server
שרת MCP עבור Microsoft Access
Ask AI about My Access AI Server
Powered by Claude · Grounded in docs
I know everything about My Access AI Server. Ask me about installation, configuration, usage, or troubleshooting.
0/500
Reviews
Documentation
Microsoft Access MCP Server
A Windows-native MCP server for Microsoft Access that exposes Access automation over JSON-RPC stdio for AI-enabled IDEs and MCP clients.
Overview
This repository delivers a complete Microsoft Access Model Context Protocol implementation with secure database access, COM automation, VBA extensibility, and export capabilities.
The project is structured into two main components:
MS.Access.MCP.Interop— .NET 8 library for Access data access, COM automation, and metadata toolsMS.Access.MCP.Official— MCP server implementation that exposes Access functions through JSON-RPC and MCP-compatible tool calls
Key Features
- Full JSON-RPC / MCP protocol compliance
- STA COM execution via a dedicated Access worker thread
- Async request queue with timeout enforcement and safe response delivery
- Zero stdio pollution for JSON-RPC clients
- Parameterized SQL execution with placeholder validation to reduce injection risk
- Table pagination with
ReadTableData(limit, offset) - Microsoft Access form, report, macro, and module discovery
- VBA and macro execution, code retrieval, code injection, and compile support
- System table metadata access and schema introspection
- Export report to PDF from Access
- Generate EF Core model scaffolding from Access schema
- IDE integration guidance for Windsurf, Cursor, Roo Code/Cline, and VS Code
Prerequisites
- Windows operating system
- Microsoft Access installed
- .NET 8.0 SDK / runtime
- Access database file (
.accdbor.mdb)
Installation & Setup
- Clone the repository.
- Restore and build the solution:
dotnet restore My-Access-AI-Server.sln
dotnet build My-Access-AI-Server.sln -c Release
- Publish the official MCP server:
dotnet publish MS.Access.MCP.Official/MS.Access.MCP.Official.csproj -c Release -r win-x64 --self-contained false -o .\publish
- Configure your MCP client or IDE to launch the published executable from
publish\MS.Access.MCP.Official.exe.
Running the Server
Use the published executable for reliable MCP stdio hosting:
.\publish\MS.Access.MCP.Official.exe
For development, run the server from source with:
dotnet run --project MS.Access.MCP.Official/MS.Access.MCP.Official.csproj -c Release
IDE Integration
See MCP_IDEs_SETUP.md for step-by-step examples connecting the server to:
- Windsurf
- Cursor
- Roo Code
- Cline
For Claude Desktop configuration, refer to CLAUDE_DESKTOP_CONFIG.md.
Development & Local Tasks
Local VS Code tasks are configured in .vscode/tasks.json:
Build MCP OfficialPublish MCP Official
Use these tasks to build, publish, and validate the project locally.
Testing
Run the complete solution tests with:
dotnet test My-Access-AI-Server.sln -c Release
The test suite verifies JSON-RPC parsing, tool registration, Access connectivity validation, macro/VBA tooling, PDF export readiness, EF Core model generation, and error handling.
Release Notes
See CHANGELOG.md for the initial v1.0.0 The Enterprise Release summary.
References
MCP_IDEs_SETUP.mdAI IDE integration examplesCLAUDE_DESKTOP_CONFIG.mdClaude Desktop MCP connection settings.vscode/tasks.jsonlocal build and publish automationMS.Access.MCP.OfficialMCP server implementationMS.Access.MCP.InteropAccess interop and automation library
CI Workflow
A Windows-based CI workflow is recommended to validate every commit with:
dotnet restoredotnet build My-Access-AI-Server.sln -c Releasedotnet test My-Access-AI-Server.sln -c Release
This workflow supports the projects Windows Access COM and .NET 8 requirements.
