{"slug":"scanzy/mcp-server-access-mdb","name":"Microsoft Access Database","description":"Allows AI to interact with Microsoft Access databases, supporting data import and export via CSV files.","category":"database","tags":[],"official":false,"stars":8,"transport":null,"install":null,"tools":[{"name":"list","description":"List all active databases available in the server."},{"name":"create","description":"Create a new database file (for Microsoft Access, copies the empty.mdb template)."},{"name":"connect","description":"Connect to an existing database file, or creates an in-memory database if the file is not specified."},{"name":"disconnect","description":"Close a database connection. For in-memory databases, this will clear all its data."},{"name":"query","description":"Execute a SQL query to retrieve data from a database."},{"name":"update","description":"Execute a SQL query to insert/update/delete data in a database."},{"name":"import_csv","description":"Imports data from a CSV file into a database table."},{"name":"export_csv","description":"Exports data from a database table to a CSV file."},{"name":"import_excel","description":"Imports data from an Excel file into a database table."},{"name":"read_notes","description":"Reads notes from the specified file, or discovers notes in the specified directory."},{"name":"write_notes","description":"Writes notes to the specified file, or linked to the specified database."}],"env_vars":[],"auth_type":"none","github":"https://github.com/scanzy/mcp-server-access-mdb","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Thu May 28"}