Advertise
MCP.so
Sign In

MS Access MCP Explorer

@sub-arjun

Repository

Basic information

Category

Other

License

MIT license

Transports

stdio

Author

sub-arjun

About MS Access MCP Explorer

MCP Server for microsoft access databases

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

MS Access MCP Explorer 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"
      ]
    }
  }
}

MS Access MCP Explorer 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

Frequently asked questions

1

What runtime dependencies are required?

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

2

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()`.

3

What tools are available?

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

4

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

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

5

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

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

Advertise