广告合作
MCP.so
登录

MS Access MCP Explorer

@sub-arjun

代码仓库

基本信息

分类

其他

许可证

MIT license

传输方式

stdio

作者

sub-arjun

关于 MS Access MCP Explorer

MCP Server for microsoft access databases

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

MS Access MCP Explorer 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

MS Access MCP Explorer 工具

2

`get_schema_tool(format="json")`

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

概览

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

常见问题

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.

评论

其他 分类下的更多 MCP 服务器

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

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

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.

广告合作