brickly26/ms-access-mcp

开发工具

本页由 AI 翻译，技术细节请以原文为准。查看原文

26 stars 7 forks 质量 58 趋势 15

Repository Install

一台全面的模型上下文协议（MCP）服务器，覆盖了100%实用的Microsoft访问COM/DAO自动化表面。

概览

一台全面的模型上下文协议（MCP）服务器，覆盖了 Microsoft Access COM/DAO 自动化的 100% 实际情况。可兼容 Claude Desktop、Claude Code、VS Code（GitHub Copilot）及任何兼容 MCP 的客户端。该MCP服务器使AI助手能够通过完整的工具集与Microsoft Access数据库交互，涵盖： - - 连接、创建、备份、压缩/修复、关闭 - - 完整的DDL：创建/修改/重命名/丢弃表和字段、索引、计算字段、多值字段 - - 创建/更新/删除查询，执行SQL，直通查询，动作查询，参数化查询 - - 创建、更新、删除具有引用完整性的关系 - 创建表单，打开/关闭，获取/设置控制属性，运行时状态，条件格式化 - - 创建报告，分组/排序，输出/打印，控制属性 - - 完整的VBA IDE自动化：获取/设置代码，编译，运行过程，管理引用，模块分析 - - 创建/更新/运行/删除宏、数据......

概述（AI 翻译）

一个全面的模型上下文协议（MCP）服务器，提供360工具，覆盖100%实用的Microsoft Access COM/DAO自动化表面。支持Claude Desktop、Claude Code、VS Code（GitHub Copilot）及任何兼容MCP的客户端。

概述

该MCP服务器使AI助手能够通过完整的工具集与Microsoft Access数据库交互，涵盖：

连接与数据库生命周期 - 连接、创建、备份、压缩/修复、关闭
表、字段与模式 - 完整DDL：创建/更改/重命名/丢弃表和字段，索引，计算字段，多值字段
查询与SQL - 创建/更新/删除查询，执行SQL，直通查询，动作查询，参数化查询
关系 - 创建、更新、删除具有引用完整性的关系
表单与控件 - 创建表单、开/关闭、获取/设置控制属性、运行状态、条件格式化
报表与分组 - 创建报表、分组/排序、输出/打印、控制属性
VBA 及模块 - 完整的 VBA IDE 自动化：获取/设置代码、编译、执行过程、管理引用、模块分析

本页由 AI 翻译，技术细节请以原文为准。

README

以下为原文 README 节选，完整内容请查看原文。

Microsoft Access MCP Server

A comprehensive Model Context Protocol (MCP) server providing 360 tools that cover 100% of the practical Microsoft Access COM/DAO automation surface. Works with Claude Desktop, Claude Code, VS Code (GitHub Copilot), and any MCP-compatible client.

Overview

This MCP server enables AI assistants to interact with Microsoft Access databases through a complete toolset spanning:

Connection & database lifecycle - Connect, create, backup, compact/repair, close
Tables, fields & schema - Full DDL: create/alter/rename/drop tables and fields, indexes, calculated fields, multi-value fields
Queries & SQL - Create/update/delete queries, execute SQL, passthrough queries, action queries, parameterized queries
Relationships - Create, update, delete relationships with referential integrity
Forms & controls - Create forms, open/close, get/set control properties, runtime state, conditional formatting
Reports & grouping - Create reports, grouping/sorting, output/print, control properties
VBA & modules - Full VBA IDE automation: get/set code, compile, run procedures, manage references, module analysis
Macros - Create/update/run/delete macros, data macros, AutoExec
Linked tables - Create/refresh/relink/delete linked tables, ODBC links, refresh all
Transactions - Begin/commit/rollback with status tracking
DAO recordsets - Open/navigate/CRUD recordset operations with bookmarks and filtering
Database properties - Application options, startup properties, custom properties, DAO documents
TempVars - Set/get/remove/clear TempVars
Attachments - Add/remove/save attachment fields
Import/export - XML exchange, navigation pane XML, import/export specs, schema snapshots, VBA export
Navigation groups - Create/delete groups, add/remove objects
Security & encryption - Database passwords, encryption
Printing - PrintOut, OutputTo, printer management
DoCmd operations - Comprehensive DoCmd surface (beep, echo, hourglass, send object, follow hyperlink, etc.)
pyodbc compatibility - Drop-in replacement for 7 core pyodbc-access data tools

Architecture

The solution consists of two components:

MS.Access.MCP.Interop - A .NET 8.0 interop library providing COM/DAO late-binding access to Microsoft Access. Handles exclusive mode, dialog dismissal, process lifecycle, and OleDb connectivity.
MS.Access.MCP.Official - A self-contained MCP server implementing the JSON-RPC stdio transport. Supports MCP protocol versions 2024-11-05 and 2025-11-25 with full capability negotiation (tools, resources, prompts, logging, completions).

Prerequisites

Windows operating system

在 GitHub 查看完整 README

安装

This server does not publish a one-line install command.

Open the repository installation guide 新手？先看 mcpskill.org 教程 →

配置

{
  "mcpServers": {
    "access-mcp": {
      "command": "C:\\path\\to\\mcp-server-official-x64\\MS.Access.MCP.Official.exe",
      "args": []
    }
  }
}