Happy slice of mcp pizzaMCP.pizza

MCP-Access

MCP.Pizza Chef: unmateria

This server lets you control every part of a Microsoft Access database (.accdb) using plain English commands. You can create forms, write and run VBA code, design tables, manage controls, run queries, and more — all without needing to open Access or write code yourself. It works on Windows with Access installed and integrates with AI clients like Claude Code, Cursor, and Windsurf. Setup requires some developer steps but then you can manage Access databases through your AI assistant.

Coding
Files/PDF
Other

Use This MCP server To

Create a new form with controls using simple instructions Write and update VBA code inside my Access database Add or modify tables and fields without opening Access UI Run SQL queries and get results from my Access data List and change properties of controls on forms and reports Compact and repair my Access database automatically Generate documentation of my database structure

README

mcp-access

Give any AI assistant full control over Microsoft Access databases.

Create forms, write VBA, design tables, manage controls, run queries, build relationships, and edit every corner of an .accdb — all through natural language. 68 tools that turn Access into something you can talk to.

No Access expertise required. Just describe what you want.

"Create a form called Invoices with a ListBox, two date filters, and a search button"
"Add a VBA click handler that filters the recordsource by date range"
"Create a table called audit_log with timestamp, user, and action fields"
"List all controls inside the Payment tab and change the combo's row source"

The AI handles the COM automation, design view, VBA modules, binary sections, cache invalidation, and all the ugly parts. You get the result.

What it can do

  • Forms & Reports — create, clone, export, import, screenshot, click, type. Full UI automation loop
  • VBA — read, write, replace, compile, and run procedures. Line-level or full-proc editing
  • Controls — create, delete, modify, list, set tab order. Finds controls nested inside TabControl pages
  • Tables & SQL — create via DAO, alter, query, batch execute, full-text search across every Text/Memo field. Linked ODBC tables supported
  • Relationships, indexes, references, queries, macros — full CRUD. Clone any object (form / report / module / class / query / macro) preserving VBA and binary sections
  • Maintenance — compact & repair, decompile bloated databases, export structure docs. Office install autodetected (no more hardcoded Office 16 paths)
  • UI lint — access_lint_form flags objectively broken layouts (white-on-white text, overlaps, truncation, off-canvas controls). A checker, not a designer — see the note below

Works with Claude Code, Cursor, Windsurf, Continue, or any MCP-compatible client.

Requirements

  • Windows (COM automation is Windows-only)
  • Microsoft Access installed (any version that supports VBE, 2010+)
  • Python 3.9+
  • "Trust access to the VBA project object model" enabled in Access Trust Center

Installation

pip install mcp pywin32

Enable VBA object model access

File → Options → Trust Center → Trust Center Settings → Macro Settings → check Trust access to the VBA project object model

Or run the included PowerShell script:

.\enable_vba_trust.ps1

MCP-Access FAQ

Can I use this to create and edit forms in Microsoft Access?
Yes — you can create, modify, and manage forms using natural language commands through supported clients like Claude Code, Cursor, or Windsurf.
Can I edit VBA code in my Access database using this?
Yes — it allows reading, writing, replacing, compiling, and running VBA procedures inside your Access .accdb file.
Which apps can I use this with?
It works with any MCP-compatible client such as Claude Code, Cursor, Windsurf, and Continue.
Do I need Microsoft Access installed?
Yes — Microsoft Access (2010 or later) must be installed on a Windows machine to use this server.
Is setup difficult for a non-developer?
Yes — it requires Python 3.9+, enabling VBA project access in Access Trust Center, and some configuration, so it's developer-level setup.
Do I need an API key or account?
No — this server runs locally and does not require any API keys or external accounts.