MCP Pyodbc Server

🚀 MCP Protocol ODBC Server Plugin

This is a universal ODBC database connector based on the MCP protocol, supporting connections to various databases through ODBC drivers.

🚀 Quick Start

Initialize the MCP service

from mcp import Service, BinaryFileStorage
import logging

# Configure logging
logging.basicConfig(level=logging.INFO)

# Create a service instance
service = Service(
    storage=BinaryFileStorage('data/'),  # Data storage directory
    name='ODBC Server',                  # Service name
    description='An ODBC server based on MCP protocol'  # Service description
)

Define the database connection configuration

from mcp.config import ODBCConfig

# Create an ODBC configuration
config = ODBCConfig(
    driver='path/to/your/driver',  # ODBC driver path
    connection_string='DRIVER={Your Driver};DATABASE={Your Database}',  # Connection string
    username='your_username',       # Database username
    password='your_password'        # Database password
)

Start the MCP service

# Add the ODBC plugin and start the service
service.add_plugin('ODBC', config)
service.start()

# Press Ctrl+C to shut down the service

✨ Features

• Supports connections to various databases through ODBC drivers.
• Provides multiple management interfaces such as user management, database management, etc.

📦 Installation

Install using pip:

pip install mcp-odbc

If you need to debug or develop, you can clone the repository and install from the source code:

git clone https://github.com/your-repository/mcp-odbc.git
cd mcp-odbc
pip install -e .

💻 Usage Examples

Initialize the MCP service

from mcp import Service, BinaryFileStorage

# Configure logging
logging.basicConfig(level=logging.INFO)

# Create a service instance
service = Service(
    storage=BinaryFileStorage('data/'),  # Data storage directory
    name='ODBC Server',                  # Service name
    description='An ODBC server based on MCP protocol'  # Service description
)

Add the ODBC plugin

from mcp.plugins import add_odbc_plugin

# Configure ODBC connection parameters
odbc_config = {
    'driver': 'path/to/your/driver',  # ODBC driver path
    'connection_string': 'DRIVER={Your Driver};DATABASE={Your Database}',  # Connection string
    'username': 'your_username',       # Database username
    'password': 'your_password'        # Database password
}

# Add the ODBC plugin
add_odbc_plugin(service, odbc_config)

Start the service

import uvicorn

# Start the service
uvicorn.run('mcp_server:app', reload=True)

📚 Documentation

Run the example service with the following command:

uvicorn mcp_server:app --reload

Then access the management console at http://localhost:8000 in your browser.

Supported Interfaces

• /api/v1/login - Login verification
• /api/v1/users - User management
• /api/v1/databases - Database management
• /api/v1/models - Model management
• /api/v1/files - File management

📄 References

[1] MCP Protocol Specification
[2] ODBC Driver Development Guide