runekaagaard/mcp-alchemy
mcp-alchemy is hosted online, so all tools can be tested directly either in theInspector tabor in theOnline Client.
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.
Try mcp-alchemy with chat:
Has a README
Github repo has a README.md.
Has a License
Github repo has license info.
Server can be inspected
View server inspector
Server schema can be extracted
Can get at lease one tool info from the README or server.
Online hosted on MCPHub
Can be automatically deployed by MCPHub.
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 ReportTotal Score: 5/10
The agent demonstrates a strong ability to retrieve and present data from the database, as evidenced by its accurate identification of top customers by order count. However, it struggles with providing context and verifying the accuracy of its data, particularly in tasks involving financial metrics like sales revenue and profit margins. The agent's responses often lack necessary details such as time frames, data sources, and methodologies, which are crucial for ensuring transparency and reliability. Additionally, the agent's inability to calculate profit margins due to missing data highlights a limitation in its data access capabilities. Overall, while the agent is capable of executing SQL queries and retrieving data, its effectiveness is hindered by a lack of contextual information and occasional inaccuracies.
Test case 1
Score: 4/10Perform 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:
- MacBook Pro
- Total Revenue: $12,499.95
- iPhone 15
- Total Revenue: $3,999.96
- Lawn Mower
- Total Revenue: $3,899.87
- AirPods Pro
- Total Revenue: $2,249.91
- Tennis Racket
- Total Revenue: $1,799.88
- MacBook Pro
Test case 2
Score: 9/10Perform 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:
- Eve Miller - 4 orders
- John Doe - 4 orders
- Frank Garcia - 3 orders
- Charlie Wilson - 3 orders
- Alice Brown - 3 orders
Test case 3
Score: 6/10Perform the operation of retrieving the top 5 products with the highest profit margins.No valid answer is generated due to invalid input. The necessary data (cost) is not available in the
productstable, which prevents the calculation of profit margins.Test case 4
Score: 3/10Perform the operation of retrieving the top 5 product categories with the highest average profit margins.The top 5 product categories with the highest average profit margins are as follows:
Category Name Average Profit Margin Electronics $999.99 Home & Garden $218.99 Sports $100.90 Clothing $52.72 Books $47.26 These categories show significant variations in average profit margins, with Electronics leading the way by a substantial margin. Test case 5
Score: 5/10Perform the operation of retrieving the total number of orders placed in the last 30 days.The total number of orders placed in the last 30 days is 20.
