{"slug":"unmateria/mcp-access","name":"mcp-msaccess","description":"Give any AI assistant full control over Microsoft Access databases.","category":"database","tags":[],"official":false,"stars":31,"transport":"stdio","install":[{"cmd":"pip install mcp","imports":[]}],"tools":[{"name":"list_databases","description":"List all Microsoft Access databases in a specified directory"},{"name":"list_tables","description":"List all tables in a specified Microsoft Access database"},{"name":"describe_table","description":"Describe the schema of a specified table in a Microsoft Access database"},{"name":"query","description":"Execute a SQL query against a Microsoft Access database"},{"name":"execute_non_query","description":"Execute a non-query SQL statement (INSERT, UPDATE, DELETE) against a Microsoft Access database"},{"name":"create_table","description":"Create a new table in a Microsoft Access database"},{"name":"drop_table","description":"Drop a table from a Microsoft Access database"},{"name":"add_column","description":"Add a new column to an existing table in a Microsoft Access database"},{"name":"drop_column","description":"Drop a column from an existing table in a Microsoft Access database"},{"name":"rename_table","description":"Rename a table in a Microsoft Access database"},{"name":"rename_column","description":"Rename a column in a table in a Microsoft Access database"},{"name":"create_index","description":"Create an index on a table in a Microsoft Access database"},{"name":"drop_index","description":"Drop an index from a table in a Microsoft Access database"},{"name":"list_views","description":"List all views in a specified Microsoft Access database"},{"name":"create_view","description":"Create a new view in a Microsoft Access database"},{"name":"drop_view","description":"Drop a view from a Microsoft Access database"},{"name":"list_queries","description":"List all saved queries in a specified Microsoft Access database"},{"name":"list_macros","description":"List all macros in a specified Microsoft Access database"},{"name":"list_modules","description":"List all VBA modules in a specified Microsoft Access database"},{"name":"list_forms","description":"List all forms in a specified Microsoft Access database"},{"name":"list_reports","description":"List all reports in a specified Microsoft Access database"},{"name":"list_relationships","description":"List all relationships in a specified Microsoft Access database"},{"name":"get_table_row_count","description":"Get the row count of a specified table in a Microsoft Access database"},{"name":"get_database_info","description":"Get general information about a Microsoft Access database"},{"name":"compact_database","description":"Compact and repair a Microsoft Access database"},{"name":"export_table_to_csv","description":"Export a table from a Microsoft Access database to a CSV file"},{"name":"import_csv_to_table","description":"Import data from a CSV file into a table in a Microsoft Access database"},{"name":"backup_database","description":"Create a backup copy of a Microsoft Access database"},{"name":"list_linked_tables","description":"List all linked tables in a Microsoft Access database"},{"name":"refresh_linked_tables","description":"Refresh all linked tables in a Microsoft Access database"},{"name":"get_table_data","description":"Retrieve data from a table with optional filtering, sorting, and pagination"},{"name":"insert_record","description":"Insert a new record into a table"},{"name":"update_record","description":"Update records in a table based on a condition"},{"name":"delete_record","description":"Delete records from a table based on a condition"},{"name":"find_duplicates","description":"Find duplicate values in specified columns of a table"},{"name":"get_table_size","description":"Get the estimated size of a table in a Microsoft Access database"},{"name":"list_stored_procedures","description":"List all stored procedures in a Microsoft Access database"},{"name":"execute_stored_procedure","description":"Execute a stored procedure in a Microsoft Access database"},{"name":"get_schema","description":"Get the full schema of a Microsoft Access database including tables, views, relationships, and indexes"},{"name":"search_tables","description":"Search for tables by name pattern in a Microsoft Access database"},{"name":"search_columns","description":"Search for columns by name pattern across all tables in a Microsoft Access database"},{"name":"analyze_table","description":"Analyze a table and provide statistics including row count, column types, null counts, and distinct values"},{"name":"get_table_dependencies","description":"Get dependencies for a specified table in a Microsoft Access database"},{"name":"get_object_dependencies","description":"Get dependencies for any object (table, query, form, report, macro, module) in a Microsoft Access database"},{"name":"list_all_objects","description":"List all objects in a Microsoft Access database including tables, queries, forms, reports, macros, and modules"},{"name":"get_object_properties","description":"Get properties of a specified object in a Microsoft Access database"},{"name":"run_saved_query","description":"Run a saved query in a Microsoft Access database and return results"},{"name":"get_query_sql","description":"Get the SQL definition of a saved query in a Microsoft Access database"},{"name":"get_macro_details","description":"Get details of a specified macro in a Microsoft Access database"},{"name":"get_module_code","description":"Get the VBA code of a specified module in a Microsoft Access database"},{"name":"get_form_details","description":"Get details of a specified form in a Microsoft Access database"},{"name":"get_report_details","description":"Get details of a specified report in a Microsoft Access database"},{"name":"export_schema_to_sql","description":"Export the schema of a Microsoft Access database as SQL CREATE statements"},{"name":"compare_databases","description":"Compare two Microsoft Access databases and list differences in schema and data"},{"name":"get_database_properties","description":"Get extended properties of a Microsoft Access database"},{"name":"set_database_property","description":"Set a property of a Microsoft Access database"},{"name":"list_database_users","description":"List current users of a shared Microsoft Access database"},{"name":"get_table_permissions","description":"Get permissions for a specified table in a Microsoft Access database"},{"name":"set_table_permissions","description":"Set permissions for a specified table in a Microsoft Access database"},{"name":"encrypt_database","description":"Encrypt a Microsoft Access database with a password"},{"name":"decrypt_database","description":"Decrypt a password-protected Microsoft Access database"}],"env_vars":[],"auth_type":"none","github":"https://github.com/unmateria/MCP-Access","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Mon May 25"}