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 のツール

`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

よくある質問

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.

「その他」の他のコンテンツ

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi

Codelf

unbug

A search tool helps dev to solve the naming things problem.

14.2K

Hindsight

vectorize-io

Hindsight: Agent Memory That Learns

50.4K

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K