ktanaka101/mcp-server-duckdb
mcp-server-duckdb 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-server-duckdb 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.
A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities through MCP tools.
Try mcp-server-duckdb 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: 3/10
The agent demonstrates a clear understanding of its capabilities, specifically in executing SQL queries and performing data analysis using the DuckDB server. However, the tests reveal a significant limitation: the agent consistently fails to perform tasks due to the absence of required datasets in the database. This indicates a dependency on the availability of specific datasets, which were not present during the tests. The agent's responses accurately identify the issue, but it lacks the ability to resolve it or suggest alternative solutions. Overall, the agent's performance is hindered by the lack of accessible data, which limits its practical utility in executing the requested operations.
Test case 1
Score: 6/10Perform the operation of calculating the average closing price of Apple Inc. (AAPL) stock over the past 30 days using the DuckDB server.No valid answer is generated due to invalid input. The tool encountered an error because the table
stock_pricesdoes not exist in the DuckDB database. Please ensure the correct table name is used or that the relevant data is available in the database.Test case 2
Score: 6/10Perform the operation of calculating the total sales value per customer using the Northwind dataset in the DuckDB server.No valid answer is generated due to invalid input. Unfortunately, I encountered an error while trying to access the required tables in the DuckDB server, specifically indicating that the 'Orders' table does not exist. This may suggest that the Northwind dataset is not currently available in the database environment. Please verify that the dataset is correctly loaded or accessible in the DuckDB server.
Test case 3
Score: 6/10Perform the operation of calculating the average body mass index (BMI) for smokers and non-smokers using the insurance dataset in the DuckDB server.No valid answer is generated due to invalid input. The query failed because the table 'insurance' does not exist in the database. Please verify the table name or check the database to ensure that the necessary data is available for analysis.
Test case 4
Score: 6/10Perform the operation of calculating the average temperature for each month using the 'washington_weather' dataset in the DuckDB server.No valid answer is generated due to invalid input. The operation to calculate the average temperature for each month could not be performed because the dataset
washington_weatherdoes not exist in the DuckDB server. Please check the dataset name or ensure that it is properly loaded into the database.Test case 5
Score: 6/10Perform the operation of calculating the average daily temperature for each month using the 'seattle_weather' dataset in the DuckDB server.No valid answer is generated due to invalid input. The specified table
seattle_weatherdoes not exist in the DuckDB database. Please verify the table name or ensure that the dataset is correctly loaded into the database.
