Access-MCP：让 AI 智能体原生操作 Microsoft Access 的 MCP 服务器

The MCP server that lets AI agents work natively with Microsoft Access.
97 tools packed into 27 smart tools · VS Code & Cursor extension · Windows + Access · Free tier + Pro

Website · Docs · Download · Support · Migration Services

Access-MCP gives AI agents — Claude, Cursor, GitHub Copilot, Codex, and any MCP-capable client — full, structured access to Microsoft Access databases on Windows: read schema, run SQL, refactor VBA, design forms and reports, directly against live .accdb/.mdb files.

97 tools packed into 27 smart tools. Each smart tool groups related operations, so your agent loads 27 tool definitions instead of 97 — less context spent on tool lists, fewer wrong calls and retries, fewer tokens per task.

This is the distribution repository: releases, plugin packages, install templates. The product's source code is closed; what ships from here is accessmcp.exe (as a signed release asset), plugin manifests, skills, and an open-source bootstrap. Sign-in is built in: run accessmcp login once per machine (free account, ~20 seconds in the browser).

Choose your AI client

Client	Install
VS Code / Cursor extension (recommended)	VS Code Marketplace · Open VSX (Cursor, Windsurf, VSCodium) — see below
Claude Code	`/plugin marketplace add A-Point-Systems-ltd/access-mcp` then `/plugin install accessmcp@accessmcp`
Claude Desktop	Download `accessmcp.mcpb` from Releases — double-click to install
Cursor	Add to Cursor button on access-mcp.ai, or `templates/cursor/`
VS Code + Copilot	Plugin (MCP + skills) or MCP-only — see `templates/vscode/`
Codex	`codex mcp add` / `config.toml` — see `templates/codex/`
Any other MCP client	Point a stdio MCP config at `accessmcp.exe` (below)

VS Code / Cursor extension (recommended)

The access-mcp.ai extension (apoint.ms-access-mcp) bundles the server — no exe download, no mcp.json editing.

Install it from the VS Code Marketplace or Open VSX (Cursor, Windsurf, VSCodium).
Command Palette → Access-MCP: Select / Change Database and pick your .accdb, .mdb or .adp. The server starts only once a database is selected.
Open Copilot Chat → Agent mode and confirm Access-MCP is in the MCP servers list. The Access-MCP view in the activity bar lets you browse the database's objects.

Cursor: Cursor ignores MCP servers contributed by extensions. Run Access-MCP: Register Server in mcp.json (Cursor) once (the extension offers it automatically on first run), then reload. It writes an ms-access entry to ~/.cursor/mcp.json or <workspace>/.cursor/mcp.json.

Step-by-step guides: VS Code · Cursor.

Direct download / advanced setup

The exe is the product; everything above is convenience. This path always works with none of it:

Download accessmcp.exe (verify with SHA256SUMS.txt / release-manifest.json from the same release). It is self-contained — no .NET install needed.
Put it anywhere you like, and sign in once: accessmcp login.
Point your client's MCP config at it, with the database this server works on pinned in args — required; the server only ever touches the file pinned there:

{
  "mcpServers": {
    "accessmcp": {
      "command": "C:\\path\\to\\accessmcp.exe",
      "args": ["C:\\Data\\YourDatabase.accdb"]
    }
  }
}

Or let installer/install-accessmcp.ps1 do it: per-user, no admin rights, merges (never overwrites) your existing client configs.

97 tools packed into 27 smart tools

Your agent loads 27 tool definitions instead of 97 — less context spent on tool lists, fewer wrong calls and retries, fewer tokens per task.

Group	Smart tools	What it covers / key actions
Session (3)	`Session_OpenDatabase`, `Session_CloseDatabase`, `Session_GetDatabaseInfo`	Open, close and describe the database
Object (14)	`Object_List`, `Object_Get`, `Object_Create`, `Object_Delete`, `Object_Update`, `Object_Design`, `Object_Run`, `Object_Close`, `Object_GetProperties`, `Object_SetProperties`, `Object_GetControlProperties`, `Object_SetControlProperties`, `Object_AddControls`, `Object_DeleteControls`	List 7 object types, read 6 aspects of an object, create / update / delete / design / run / close objects, and read or edit object and control properties and controls
Query (3)	`Query_Read`, `Query_Execute`, `Query_ExecuteBatch`	Read queries, single action statements, and batches
Data (1)	`Data_Transfer`	Import and export CSV or Excel
VBA (2)	`VBA_Read`, `VBA_Updates`	Read: `getCode`, `getProjects`, `getModules`, `getReferences`, `search`. Updates (12 actions): `setCode`, `setProcedure`, `patchProcedure`, `createModule`, `compile`, `addReferenceByGuid`, `addReferenceByFile`, `removeReference`, `addProcedure`, `deleteModule`, `deleteProcedure`, `setCodeFromFile`
System (4)	`System_Read`, `System_Updates`, `System_Logs`, `System_Audit`	Read: `getAutoCloseStatus`, `getReadOnly`, `getDatabaseInfo`, `healthCheck`, `showAccess`, `hideAccess`, `getDialogHistory`, `getToolContracts`. Updates: `setAutoClose`, `setReadOnly`. Logs: `get`, `clear`. Audit: `session`, `getTraces`, `readTrace`

tools/list also shows the account tools access_login and access_whoami. The 97 legacy granular tool names keep working — an alias map routes them to the smart tools.

Requirements

Windows 10/11 x64 (or Windows Server, 64-bit) — native, not WSL or a remote container (supported platforms)
Microsoft Access 2010 or later, 32-bit or 64-bit (the server drives it via COM)
Extension: VS Code 1.101+, or an Open VSX editor (Cursor, Windsurf, VSCodium)
Exe: self-contained — no .NET runtime to install
Works with .accdb, .mdb and (with limits) .adp

Pricing

Free — read-only access, 50 operations/day. Free account: sign in with Microsoft, Google or GitHub. No card.
14-day trial — all 27 smart tools. Starts at your first sign-in. No card.
Pro — $49/developer/month or $529/year: unlimited operations, writes, VBA, forms and batch.
Enterprise — custom.

Details: https://access-mcp.ai.

What's in this repository

Path	What
`agent-plugin/`	The canonical plugin package: manifest, skills, open-source bootstrap
`claude-plugin/`	Claude Code adapter over the canonical package
`.claude-plugin/`	Marketplace manifest for `/plugin marketplace add`
`templates/`	Per-client MCP config templates (Claude Desktop/Code, Cursor, VS Code, Codex)
`installer/`	`install-accessmcp.ps1` + diagnostics spec
`compliance/`	Directory-submission preflight checklist

Release assets (accessmcp.exe, accessmcp.mcpb, SHA256SUMS.txt, release-manifest.json) are published here by the product's release pipeline; no binaries live in git.

Privacy

Your database contents and object names never leave your machine — the server-side account only sees identity, version, machine fingerprint and per-tool usage counts. Full policy: https://access-mcp.ai/privacy.

License

Proprietary — see LICENSE. The bootstrap script and the plugin manifests in this repository are provided openly so you can audit exactly what runs on your machine; the product binary is closed-source.

_{From A-Point Systems, makers of the open-source
MSSQL-MCP
(VS Marketplace ·
Open VSX):
a free, MIT-licensed SQL Server MCP server with 23 tools, strict read/write
routing, named connections (including read-only), compact TOON query results
and an AI Insights cache so repeat investigations cost fewer tokens.}