mcp-msaccess

Tools · 61

• list_databases List all Microsoft Access databases in a specified directory
• list_tables List all tables in a specified Microsoft Access database
• describe_table Describe the schema of a specified table in a Microsoft Access database
• query Execute a SQL query against a Microsoft Access database
• execute_non_query Execute a non-query SQL statement (INSERT, UPDATE, DELETE) against a Microsoft Access database
• create_table Create a new table in a Microsoft Access database
• drop_table Drop a table from a Microsoft Access database
• add_column Add a new column to an existing table in a Microsoft Access database
• drop_column Drop a column from an existing table in a Microsoft Access database
• rename_table Rename a table in a Microsoft Access database
• rename_column Rename a column in a table in a Microsoft Access database
• create_index Create an index on a table in a Microsoft Access database
• drop_index Drop an index from a table in a Microsoft Access database
• list_views List all views in a specified Microsoft Access database
• create_view Create a new view in a Microsoft Access database
• drop_view Drop a view from a Microsoft Access database
• list_queries List all saved queries in a specified Microsoft Access database
• list_macros List all macros in a specified Microsoft Access database
• list_modules List all VBA modules in a specified Microsoft Access database
• list_forms List all forms in a specified Microsoft Access database
• list_reports List all reports in a specified Microsoft Access database
• list_relationships List all relationships in a specified Microsoft Access database
• get_table_row_count Get the row count of a specified table in a Microsoft Access database
• get_database_info Get general information about a Microsoft Access database
• compact_database Compact and repair a Microsoft Access database
• export_table_to_csv Export a table from a Microsoft Access database to a CSV file
• import_csv_to_table Import data from a CSV file into a table in a Microsoft Access database
• backup_database Create a backup copy of a Microsoft Access database
• list_linked_tables List all linked tables in a Microsoft Access database
• refresh_linked_tables Refresh all linked tables in a Microsoft Access database
• get_table_data Retrieve data from a table with optional filtering, sorting, and pagination
• insert_record Insert a new record into a table
• update_record Update records in a table based on a condition
• delete_record Delete records from a table based on a condition
• find_duplicates Find duplicate values in specified columns of a table
• get_table_size Get the estimated size of a table in a Microsoft Access database
• list_stored_procedures List all stored procedures in a Microsoft Access database
• execute_stored_procedure Execute a stored procedure in a Microsoft Access database
• get_schema Get the full schema of a Microsoft Access database including tables, views, relationships, and indexes
• search_tables Search for tables by name pattern in a Microsoft Access database
• search_columns Search for columns by name pattern across all tables in a Microsoft Access database
• analyze_table Analyze a table and provide statistics including row count, column types, null counts, and distinct values
• get_table_dependencies Get dependencies for a specified table in a Microsoft Access database
• get_object_dependencies Get dependencies for any object (table, query, form, report, macro, module) in a Microsoft Access database
• list_all_objects List all objects in a Microsoft Access database including tables, queries, forms, reports, macros, and modules
• get_object_properties Get properties of a specified object in a Microsoft Access database
• run_saved_query Run a saved query in a Microsoft Access database and return results
• get_query_sql Get the SQL definition of a saved query in a Microsoft Access database
• get_macro_details Get details of a specified macro in a Microsoft Access database
• get_module_code Get the VBA code of a specified module in a Microsoft Access database
• get_form_details Get details of a specified form in a Microsoft Access database
• get_report_details Get details of a specified report in a Microsoft Access database
• export_schema_to_sql Export the schema of a Microsoft Access database as SQL CREATE statements
• compare_databases Compare two Microsoft Access databases and list differences in schema and data
• get_database_properties Get extended properties of a Microsoft Access database
• set_database_property Set a property of a Microsoft Access database
• list_database_users List current users of a shared Microsoft Access database
• get_table_permissions Get permissions for a specified table in a Microsoft Access database
• set_table_permissions Set permissions for a specified table in a Microsoft Access database
• encrypt_database Encrypt a Microsoft Access database with a password
• decrypt_database Decrypt a password-protected Microsoft Access database