OMNI MS Access MCP

🚀 MS Access MCP Explorer

A tool for exploring and querying Microsoft Access databases using MCP (Model-Command-Process).

🚀 Quick Start

This tool allows users to explore and query Microsoft Access databases, leveraging the MCP architecture.

✨ Features

• Explore and query Microsoft Access databases.
• Provide multiple ways to install and use, including command - line and Python API.
• Offer useful tools for getting database schema and executing SQL queries.

📦 Installation

You can install the tool using UV:

uv pip install omni-ms-access-mcp

Or use pip:

pip install omni-ms-access-mcp

💻 Usage Examples

Basic Usage

Command Line

Start the MCP server by specifying the database path:

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()

Advanced Usage

Here are some available tools:

1. get_schema_tool - Retrieve database schema information

   • Optional parameter: format - can be "text" (default) or "json"
   • Example: get_schema_tool(format="json")

2. query_data - Execute an SQL query on the database

   • Required parameter: sql - the SQL query to be executed
   • Example: query_data(sql="SELECT * FROM Users LIMIT 10")

🔧 Technical Details

Setting up the Development Environment

uv venv
.venv\Scripts\activate.bat
uv pip install -e .

Packaging

publish.bat

Publishing to the Package Index

uv pip install -U twine
uv python -m twine upload dist/*

📚 Documentation

Requirements

• Microsoft Access driver must be installed on the system.
• Python 3.7 or higher is required.