Alkemi MCP

🚀 Alkemi MCP Server

Integrate your Alkemi Data, connected to Snowflake, Google BigQuery, DataBricks and other sources, with your MCP Client.

This is a STDIO wrapper for the Streamable HTTP MCP Endpoint:

https://api.alkemi.cloud/mcp

Get your free API key at datalab.alkemi.ai

🚀 Quick Start

The Alkemi MCP Server uses Alkemi to store the database metadata, generate proper queries and actually query the database so you can share your MCP Server with teammates and everyone will have the same ability to query with quality.

Querying databases requires knowledge about the schema of the tables and may require examples of the kinds of queries that can answer specific questions. Otherwise, you may be getting the wrong answers. Maintaining all that information in every agent or MCP Client that queries your database is a challenge and doesn't scale to teams looking to share data.

✨ Features

• Integrate Alkemi Data from multiple sources (Snowflake, Google BigQuery, DataBricks, etc.) with MCP Client.
• Use Alkemi to handle database metadata, query generation, and actual database querying.
• Share MCP Server among teammates for consistent querying capabilities.

📦 Installation

Server Config

To add OpenAI to Claude Desktop, add the server config:

• On MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json
• On Windows: %APPDATA%/Claude/claude_desktop_config.json

Env Vars

• MCP_NAME: The name of the MCP Server. This is optional. If you configure multiple, this is required so they do not have the same names in your MCP Client.
• BEARER_TOKEN: The Bearer token for the Streamable HTTP MCP Server. This is required for the STDIO MCP Integration.
• PRODUCT_ID: The ID of the Product if you want to narrow scope to just a single product. This is optional.

Configuration

You can use it via npx in your Claude Desktop configuration like this:

{
  "mcpServers": {
    "alkemi": {
      "command": "npx",
      "args": [
        "@alkemiai/alkemi-mcp"
      ],
      "env": {
        "BEARER_TOKEN": "sk-12345"
      }
    }
  }
}

Or, if you clone the repo, you can build and use in your Claude Desktop configuration like this:

{
  "mcpServers": {
    "alkemi-data": {
      "command": "node",
      "args": [
        "/path/to/alkemi-mcp/build/index.js"
      ],
      "env": {
        "BEARER_TOKEN": "sk-12345"
      }
    }
  }
}

If you want to specify a specific product that the MCP Server should use, you can specify the PRODUCT_ID environment variable. And with setting the MCP_NAME, you can configure multiple.

{
  "mcpServers": {
    "alkemi-customer-data": {
      "command": "node",
      "args": [
        "/path/to/alkemi-mcp/build/index.js"
      ],
      "env": {
        "MCP_NAME": "customer-data",
        "PRODUCT_ID": "123",
        "BEARER_TOKEN": "sk-12345"
      }
    },
    "alkemi-web-traffic-data": {
      "command": "node",
      "args": [
        "/path/to/alkemi-mcp/build/index.js"
      ],
      "env": {
        "MCP_NAME": "web-traffic-data",
        "PRODUCT_ID": "234",
        "BEARER_TOKEN": "sk-12345"
      }
    }
  }
}

💻 Usage Examples

Basic Usage

The basic usage is demonstrated through the configuration examples in the Installation section. For example, using npx in the Claude Desktop configuration:

{
  "mcpServers": {
    "alkemi": {
      "command": "npx",
      "args": [
        "@alkemiai/alkemi-mcp"
      ],
      "env": {
        "BEARER_TOKEN": "sk-12345"
      }
    }
  }
}

Advanced Usage

If you want to configure multiple MCP Servers with different products and names, you can use the following configuration:

{
  "mcpServers": {
    "alkemi-customer-data": {
      "command": "node",
      "args": [
        "/path/to/alkemi-mcp/build/index.js"
      ],
      "env": {
        "MCP_NAME": "customer-data",
        "PRODUCT_ID": "123",
        "BEARER_TOKEN": "sk-12345"
      }
    },
    "alkemi-web-traffic-data": {
      "command": "node",
      "args": [
        "/path/to/alkemi-mcp/build/index.js"
      ],
      "env": {
        "MCP_NAME": "web-traffic-data",
        "PRODUCT_ID": "234",
        "BEARER_TOKEN": "sk-12345"
      }
    }
  }
}

🔧 Technical Details

Development

• Install dependencies:

npm install

• Build the server:

npm run build

• For development with auto - rebuild:

npm run watch

Debugging

Since MCP servers communicate over stdio, debugging can be challenging. We recommend using the MCP Inspector, which is available as a package script:

npm run inspector

The Inspector will provide a URL to access debugging tools in your browser.

Acknowledgements

• Obviously the modelcontextprotocol and Anthropic teams for the MCP Specification and integration into Claude Desktop. https://modelcontextprotocol.io/introduction