{"name":"io.github.unmateria/msaccess-database","slug":"unmateria-msaccess-database","title":"Microsoft Access Database","description":"Read and edit Microsoft Access databases (.accdb/.mdb) - forms, VBA, tables, queries. Windows.","url":"https://mcp.market/server/unmateria-msaccess-database","rating":null,"grade":"A","score":92,"certified":false,"status":"active","category":"data","tags":["data"],"presence":{"score":32,"stars":54,"forks":11,"downloads_week":null,"last_push_at":"2026-09-06T18:06:01.000Z","license":"MIT"},"uptime":null,"claimed":false,"transport":"pypi","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/unmateria/MCP-Access","website":null,"version":"0.7.59","remotes":[],"packages":[{"registryType":"pypi","identifier":"mcp-msaccess-database","version":"0.7.59","transport":{"type":"stdio"}}],"tools":[{"name":"access_close","description":"Closes the COM session and releases the .accdb/.mdb file.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_compact_repair","description":"Compacts and repairs the database. Closes, compacts to temp, replaces original and reopens. Returns sizes.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_compile_vba","description":"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.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_create_database","description":"Creates an empty Access database (.accdb). Error if the file already exists.","write_action":true,"price_micros":0,"input_schema":null},{"name":"access_create_relationship","description":"Creates a relationship between two tables. attributes: 256=cascade update, 4096=cascade delete (combinable with OR).","write_action":true,"price_micros":0,"input_schema":null},{"name":"access_delete_control","description":"Deletes a control from a form/report via COM.","write_action":true,"price_micros":0,"input_schema":null},{"name":"access_delete_object","description":"Deletes an Access object (module, form, report, query, macro). Requires confirm=true.","write_action":true,"price_micros":0,"input_schema":null},{"name":"access_eval_vba","description":"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 ","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_export_text","description":"Exports form/report/module as text (SaveAsText). Does NOT open in Design view — does not recalculate positions. File is UTF-16 LE.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_get_control","description":"Full definition (Begin...End) of a control by name.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_get_db_property","description":"Reads a database property (CurrentDb.Properties) or Access option (GetOption).","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_get_field_properties","description":"Reads all properties of a field: DefaultValue, ValidationRule, Description, Format, etc.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_import_text","description":"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).","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_list_controls","description":"Lists controls of a form/report with name, type, caption, control_source, position.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_list_indexes","description":"Lists indexes of a table: name, fields, primary, unique, foreign.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_list_objects","description":"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.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_list_references","description":"Lists VBA references: name, GUID, path, is_broken, built_in.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_list_relationships","description":"Lists relationships between tables: name, tables, fields, cascade flags.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_list_startup_options","description":"Lists the 14 common startup options with their current values.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_manage_index","description":"Creates or deletes an index. create requires fields [{name, order?}]. primary/unique optional.","write_action":true,"price_micros":0,"input_schema":null},{"name":"access_manage_reference","description":"Adds (add) or removes (remove) a VBA reference. add: requires guid or path. remove: requires name.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_run_macro","description":"Executes an Access macro by name.","write_action":true,"price_micros":0,"input_schema":null},{"name":"access_run_vba","description":"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.","write_action":true,"price_micros":0,"input_schema":null},{"name":"access_screenshot","description":"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).","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_search_queries","description":"Searches for text or regex in the SQL of ALL queries. Returns [{query_name, sql}].","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_set_control_props","description":"Modifies properties of a control via COM. Numeric/boolean values are converted automatically.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_set_db_property","description":"Sets a database property or Access option. Creates the property if it does not exist.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_set_field_property","description":"Sets a field property. Creates the property if it does not exist.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_set_form_property","description":"Sets form/report-level properties (RecordSource, Caption, DefaultView, HasModule, etc.) via COM in Design view.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_table_info","description":"Table structure via DAO: fields, types, size, required, record_count, is_linked.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_tips","description":"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.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_ui_click","description":"Click at image coordinates on the Access window. Coordinates are relative to a previous screenshot (image_width required for scaling).","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_ui_type","description":"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).","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_vbe_append","description":"Appends code to the end of a VBA module.","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_vbe_get_lines","description":"Reads a range of lines from a VBA module via VBE COM. Provide either count or end_line (not both).","write_action":false,"price_micros":0,"input_schema":null},{"name":"access_vbe_search_all","description":"Searches for text or regex in ALL VBA modules (modules, forms, reports) in the database.","write_action":false,"price_micros":0,"input_schema":null}],"scan":{"score":92,"grade":"A","scanned_at":"2026-09-20T05:05:46.657Z","report":{"scannerVersion":"0.1.9","scannedAt":"2026-09-20T05:05:46.573Z","components":{"code":{"score":25,"max":25,"notes":["26 source files scanned"]},"reliability":{"score":-1,"max":20,"notes":["no gateway calls yet and no remote to probe"]},"poisoning":{"score":-1,"max":15,"notes":["tools not inspected (local package is not executed); not counted"]},"auth":{"score":12,"max":15,"notes":["local package, no credentials required"]},"maintenance":{"score":15,"max":15,"notes":["last push 13 days ago"]},"identity":{"score":8,"max":10,"notes":["registry namespace matches repository owner","GitHub account older than a year"]}},"findings":[],"inputs":{"packages":[{"registryType":"pypi","identifier":"mcp-msaccess-database","version":"0.7.59","found":true,"license":"MIT","dependencyCount":3,"publishedAt":"2026-09-06T18:06:20.528577Z","repositoryUrl":"https://github.com/unmateria/MCP-Access"}],"repo":{"found":true,"owner":"unmateria","repo":"MCP-Access","archived":false,"pushedAt":"2026-09-06T18:06:01Z","stars":54,"forks":11,"openIssues":0,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/40733899?v=4","ownerCreatedAt":"2018-07-01T10:18:30Z"},"icon":{"url":null,"source":"none"},"presence":{"stars":54,"forks":11,"downloadsWeek":null,"license":"MIT","lastPushAt":"2026-09-06T18:06:01.000Z","score":32}}}},"grade_history":[],"reviews":[]}