# Microsoft Access Database

Connects AI coding assistants to Microsoft Access files. Enables automated form design, DAO table creation, SQL execution, and live VBA editing.

- MCP server · `type=mcp` · Claude Code, Codex, Cursor, GitHub Copilot, Windsurf (Devin Desktop), Cline, Zed, Gemini CLI · ★ 58
- Author: unmateria
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/unmateria/MCP-Access
- Updated: 2026-10-10
- HTML: https://affpapa.org/en/nevibecode/mcp/microsoft-access-database

## What it 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.

## Requirements
- Needs: Python and uv (commands run via uvx)

## Install

### Claude Code (native platform)

**Platform CLI**
```bash
claude mcp add msaccess-database -- uvx mcp-msaccess-database
```
uvx runs the command named after the package; if the README names another one, use uvx --from mcp-msaccess-database <command>

### Codex

**Platform CLI**
```bash
codex mcp add microsoft-access-database -- uvx mcp-msaccess-database
```
uvx runs the command named after the package; if the README names another one, use uvx --from mcp-msaccess-database <command>

### Cursor

**Config file**
File `.cursor/mcp.json`:
```json
{
    "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>

### GitHub Copilot

**Config file**
File `.vscode/mcp.json`:
```json
{
    "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>

### Gemini CLI

**Platform CLI**
```bash
gemini mcp add microsoft-access-database uvx mcp-msaccess-database
```
uvx runs the command named after the package; if the README names another one, use uvx --from mcp-msaccess-database <command>

## When to use it
- 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
- 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

## Similar
- [World Monitor](https://affpapa.org/en/nevibecode/mcp/world-monitor.md) — MCP server · ★ 89408
- [Scrapling MCP Server](https://affpapa.org/en/nevibecode/mcp/scrapling-mcp-server.md) — MCP server · ★ 89433
- [MCP Toolbox for Databases](https://affpapa.org/en/nevibecode/mcp/googleapis-mcp-toolbox-for-databases.md) — MCP server · ★ 16717
- [PostHog MCP Server](https://affpapa.org/en/nevibecode/mcp/posthog-mcp-server.md) — MCP server · ★ 40409
- [dbx](https://affpapa.org/en/nevibecode/mcp/dbx.md) — MCP server · ★ 27669
- [Metabase](https://affpapa.org/en/nevibecode/mcp/metabase.md) — MCP server · ★ 49845

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md