Mirror MCP Server

April 2, 2025 ยท View on GitHub

A simple MCP (Model Context Protocol) server that provides a tool for mirroring tables from ODBC to SQLite. This allows Claude Desktop to move data between databases without loading large datasets into its context window.

Features

  • Single purpose: mirror tables from ODBC to SQLite
  • Works with any ODBC-compatible database
  • Automatically creates SQLite tables with appropriate schema
  • Handles large tables with batch processing
  • Preserves data types during transfer
  • Special handling for ProvideX/Sage 100 connections

Prerequisites

  • Python 3.10 or higher
  • UV package manager
  • ODBC drivers for your source database
  • Claude Desktop with both ODBC and SQLite MCP servers configured

Installation

# Clone the repository
git clone https://github.com/yourusername/mirror-mcp-server.git
cd mirror-mcp-server

# Install with UV
uv venv
source .venv/bin/activate  # On Windows: .venv\Scripts\activate
uv pip install -e .

Configuration

This server requires both an ODBC configuration file and a path to a SQLite database:

mirror-mcp-server --odbc-config /path/to/odbc-config.ini --sqlite-db /path/to/sqlite.db

Claude Desktop Integration

Add the Mirror MCP server to your Claude Desktop configuration:

{
  "mcpServers": {
    "mirror": {
      "command": "uv",
      "args": [
        "--directory",
        "C:\\path\\to\\mirror-mcp-server",
        "run",
        "mirror-mcp-server",
        "--odbc-config", 
        "C:\\path\\to\\odbc-config.ini",
        "--sqlite-db",
        "C:\\path\\to\\sqlite.db"
      ]
    }
  }
}

Usage

Once the server is running and connected to Claude Desktop, you can use the following tools:

1. mirror-table

Copies a table from ODBC to SQLite:

# Example query in Claude
Mirror the Customer table from ODBC to SQLite

Parameters:

  • source_table: Name of the source table in ODBC (required)
  • dest_table: Name of the destination table in SQLite (optional, defaults to source name)
  • connection_name: Name of the ODBC connection to use (optional, uses default if not specified)
  • overwrite: Whether to overwrite existing data (optional, defaults to false)

2. list-odbc-connections

Lists all available ODBC connections from the config file:

# Example query in Claude
List the available ODBC connections

Example Workflows

  1. Mirror a customer table and then analyze it:

    First, mirror the AR_Customer table from the ODBC database to SQLite.
Then, show me the total number of customers by region from the SQLite database.

  2. Create a reporting database:

    Mirror the following tables from ODBC to SQLite:
- Sales_Header
- Sales_Detail
- Product
- Customer

Then create a sales summary report by month using the SQLite data.

Troubleshooting

  • Connection errors: Verify that the ODBC configuration file is correct
  • Table not found: Check that the table name is spelled correctly and accessible to the ODBC user
  • Permission issues: Ensure the SQLite database path is writable

License

MIT License