Microsoft Access Database MCP server

Read from the package source without running it. The installed server may list more.

• access_close

  Closes the COM session and releases the .accdb/.mdb file.

• access_compact_repair

  Compacts and repairs the database. Closes, compacts to temp, replaces original and reopens. Returns sizes.

• access_compile_vba

  Compiles and saves all VBA modules. A dialog watchdog always runs and dismisses any error MsgBox; the watchdog is given `timeout` seconds (default 2) of grace after the compile call returns before being stopped.

• access_create_databasewrite action

  Creates an empty Access database (.accdb). Error if the file already exists.

• access_create_relationshipwrite action

  Creates a relationship between two tables. attributes: 256=cascade update, 4096=cascade delete (combinable with OR).

• access_delete_controlwrite action

  Deletes a control from a form/report via COM.

• access_delete_objectwrite action

  Deletes an Access object (module, form, report, query, macro). Requires confirm=true.

• access_eval_vba

  Evaluates a VBA/Access expression via Application.Eval. Works with: domain functions (DLookup, DCount...), built-in VBA functions (Date(), Len()...), form properties of OPEN forms (Forms!frmX.Prop), public functions in standard modules. Does NOT work with: class instances (even default/predeclared), variables, Subs. For class instances use access_run_vba with a wrapper function, or this tool will

• access_export_text

  Exports form/report/module as text (SaveAsText). Does NOT open in Design view — does not recalculate positions. File is UTF-16 LE.

• access_get_control

  Full definition (Begin...End) of a control by name.

• access_get_db_property

  Reads a database property (CurrentDb.Properties) or Access option (GetOption).

• access_get_field_properties

  Reads all properties of a field: DefaultValue, ValidationRule, Description, Format, etc.

• access_import_text

  Imports form/report/module from text (LoadFromText). REPLACES if exists. Does NOT open in Design view — does not recalculate positions. For forms/reports with CodeBehindForm: separates VBA automatically and injects via VBE (same as access_set_code).

• access_list_controls

  Lists controls of a form/report with name, type, caption, control_source, position.

• access_list_indexes

  Lists indexes of a table: name, fields, primary, unique, foreign.

• access_list_objects

  Lists database objects by type (table, module, form, report, query, macro, all). System tables (MSys*, ~*) are filtered out. Macros are fully supported as a regular object_type — combine with access_get_code / access_set_code / access_run_macro for end-to-end macro workflows.

• access_list_references

  Lists VBA references: name, GUID, path, is_broken, built_in.

• access_list_relationships

  Lists relationships between tables: name, tables, fields, cascade flags.

• access_list_startup_options

  Lists the 14 common startup options with their current values.

• access_manage_indexwrite action

  Creates or deletes an index. create requires fields [{name, order?}]. primary/unique optional.

• access_manage_reference

  Adds (add) or removes (remove) a VBA reference. add: requires guid or path. remove: requires name.

• access_run_macrowrite action

  Executes an Access macro by name.

• access_run_vbawrite action

  Executes a VBA Sub/Function. Supports 3 syntaxes: 'Module.MySub' (standard module via Application.Run), 'MySub' (same), 'Forms.FormName.Method' (form module via COM — form must be open). Returns result if Function. With timeout, automatically dismisses MsgBox/InputBox if exceeded.

• access_screenshot

  Captures the Access window as PNG. Optionally opens a form/report before capturing. Returns path, dimensions and metadata. wait_ms pumps Windows messages (Timer events, ActiveX init).

• access_search_queries

  Searches for text or regex in the SQL of ALL queries. Returns [{query_name, sql}].

• access_set_control_props

  Modifies properties of a control via COM. Numeric/boolean values are converted automatically.

• access_set_db_property

  Sets a database property or Access option. Creates the property if it does not exist.

• access_set_field_property

  Sets a field property. Creates the property if it does not exist.

• access_set_form_property

  Sets form/report-level properties (RecordSource, Caption, DefaultView, HasModule, etc.) via COM in Design view.

• access_table_info

  Table structure via DAO: fields, types, size, required, record_count, is_linked.

• access_tips

  Tips and gotchas for working with Access via MCP. Topics: eval, controls, gotchas, sql, vbe, compile, design_vbe, macros, lint, layout, design, subform_tabcontrol. Without topic returns the list.

• access_ui_click

  Click at image coordinates on the Access window. Coordinates are relative to a previous screenshot (image_width required for scaling).

• access_ui_type

  Types text or sends keyboard shortcuts to the Access window. Use 'text' for normal text, 'key' for special keys (enter, tab, escape, f1-f12, etc.), 'modifiers' for combinations (ctrl, shift, alt).

• access_vbe_append

  Appends code to the end of a VBA module.

• access_vbe_get_lines

  Reads a range of lines from a VBA module via VBE COM. Provide either count or end_line (not both).

• access_vbe_search_all

  Searches for text or regex in ALL VBA modules (modules, forms, reports) in the database.

• Code scan26 source files scanned25/25
• –Live reliabilityno gateway calls yet and no remote to proben/a
• –Tool poisoningtools not inspected (local package is not executed); not countedn/a
• Auth qualitylocal package, no credentials required12/15
• Maintenancelast push 13 days ago15/15
• Maintainer identityregistry namespace matches repository owner; GitHub account older than a year8/10

Microsoft Access Database: common questions

Is Microsoft Access Database MCP server safe?

Yes, by our scan: it is graded A (92/100). Read the Microsoft Access Database safety report

How do I install Microsoft Access Database?

It runs on your machine. Copy the Claude Code, Claude Desktop or Cursor config from the install section.

Does Microsoft Access Database need an API key?

Not as far as the registry entry and our scan can tell: no credentials are declared or required.

Is Microsoft Access Database maintained?

The last commit was 14 days ago (2026-09-06). The latest release is v0.7.59.

What can I use instead of Microsoft Access Database?

Servers from other publishers that do the same job: CADBridge MCP Server for AutoCAD, DBHub MCP server and MCP Toolbox for Databases MCP server. Compare all Microsoft Access Database alternatives.