Microsoft Access Database — Claude Code MCP server: how to install
Connects AI coding assistants to Microsoft Access files. Enables automated form design, DAO table creation, SQL execution, and live VBA editing.
claude mcp add msaccess-database -- uvx mcp-msaccess-databaseWhat Microsoft Access Database does
This server connects AI clients to Access databases using Windows COM automation. It exposes 69 tools for database administration, including DAO table generation, multi-statement SQL execution, and UI inspection via access_lint_form. The assistant can read or update VBA procedures directly, edit lines inside modules, and scan queries across the file without manual exports.
This integration runs exclusively on Windows. It requires Microsoft Access 2010 or newer, Python 3.10+, and the pywin32 package. Programmatic updates to macros will fail unless macro settings permit direct interaction with the VBA project model.
What it helps with
- build Access forms without blocking dialog boxes
- patch specific lines inside a VBA module procedure
- create database tables with keys and types using DAO
- locate table references across all saved queries
- inspect form layouts for overlapping controls and clipped labels
Example prompts for the agent
- Create an Invoices form with two date inputs and a search button
- Inspect the VBA module and update the click handler logic
- Run a batch SQL statement to update customer records
How to install Microsoft Access Database
Platform CLI
claude mcp add msaccess-database -- uvx mcp-msaccess-databaseuvx runs the command named after the package; if the README names another one, use uvx --from mcp-msaccess-database <command>
Platform CLI
codex mcp add microsoft-access-database -- uvx mcp-msaccess-databaseuvx runs the command named after the package; if the README names another one, use uvx --from mcp-msaccess-database <command>
Config file
{
"mcpServers": {
"microsoft-access-database": {
"command": "uvx",
"args": [
"mcp-msaccess-database"
]
}
}
}uvx runs the command named after the package; if the README names another one, use uvx --from mcp-msaccess-database <command>
Config file
{
"servers": {
"microsoft-access-database": {
"type": "stdio",
"command": "uvx",
"args": [
"mcp-msaccess-database"
]
}
}
}uvx runs the command named after the package; if the README names another one, use uvx --from mcp-msaccess-database <command>
Platform CLI
gemini mcp add microsoft-access-database uvx mcp-msaccess-databaseuvx runs the command named after the package; if the README names another one, use uvx --from mcp-msaccess-database <command>
Step by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about Microsoft Access Database
How do I install Microsoft Access Database in Claude Code?
Run claude mcp add microsoft-access-database -- uvx mcp-msaccess-database. The client registers the server using uvx automatically.
What does Microsoft Access Database MCP server do?
It gives language models direct access to .accdb files. Assistants can build forms, modify VBA subroutines, run DAO operations, and check UI control layouts.
Why does this MCP server require Windows?
The server relies on Windows COM automation to communicate with the local Microsoft Access application. Because of this, it cannot operate on macOS or Linux.
