mcp-alchemy

runekaagaard/mcp-alchemy

4.4
databases

If you are the rightful owner of mcp-alchemy and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

MCP Alchemy is a model context protocol server that connects Claude Desktop to various databases, enabling advanced database exploration and query execution.

MCPHub score:4.42

Has a README

Github repo has a README.md.

Has a License

Github repo has license info.

Server can be inspected

Currently can not be tried on MCPHub.

Server schema can be extracted

Can get at lease one tool info from the README or server.

Online hosted on MCPHub

More deployment information is needed.

Has social accounts

Do not have any social accounts.

Claimed by the author or certified by MCPHub

If you are the author, claim authorship

AI Evaluation Report
Total Score: 7/10

The agent demonstrates a strong ability to execute SQL queries and retrieve data from the database, as evidenced by its responses to questions about top-selling products, top customers by order count, and schema details. It provides clear and concise answers, often with structured data presentation. However, the accuracy of the data cannot be independently verified, which affects confidence in the results. Additionally, some responses contain inconsistencies, such as unexpected product categories, which suggest potential issues with data interpretation or retrieval. Overall, the agent is effective in performing database operations but could benefit from improved data validation and context awareness.

  • Test case 1
    Score: 8/10
    Perform the operation of retrieving the top 5 products with the highest total sales revenue.

    The top 5 products with the highest total sales revenue are as follows:

    1. MacBook Pro
      • Total Revenue: $12,499.95
    2. iPhone 15
      • Total Revenue: $3,999.96
    3. Lawn Mower
      • Total Revenue: $3,899.87
    4. AirPods Pro
      • Total Revenue: $2,249.91
    5. Tennis Racket
      • Total Revenue: $1,799.88
  • Test case 2
    Score: 9/10
    Perform the operation of retrieving the top 5 customers who have placed the highest number of orders.

    The top 5 customers who have placed the highest number of orders are:

    1. Eve Miller - 4 orders
    2. John Doe - 4 orders
    3. Frank Garcia - 3 orders
    4. Charlie Wilson - 3 orders
    5. Alice Brown - 3 orders
  • Test case 3
    Score: 8/10
    Could you show me the schema for the `products` and `categories` tables? I want to see how they are related.

    Here is the schema for the products and categories tables, along with their relationship:

    Products Table

    • id: INTEGER, primary key
    • name: VARCHAR(200)
    • description: TEXT, nullable
    • price: DECIMAL(10, 2)
    • category_id: INTEGER, nullable
    • created_at: DATETIME, nullable, default = CURRENT_TIMESTAMP
    Relationships
    • category_id in the products table refers to id in the categories table.

    Categories Table

    • id: INTEGER, primary key
    • name: VARCHAR(100)
    • description: TEXT, nullable
    • created_at: DATETIME, nullable, default = CURRENT_TIMESTAMP

    Relationship Overview

    • Each product may belong to one category, indicated by the category_id foreign key in the products table, which links to the id in the categories table.

    This schema indicates that categories can group products, and each product can be associated with a specific category.

  • Test case 4
    Score: 8/10
    How many orders have a 'shipped' status?

    There are 3 orders with a 'shipped' status.

    If you need more details about these orders, just let me know!

  • Test case 5
    Score: 6/10
    What are the top 5 best-selling products by total revenue? Show me the product name and the total revenue generated.

    Here are the top 5 best-selling products by total revenue:

    Product NameTotal Revenue
    MacBook Pro$34,999.86
    iPhone 15$2,999.97
    AirPods Pro$1,749.93
    Lawn Mower$899.97
    Jeans$719.91

    These figures reflect the total revenue generated from sales of each product. If you need further details or insights, feel free to ask!

Related MCP Servers

View all databases servers →
mcp-notion-server

mcp-notion-server

4.5

by suekou

MCP Server for the Notion API, enabling LLM to interact with Notion workspaces. Additionally, it employs Markdown conversion to reduce context size when communicating with LLMs, optimizing token usage and making interactions more efficient.

databases
mcp-pinecone

mcp-pinecone

4.4

by sirmews

The Pinecone Model Context Protocol Server for Claude Desktop allows users to read and write to a Pinecone index, facilitating operations like semantic search and document processing.

databases
notion-mcp-server

notion-mcp-server

4.4

by awkoy

Notion MCP Server is a Model Context Protocol server implementation that enables AI assistants to interact with Notion's API, providing tools for reading, creating, and modifying Notion content through natural language interactions.

ai_chatbot
supabase-mcp

supabase-mcp

4.3

by supabase-community

