Alkemi MCP Server
Integrate Alkemi Data sources with MCP Clients for seamless, standardized data querying.
Key Features
Use Cases
README
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
Alkemi.ai
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.
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.
Installation
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"
}
}
}
}
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
Star History
Repository Owner
Organization
Repository Details
Programming Languages
Tags
Join Our Newsletter
Stay updated with the latest AI tools, news, and offers by subscribing to our weekly newsletter.
Related MCPs
Discover similar Model Context Protocol servers
Codex MCP Server
An MCP-compatible server delivering enriched blockchain data for AI models.
Codex MCP Server implements the Model Context Protocol to provide enriched blockchain data from Codex. It is compatible with MCP clients such as Claude Desktop and Claude CLI, allowing seamless integration in AI workflows that require blockchain context. Users can run the server locally or via npx, and configure it for various MCP-compatible tools using their Codex API key.
- ⭐ 20
- MCP
- Codex-Data/codex-mcp
MCP Manager for Claude Desktop
A desktop app to manage Model Context Protocol (MCP) servers for Claude Desktop on MacOS.
MCP Manager for Claude Desktop provides a user-friendly interface to manage Model Context Protocol (MCP) servers, enabling Claude to access private data, APIs, and local or remote services securely from a MacOS desktop. It facilitates rapid configuration and integration with a wide variety of MCP servers, including productivity tools, databases, and web APIs. The app runs locally to ensure data privacy and streamlines connecting Claude to new sources through simple environment and server settings management.
- ⭐ 270
- MCP
- zueai/mcp-manager
Taskade MCP
Tools and server for Model Context Protocol workflows and agent integration
Taskade MCP provides an official server and tools to implement and interact with the Model Context Protocol (MCP), enabling seamless connectivity between Taskade’s API and MCP-compatible clients such as Claude or Cursor. It includes utilities for generating MCP tools from any OpenAPI schema and supports the deployment of autonomous agents, workflow automation, and real-time collaboration. The platform promotes extensibility by supporting integration via API, OpenAPI, and MCP, making it easier to build and connect agentic systems.
- ⭐ 90
- MCP
- taskade/mcp
Dune Analytics MCP Server
Bridge Dune Analytics data seamlessly to AI agents via a Model Context Protocol server.
Dune Analytics MCP Server provides a Model Context Protocol-compliant server that allows AI agents to access and interact with Dune Analytics data. It exposes tools to fetch the latest results of Dune queries and execute arbitrary queries, returning results in CSV format. The server is easily deployable, supports integration with platforms like Claude Desktop, and requires a Dune Analytics API key for operation.
- ⭐ 31
- MCP
- kukapay/dune-analytics-mcp
OpenAI MCP Server
Bridge between Claude and OpenAI models using the MCP protocol.
OpenAI MCP Server enables direct querying of OpenAI language models from Claude via the Model Context Protocol (MCP). It provides a configurable Python server that exposes OpenAI APIs as MCP endpoints. The server is designed for seamless integration, requiring simple configuration updates and environment variable setup. Automated testing is supported to verify connectivity and response from the OpenAI API.
- ⭐ 77
- MCP
- pierrebrunelle/mcp-server-openai
MCP Server for Data Exploration
Interactive Data Exploration and Analysis via Model Context Protocol
MCP Server for Data Exploration enables users to interactively explore and analyze complex datasets using prompt templates and tools within the Model Context Protocol ecosystem. Designed as a personal Data Scientist assistant, it facilitates the conversion of raw data into actionable insights without manual intervention. Users can load CSV datasets, run Python scripts, and generate tailored reports and visualizations through an AI-powered interface. The server integrates directly with Claude Desktop, supporting rapid setup and seamless usage for both macOS and Windows.
- ⭐ 503
- MCP
- reading-plus-ai/mcp-server-data-exploration
Didn't find tool you were looking for?