mcp-server-duckdb and dbt-core-mcp
These tools are complements; `dbt-core-mcp` provides a server for managing dbt projects, while `ktanaka101/mcp-server-duckdb` offers an MCP server specifically for interacting with DuckDB as a data source within the broader data modeling context.
About mcp-server-duckdb
ktanaka101/mcp-server-duckdb
A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities
This project helps data analysts and researchers use large language models (LLMs) to interact with their local DuckDB databases. It takes natural language requests from an LLM, translates them into SQL queries, executes them against your DuckDB file, and returns the results to the LLM. This allows you to perform data analysis, retrieve specific information, or even inspect your database schema without writing SQL yourself.
About dbt-core-mcp
NiclasOlofsson/dbt-core-mcp
dbt Core MCP Server: Interact with dbt projects via Model Context Protocol
This project helps data engineers and analytics engineers work with dbt more efficiently using AI assistants like Copilot. It allows you to use natural language to interact with your dbt project, giving commands like 'run my changes and test downstream' without leaving your editor. This means less context switching and faster execution of common dbt tasks, with the AI understanding your specific dbt environment and project structure.
Related comparisons
Scores updated daily from GitHub, PyPI, and npm data. How scores work