Msaccess Database

Name: Msaccess Database
Author: unmateria

by unmateriacommunityv0.7.46

An MCP server for automating Microsoft Access databases through COM on Windows. It can create and edit databases, forms, reports, tables, queries, VBA code, relationships, indexes, linked tables, and run Access macros/VBA.

From the registry: Read and edit Microsoft Access databases (.accdb/.mdb) - forms, VBA, tables, queries. Windows.

GitHub Repository

Install & configure

Prerequisites

required
Windows
Microsoft Access COM automation is Windows-only.
required
Microsoft Access installed
Install Microsoft Access (any version that supports VBE, 2010+).
required
Python 3.9+
Python 3.9 or newer is required to run the server script.
required
Install Python dependencies
Install the required Python packages.
```
$ pip install mcp pywin32
```
required
Enable VBA project object model access
In Access Trust Center, enable 'Trust access to the VBA project object model'. The README also provides an optional PowerShell script to do this.
```
$ .\enable_vba_trust.ps1
```

Install in your client

Paste into the AI you're chatting with — it will figure out the rest

Please install the `msaccess-database` MCP server into my current AI client (that's you).

Required prerequisites (do these first if not already done):
- **Windows** — Microsoft Access COM automation is Windows-only.
- **Microsoft Access installed** — Install Microsoft Access (any version that supports VBE, 2010+).
- **Python 3.9+** — Python 3.9 or newer is required to run the server script.
- **Install Python dependencies** — Install the required Python packages. Run: `pip install mcp pywin32`
- **Enable VBA project object model access** — In Access Trust Center, enable 'Trust access to the VBA project object model'. The README also provides an optional PowerShell script to do this. Run: `.\enable_vba_trust.ps1`

Canonical MCP server config (stdio transport):
- command: `python`
- args: ["<path-to-access_mcp_server.py>"]

Note: The README only documents running the server via a local Python script. Replace <path-to-access_mcp_server.py> with the path to the server file on your machine. No environment variables are documented.

Add this MCP server to my current client's config in the correct format for you. If you need secrets or credentials I haven't provided, ASK me — do not invent values or leave raw placeholders. After adding it, tell me how to verify the server is connected.

Note: The README only documents running the server via a local Python script. Replace <path-to-access_mcp_server.py> with the path to the server file on your machine. No environment variables are documented.

Tools (54)

access_create_database

Create a new empty .accdb database file

access_close

Close the COM session and release the .accdb file

access_list_objects

List objects by type (table, module, form, report, query, macro, all) with system tables filtered

access_get_code

Export an object's full definition as text

access_set_code

Import modified text back (creates or overwrites)

access_export_structure

Generate a Markdown index of all modules, forms, reports, queries

access_delete_object

Delete a module, form, report, query, or macro with confirmation

access_create_form

Create a new form without triggering the Save As dialog, with optional header/footer and record source

access_execute_sql

Run SQL via DAO; SELECT returns rows as JSON

access_execute_batch

Execute multiple SQL statements in one call with per-statement results

access_table_info

Show table structure via DAO

access_search_queries

Search text in the SQL of all queries

access_create_table

Prerequisites

• Python 3.9+

Packages

mcp-msaccess-database

pypiv0.7.46transport: stdio

Details

Language: Python
Released: Jun 19, 2026
Last commit: Jun 19, 2026
Registry name: io.github.unmateria/msaccess-database

Related Servers

Genai Toolbox

MCP Toolbox for Databases enables your agent to connect to your database.

16.0k

Mcp Toolbox

MCP Toolbox for Databases enables your agent to connect to your database.

16.0k

DBHub

Minimal, token-efficient Database MCP Server for PostgreSQL, MySQL, SQL Server, SQLite, MariaDB

3.2k

Create a table via DAO with field types, defaults, descriptions, and primary key support

access_alter_table

Modify table structure via DAO by adding, deleting, or renaming fields

access_vbe_get_lines

Read a line range from a VBA module

access_vbe_get_proc

Get a procedure's code and position by name

access_vbe_module_info

List all procedures with their line numbers

access_vbe_replace_lines

Replace, insert, or delete lines in a VBA module directly via VBE

access_vbe_find

Search text in one specific module

access_vbe_search_all

Search text across all modules, forms, and reports in the database

access_vbe_replace_proc

Replace a full procedure by name

access_vbe_patch_proc

Perform find/replace within a procedure

access_vbe_append

Append code at the end of a module

access_list_controls

List all controls of a form or report with key properties

access_get_control

Get the full definition block of a specific control

access_create_control

Create a new control via COM in design view

access_delete_control

Delete a control via COM

access_set_control_props

Modify control properties via COM in design view

access_set_multiple_controls

Modify properties of multiple controls in a single design-view session

access_lint_form

Check forms for broken layout issues such as contrast, overlap, out-of-bounds, truncation, and zero-size/invisible controls

access_export_text

Export form, report, or module as text via SaveAsText

access_import_text

Import form, report, or module from text via LoadFromText

access_get_db_property

Read a database property or Access option

access_set_db_property

Set a database property or Access option

access_get_form_property

Read form or report properties

access_set_form_property

Set form or report properties via COM in Design view

access_list_linked_tables

List all linked tables with source table, connection string, and ODBC flag

access_relink_table

Change a linked table connection string and refresh the link

access_list_relationships

List table relationships with field mappings and cascade flags

access_create_relationship

Create a relationship between two tables

access_delete_relationship

Delete a relationship by name

access_list_references

List VBA project references with GUID, path, and broken/built-in status

access_manage_reference

Add or remove a VBA reference

access_compact_repair

Compact and repair the database

access_decompile_compact

Remove orphaned VBA p-code, recompile, and compact the database

access_manage_query

Create, modify, delete, rename, or read the SQL of a QueryDef

access_list_indexes

List indexes of a table

access_manage_index

Create or delete an index

access_compile_vba

Compile and save all VBA modules

access_run_macro

Execute an Access macro by name

access_run_vba

Execute a VBA Sub or Function

access_eval_vba

Evaluate a VBA expression via Application.Eval

access_output_report

Export a report to PDF, XLSX, RTF, or TXT

access_transfer_data

Import or export data

MCP server for interacting with the Supabase platform

Msaccess Database

Install & configure

Prerequisites

Install in your client

Tools (54)

Prerequisites

Packages

Details

Categories

Related Servers