Microsoft Access
MCP server to let AI read and update Microsoft Access Databases (.mdb files)
What is Microsoft Access?
Microsoft Access is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to mcp server to let ai read and update microsoft access databases (.mdb files)
MCP server to let AI read and update Microsoft Access Databases (.mdb files)
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- MCP server to let AI read and update Microsoft Access Databa
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx access-mdbConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Microsoft Access
mcp-server-access-mdb is an MCP server that enables AI assistants to read and write Microsoft Access databases (.mdb and .accdb files) as well as SQLite databases. Built with FastMCP and SQLAlchemy-Access, it supports SQL queries, CSV/Excel import and export, and note-taking linked to database files, making it practical for legacy data migration and Access database automation.
Prerequisites
- Python 3.10+ with pip installed
- uv package manager (pip install uv) for running the server via FastMCP
- Microsoft Access ODBC driver installed on Windows (required for .mdb/.accdb files)
- Git to clone the repository
- Claude Desktop or another MCP-compatible client
Clone the repository
Clone the mcp-server-access-mdb repository to a local directory.
git clone https://github.com/scanzy/mcp-server-access-mdb.git
cd mcp-server-access-mdbInstall required dependencies
The server uses fastmcp, pandas, sqlalchemy-access, and openpyxl. Install them using pip or let uv handle it at runtime via the --with flags.
pip install fastmcp pandas sqlalchemy-access openpyxlConfigure Claude Desktop
Edit your Claude Desktop config file to add the access-mdb server. The uv run command with --with flags handles dependency installation automatically.
{
"mcpServers": {
"access-mdb": {
"command": "uv",
"args": [
"run",
"--with", "fastmcp",
"--with", "pandas",
"--with", "sqlalchemy-access",
"--with", "openpyxl",
"fastmcp", "run",
"/absolute/path/to/mcp-server-access-mdb/server.py"
]
}
}
}Restart Claude Desktop
Close and reopen Claude Desktop to load the new MCP server. The server will appear in the connected tools list.
# macOS config: ~/Library/Application Support/Claude/claude_desktop_config.json
# Windows config: %APPDATA%\Claude\claude_desktop_config.jsonConnect to an Access database
Ask Claude to connect to an existing .mdb or .accdb file using the connect tool. Use readOnly=true for safe browsing of production databases.
# Ask Claude:
# "Connect to the Access database at C:\\data\\customers.mdb in read-only mode"Query and modify data
Once connected, use the query tool for SELECT statements and the update tool for INSERT, UPDATE, and DELETE operations. You can also import CSV files directly into tables.
# Ask Claude:
# "Show me all tables in the connected database"
# "Query the Customers table and show the first 20 rows"
# "Import the file /tmp/new_orders.csv into the Orders table"Microsoft Access Examples
Client configuration
Claude Desktop configuration that runs the Access MDB server using uv with automatic dependency resolution.
{
"mcpServers": {
"access-mdb": {
"command": "uv",
"args": [
"run",
"--with", "fastmcp",
"--with", "pandas",
"--with", "sqlalchemy-access",
"--with", "openpyxl",
"fastmcp", "run",
"/path/to/mcp-server-access-mdb/server.py"
]
}
}
}Prompts to try
Prompts to work with Microsoft Access and SQLite databases through Claude.
- "Connect to C:\\legacy\\inventory.mdb and list all tables"
- "Query the Products table in the connected Access database and show items with price > 100"
- "Export the Customers table to a CSV file at /tmp/customers_export.csv"
- "Import /tmp/new_products.xlsx into the Products table"
- "Create a new Access database at C:\\data\\new_db.mdb"Troubleshooting Microsoft Access
Cannot connect to .mdb file — ODBC driver not found
On Windows, install the Microsoft Access Database Engine from https://www.microsoft.com/en-us/download/details.aspx?id=54920. The 32-bit and 64-bit versions must match your Python installation bitness. On macOS/Linux, .mdb support is limited; use SQLite mode instead with driver='sqlite'.
uv: command not found when starting the server
Install uv with 'pip install uv' or follow the official installation at https://docs.astral.sh/uv/. Ensure the uv binary is on your system PATH. On Windows, you may need to add %APPDATA%\Python\Scripts to PATH.
Import CSV fails with encoding errors
Ensure your CSV file is saved as UTF-8. If the file uses a different encoding (e.g., Windows-1252 for legacy Access exports), open it in a text editor and resave as UTF-8 before importing. The openpyxl dependency handles Excel files; ensure it is installed.
Frequently Asked Questions about Microsoft Access
What is Microsoft Access?
Microsoft Access is a Model Context Protocol (MCP) server that mcp server to let ai read and update microsoft access databases (.mdb files) It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Microsoft Access?
Follow the installation instructions on the Microsoft Access GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Microsoft Access?
Microsoft Access works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Microsoft Access free to use?
Yes, Microsoft Access is open source and available under the MIT license. You can use it freely in both personal and commercial projects.
Microsoft Access Alternatives — Similar Databases Servers
Looking for alternatives to Microsoft Access? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Microsoft Access in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Microsoft Access?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.