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