Omni Ms Access Mcp
What is Omni Ms Access Mcp
OMNI-MS-Access-MCP is a specialized MCP Server designed for exploring and querying Microsoft Access databases using the Model-Command-Procedure (MCP) framework.
Use cases
Use cases include generating reports from Access databases, integrating Access data with other applications, and automating data retrieval processes.
How to use
To use OMNI-MS-Access-MCP, install it via UV or pip, then start the server by specifying the path to your Access database. You can also interact with it using a Python API for more advanced functionalities.
Key features
Key features include tools for retrieving database schema information and executing SQL queries against the database, with options for output format.
Where to use
OMNI-MS-Access-MCP is suitable for use in data analysis, application development, and any scenario where Microsoft Access databases need to be queried or managed programmatically.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Omni Ms Access Mcp
OMNI-MS-Access-MCP is a specialized MCP Server designed for exploring and querying Microsoft Access databases using the Model-Command-Procedure (MCP) framework.
Use cases
Use cases include generating reports from Access databases, integrating Access data with other applications, and automating data retrieval processes.
How to use
To use OMNI-MS-Access-MCP, install it via UV or pip, then start the server by specifying the path to your Access database. You can also interact with it using a Python API for more advanced functionalities.
Key features
Key features include tools for retrieving database schema information and executing SQL queries against the database, with options for output format.
Where to use
OMNI-MS-Access-MCP is suitable for use in data analysis, application development, and any scenario where Microsoft Access databases need to be queried or managed programmatically.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
MS Access MCP Explorer
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
from omni_ms_access_mcp.server import AccessMCP
# Initialize the MCP server
mcp_server = AccessMCP(db_path="C:/path/to/your/database.accdb")
# Run the server
mcp_server.run()
Available Tools
-
get_schema_tool - Get database schema information
- Optional parameter:
format- Can be “text” (default) or “json” - Example:
get_schema_tool(format="json")
- Optional parameter:
-
query_data - Execute SQL queries against the database
- Required parameter:
sql- SQL query to execute - Example:
query_data(sql="SELECT * FROM Users LIMIT 10")
- Required parameter:
Development
Setup Development Environment
uv venv .venv\Scripts\activate.bat uv pip install -e .
Building the Package
publish.bat
Publishing to Package Index
uv pip install -U twine uv python -m twine upload dist/*
Requirements
- Microsoft Access Driver must be installed on your system
- Python 3.7 or higher
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
