ODBC

🚀 MCP Server ODBC Usage Guide

This guide provides a detailed introduction to using the MCP Server ODBC, including installation steps, configuration examples, and usage instructions for different applications and tools.

🚀 Quick Start

The steps to use the MCP detection tool are as follows:

1. Download and install Node.js: Ensure that Node.js is installed and verify the version.
2. Clone or download the MCP detection tool repository: Obtain the code from the specified location.
3. Install dependencies:

   npm install
   

4. Start the detection tool:

   npm start
   

✨ Features

Using the Claude Desktop Application

Configuration File Path and Example Content

The configuration file is located at: ~/Library/Application Support/Claude/mcp_settings.json

{
  "mcpServers": {
    "ODBC": {
      "command": "/path/to/.nvm/versions/node/v21.1.0/bin/node",
      "args": [
        "/path/to/mcp-odbc-server/node_modules/.bin/tsx",
        "/path/to/mcp-odbc-server/src/main.ts"
      ],
      "env": {
        "ODBCINI": "/Library/ODBC/odbc.ini",
        "NODE_VERSION": "v21.1.0",
        "PATH": "~/.nvm/versions/node/v21.1.0/bin:${PATH}"
      },
      "disabled": false,
      "autoApprove": []
    }
  }
}

Usage Steps

1. Open the application.
2. Apply the configuration through the developer interface in the settings (see above).
3. Ensure that a valid ODBC data source connection has been established.
4. Enter the following example command:

   Execute the following query: SELECT TOP * from Demo..Customers
   

Using the Cline VS Code Extension

Configuration File Path and Example Content

The configuration file is located at: ~/Library/Application Support/Code/User/globalStorage/saoudrizwan.claude-dev/settings/cline_mcp_settings.json

{
  "mcpServers": {
    "ODBC": {
      "command": "/path/to/.nvm/versions/node/v21.1.0/bin/node",
      "args": [
        "/path/to/mcp-odbc-server/node_modules/.bin/tsx",
        "/path/to/mcp-odbc-server/src/main.ts"
      ],
      "env": {
        "ODBCINI": "/Library/ODBC/odbc.ini",
        "NODE_VERSION": "v21.1.0",
        "PATH": "~/.nvm/versions/node/v21.1.0/bin:${PATH}"
      },
      "disabled": false,
      "autoApprove": []
    }
  }
}

Usage Steps

1. Open VS Code.
2. Use the shortcut Shift + Command + P to open the command palette.
3. Enter Cline and select the corresponding option to open the plugin interface.
4. Enter the following example command:

   Execute the following query: SELECT TOP * from Demo..Customers
   

Using the Cursor Editor

Configuration Steps

1. In Cursor, navigate to the settings menu.
2. Select the "MCP Server" option for configuration.
3. Ensure that the correct ODBC connection information is filled in.

Usage Examples

Enter the following command:

Execute the following query: SELECT TOP * from Demo..Customers

📚 Documentation

Related Video Tutorial Links

1. Claude Desktop Application Usage Demonstration: Video Link
2. Cline VS Code Extension Usage Demonstration: Video Link
3. Cursor Editor Usage Demonstration: Video Link
4. MCP Detection Tool Usage Demonstration: Video Link