scanzy/mcp-server-access-mdb
If you are the rightful owner of mcp-server-access-mdb and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A simple MCP server to let AI interact with Microsoft Access databases, supporting import/export with CSV and Excel files, and storing human-readable notes about files.
Tools
Functions exposed to the LLM to take actions
list
List all active databases available in the server.
create
Create a new database file by copying the empty.mdb template.
connect
Connect to an existing database file or create an in-memory database.
disconnect
Close a database connection and clear data for in-memory databases.
query
Execute a SQL query to retrieve data from a database.
update
Execute a SQL query to insert/update/delete data in a database.
import_csv
Import data from a CSV file into a database table.
export_csv
Export data from a database table to a CSV file.
import_excel
Import data from an Excel file into a database table.
read_notes
Read notes from the specified file or discover notes in the specified directory.
write_notes
Write notes to the specified file or link them to the specified database.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client