Microsoft Access Database

Microsoft Access Database is an MCP server that enables AI assistants to interact directly with Microsoft Access and SQLite 3 database files. It connects large language model interfaces to legacy or local desktop databases, including .mdb, .accdb, .db, .sqlite, and .sqlite3 formats, as well as temporary in-memory SQLite instances. Data analysts, administrators, and software engineers use this server to inspect legacy schemas, execute custom SQL retrieval and update queries, and transfer data between database tables and external files. The server provides dedicated tools for importing information from CSV and Excel spreadsheets, exporting table datasets to CSV formats, and writing persistent notes alongside files for future retrieval. Operating with read and write capabilities, it allows hosts to modify data directly, create fresh database files from templates, or establish read-only connections to prevent unintended modifications during exploratory tasks.

Category: Databases & Data Stores

Tags: csv, database, data-management, microsoft access

Visit Microsoft Access Database

How to install and configure Microsoft Access Database

1. Clone the repository from GitHub: git clone https://github.com/scanzy/mcp-server-access-mdb. 2. Ensure you have uv installed on your machine. 3. Open your MCP client configuration file (such as Claude Desktop's config.json). 4. Add the server entry under the mcpServers block: json { "mcpServers": { "access-mdb": { "command": "uv", "args": [ "run", "--with", "fastmcp", "--with", "pandas", "--with", "sqlalchemy-access", "--with", "openpyxl", "fastmcp", "run", "path/to/repo/server.py" ] } } } 5. Replace path/to/repo/server.py with the absolute path to server.py in your cloned repository. 6. Restart your MCP client to initialize the server tools.

What you can do with Microsoft Access Database

• Running exploratory SQL SELECT queries to inspect tables and relationships in legacy Microsoft Access .mdb or .accdb database files. - Updating, inserting, or deleting rows in an active SQLite or Access database through conversational language prompts. - Ingesting structured datasets by importing rows from CSV or Excel spreadsheet files directly into target database tables. - Exporting specific database table records into standard CSV files for reporting, sharing, or external data pipeline workflows. - Creating, reading, and storing contextual documentation notes attached directly to specific database files on disk.

Key facts

• https://github.com/scanzy/mcp-server-access-mdb
• Databases & Data Stores, Files, Documents & PDFs
• csv, database, data-management, microsoft access

Part of MCP Servers

What can Microsoft Access Database MCP server do?

This server allows AI assistants to connect to, inspect, and manage Microsoft Access and SQLite databases. It can run SQL read queries, execute update or insert statements, list active connections, create new databases, import data from CSV and Excel files, export tables to CSV, and persist contextual file notes.

Which file formats does this server support?

The server automatically detects Microsoft Access files ending in .mdb and .accdb, as well as SQLite files ending in .db, .sqlite, and .sqlite3. It also supports in-memory SQLite databases and allows overriding the driver explicitly when handling non-standard file extensions.

Can I connect to databases in read-only mode?

Yes. When calling the connect tool, you can set the readOnly parameter to true to open file-based databases in read-only mode, protecting your data from unintended updates. Note that read-only mode is not supported for in-memory SQLite databases.

Is Microsoft Access Database MCP open source?

Yes, Microsoft Access Database MCP is open-source software distributed under the MIT license on GitHub.