MS Access MCP Explorer

@sub-arjun

About MS Access MCP Explorer

MCP Server for microsoft access databases

#ms-access #database-explorer #mcp-server

Basic information

Category

Other

License

MIT license

Runtime

python

Transports

stdio

Publisher

sub-arjun

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "ms-access-mcp": {
      "command": "uvx",
      "args": [
        "omni-ms-access-mcp",
        "--db-path",
        "C:\\path\\to\\your\\database.accdb"
      ]
    }
  }
}

Tools

2

`get_schema_tool(format="json")`

`query_data(sql="SELECT * FROM Users LIMIT 10")`

Overview

What is MS Access MCP Explorer?

A tool for exploring and querying Microsoft Access databases using the Model-Command-Procedure (MCP) protocol. It provides a programmatic interface for retrieving schema information and executing SQL queries against .accdb or .mdb files.

How to use MS Access MCP Explorer?

Install with pip install omni-ms-access-mcp or uv pip install omni-ms-access-mcp. Start the MCP server from the command line: ms-access-mcp --db-path "C:\path\to\database.accdb". Alternatively, use the Python API by importing AccessMCP from omni_ms_access_mcp.server.

Key features of MS Access MCP Explorer

Retrieve database schema as text or JSON
Execute arbitrary SQL queries against the database
Simple command-line and Python API interfaces
Requires Microsoft Access Driver on the system
Supports Python 3.7 or higher

Use cases of MS Access MCP Explorer

Programmatically inspect table structures in legacy Access databases
Extract data from Access databases for migration or analysis
Integrate Access database queries into automation pipelines
Debug or validate SQL queries against an Access backend

FAQ from MS Access MCP Explorer

What runtime dependencies are required?

Microsoft Access Driver must be installed on your system, and Python 3.7 or higher is needed.

How do I run the server?

Use the command ms-access-mcp --db-path "path\to\database.accdb" or the Python API mcp_server = AccessMCP(db_path="...") then mcp_server.run().

What tools are available?

Two tools: get_schema_tool (optional format parameter: "text" or "json") and query_data (required sql parameter).

Can I connect to both .accdb and .mdb files?

The README only mentions .accdb in examples; compatibility with .mdb is not stated.

Does the server support authentication or network transport?

The README does not describe authentication, network transports, or cloud connectivity. It assumes local file access via the Microsoft Access Driver.

Comments

More Other MCP servers

Maestro

Painless E2E Automation for Mobile and Web

MCP Toolbox for Databases

MCP Toolbox for Databases is an open source MCP server for databases.

Blender

Open-source MCP to use Blender with any LLM

MCP Registry

modelcontextprotocol

A community driven registry service for Model Context Protocol (MCP) servers.

Mcp

Browser MCP is a Model Context Provider (MCP) server that allows AI applications to control your browser