MCP.so
登录

MS Access MCP Explorer

@sub-arjun

代码仓库

关于 MS Access MCP Explorer

MCP Server for microsoft access databases

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

基本信息

分类

其他

许可证

MIT license

运行时

python

传输方式

stdio

发布者

sub-arjun

配置

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

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

工具

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

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.

评论

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

Unity MCP ✨

justinpbarnett

Unity MCP acts as a bridge between AI assistants and your Unity Editor. Give your LLM tools to manage assets, control scenes, edit scripts, and automate tasks within Unity.

12.2K

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K

MCP Go 🚀

mark3labs

A Go implementation of the Model Context Protocol (MCP), enabling seamless integration between LLM applications and external data sources and tools.

8.9K