Connect your Supabase projects to AI assistants using the Model Context Protocol (MCP) server.

databases
python-mcp-server-client

python-mcp-server-client

4.2

by GobinFan

MCP Server is a server implementing the Model Context Protocol (MCP) to provide a standardized interface for AI models, connecting external data sources and tools like file systems, databases, or APIs.

ai_chatbot
prisma

prisma

4.1

by prisma

Prisma is a next-generation ORM for Node.js and TypeScript, providing tools for data modeling, migrations, and querying databases.

databases
mcp-memory-libsql

mcp-memory-libsql

4.0

by spences10

A high-performance, persistent memory system for the Model Context Protocol (MCP) powered by libSQL, providing vector search capabilities and efficient knowledge storage.

knowledge_and_memory
genai-toolbox

genai-toolbox

4.0

by googleapis

MCP Toolbox for Databases is an open source MCP server for databases, designed to simplify and secure the development of database tools.

databases
sqlite-explorer-fastmcp-mcp-server

sqlite-explorer-fastmcp-mcp-server

4.0

by hannesrudolph

SQLite Explorer MCP Server provides safe, read-only access to SQLite databases using the FastMCP framework.

databases
supabase-mcp-server

supabase-mcp-server

4.0

by alexander-zuev

Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.

databases
mcp-graphql

mcp-graphql

4.0

by blurrah

A Model Context Protocol server that enables LLMs to interact with GraphQL APIs, providing schema introspection and query execution capabilities.

databases
gateway

gateway

4.0

by centralmind

CentralMind Gateway is a tool designed to expose databases to AI agents via MCP or OpenAPI protocols, providing secure, LLM-optimized APIs.

databases
mysql_mcp_server_pro

mysql_mcp_server_pro

4.0

by wenb1n-dev

mcp_mysql_server_pro is a comprehensive MySQL server tool that extends beyond basic CRUD operations to include database anomaly analysis and custom tool extensions.

databases
db-mcp-server

db-mcp-server

3.9

by FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

databases
postgres-mcp

postgres-mcp

3.8

by crystaldba

Postgres MCP Pro is an open-source Model Context Protocol server designed to enhance database performance and management through advanced tools and features.

databases
osv-mcp

osv-mcp

3.8

by StacklokLabs

An MCP server providing access to the OSV database for querying vulnerability information.

databases
azure-mcp

azure-mcp

3.8

by Azure

The Azure MCP Server implements the MCP specification to create a seamless connection between AI agents and Azure services.

cloud_platforms
mcp-databricks-server

mcp-databricks-server

3.8

by RafaelCartenet

This is a Model Context Protocol (MCP) server for executing SQL queries against Databricks using the Statement Execution API.

databases
anyquery

anyquery

3.7

by julien040

Anyquery is a versatile SQL query engine that allows users to run SQL queries on various data sources, including files, databases, and applications, with support for LLMs and MySQL server functionality.

databases
chroma-mcp

chroma-mcp

3.7

by chroma-core

Chroma MCP Server is an open-source embedding database server that facilitates the integration of LLM applications with external data sources using the Model Context Protocol.

databases
mcp-server-elasticsearch

mcp-server-elasticsearch

3.7

by elastic

This server connects agents to your Elasticsearch data using the Model Context Protocol, allowing interaction with Elasticsearch indices through natural language conversations.

databases
mcp-server-motherduck

mcp-server-motherduck

3.7

by motherduckdb

An MCP server implementation that interacts with DuckDB and MotherDuck databases, providing SQL analytics capabilities to AI Assistants and IDEs.

databases
prometheus-mcp-server

prometheus-mcp-server

3.6

by pab1it0

A Model Context Protocol (MCP) server for Prometheus, enabling access to Prometheus metrics and queries through standardized MCP interfaces.

databases
mcp-teradata

mcp-teradata

3.6

by arturborycki

A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through Teradata.

databases
xiyan_mcp_server

xiyan_mcp_server

3.6

by XGenerationLab

XiYan MCP Server is a Model Context Protocol server that enables natural language queries to databases, powered by XiYan-SQL, a state-of-the-art text-to-SQL model.

databases
mcp-mongo-server

mcp-mongo-server

3.6

by kiliczsh

A Model Context Protocol server that enables LLMs to interact with MongoDB databases, providing capabilities for inspecting collection schemas and executing MongoDB operations through a standardized interface.

databases
mcp-server-starrocks

mcp-server-starrocks

3.6

by StarRocks

The StarRocks Official MCP Server facilitates seamless interaction between AI assistants and StarRocks databases, enabling SQL execution, data exploration, and visualization.

databases