MS Access MCP Explorer
About
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.
Details
- License
- MIT license
Explore
- 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
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
MS Access MCP ExplorerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Install using UV:
uv pip install omni-ms-access-mcp
Or using pip:
pip install omni-ms-access-mcp
uv venv
.venv\Scripts\activate.bat
uv pip install -e .
1. get_schema_tool - Get database schema information
- Optional parameter: format - Can be "text" (default) or "json"
- Example: get_schema_tool(format="json")
2. query_data - Execute SQL queries against the database
- Required parameter: sql - SQL query to execute
- Example: query_data(sql="SELECT * FROM Users LIMIT 10")
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"ms access mcp explorer": {
"ms-access-mcp": {
"command": "uvx",
"args": [
"omni-ms-access-mcp",
"--db-path",
"C:\\path\\to\\your\\database.accdb"
]
}
}
}
}McpServers
{
"ms-access-mcp": {
"command": "uvx",
"args": [
"omni-ms-access-mcp",
"--db-path",
"C:\\path\\to\\your\\database.accdb"
]
}
}A tool for exploring and querying Microsoft Access databases using MCP (Model-Command-Procedure).
Installation
Install using UV:
uv pip install omni-ms-access-mcp
Or using pip:
pip install omni-ms-access-mcp
Usage
Command Line
Start the MCP server with the path to your Access database:
ms-access-mcp --db-path "C:\path\to\your\database.accdb"
Python API
```python
from omni_ms_access_mcp.server import AccessMCP
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
