mcp-server-duckdb

mcp-server-duckdb

3.6
databases

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.

The mcp-server-duckdb is a server implementation that facilitates interaction with a DuckDB database using the Model Context Protocol. It allows users to perform various database operations such as querying, table creation, and schema inspection. The server is designed to work seamlessly with modern Language Learning Models (LLMs), enabling them to generate and execute SQL queries efficiently. It supports a unified query function that can handle all types of SQL operations, making it versatile and easy to use. The server can be configured to run in read-only mode to ensure data integrity and prevent unauthorized write operations. It also offers the option to reuse a single DuckDB connection for improved performance. The server is compatible with platforms like Claude Desktop and can be installed via Smithery.

Features

  • Unified Query Function: Execute any SQL query on the DuckDB database using a single function.
  • Read-Only Mode: Ensures data integrity by preventing write operations when enabled.
  • Connection Reuse: Option to reuse a single DuckDB connection for faster queries.
  • Automatic Database Creation: Automatically creates the database file and directories if they don't exist.
  • Integration with LLMs: Designed to work with modern LLMs for efficient SQL generation and execution.

Tools

  1. query

    Perform any DuckDB SQL query

Related MCP Servers

View all databases servers →
mysql_mcp_server

mysql_mcp_server

4.5

by designcomputer

MySQL MCP Server is a Model Context Protocol implementation that facilitates secure interaction between AI applications and MySQL databases.

databases
dbhub

dbhub

4.4

by bytebase

DBHub is a universal database gateway implementing the Model Context Protocol (MCP) server interface.

databases
mcp-server-neon

mcp-server-neon

4.3

by neondatabase-labs

Neon MCP Server is an open-source tool that enables natural language interaction with Neon Postgres databases.

databases
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
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
mcp-server

mcp-server

3.9

by keboola

Keboola MCP Server connects AI agents and MCP clients to Keboola, enabling data access and transformations without glue code.

cloud_platforms
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
genai-toolbox

genai-toolbox

3.8

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
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-server-qdrant

mcp-server-qdrant

3.8

by qdrant

The mcp-server-qdrant is a Model Context Protocol server designed to integrate with the Qdrant vector search engine, providing a semantic memory layer for storing and retrieving information.

knowledge_and_memory
notion-mcp-server

notion-mcp-server

3.7

by makenotion

This project implements an MCP server for the Notion API, allowing integration with LLMs.

databases
mariadb-mcp-server

mariadb-mcp-server

3.7

by rjsalgado

This MCP server provides access to MariaDB / MySQL databases, allowing users to list databases, tables, describe table schemas, and execute SQL queries with security features.

databases
mcp-clickhouse

mcp-clickhouse

3.7

by ClickHouse

An MCP server for ClickHouse that allows executing SQL queries and managing databases and tables.

databases
osv-mcp

osv-mcp

3.7

by StacklokLabs

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

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-kql-server

mcp-kql-server

3.7

by 4R9UN

A Model Context Protocol (MCP) server for executing Kusto Query Language (KQL) queries against Azure Data Explorer clusters.

databases
mongodb-mcp-server

mongodb-mcp-server

3.7

by mongodb-js

A Model Context Protocol server for interacting with MongoDB Databases and MongoDB Atlas.

databases
mcp-server-milvus

mcp-server-milvus

3.6

by zilliztech

The MCP Server for Milvus enables seamless integration between LLM applications and the Milvus vector database, providing a standardized way to connect LLMs with the context they need.

databases
mcp-google-sheets

mcp-google-sheets

3.6

by xing5

mcp-google-sheets is a Python-based MCP server that connects MCP-compatible clients to Google Sheets API for automation and data manipulation.

cloud_platforms
mongo-mcp

mongo-mcp

3.6

by QuantGeekDev

A Model Context Protocol (MCP) server that enables LLMs to interact directly with MongoDB databases. Query collections, inspect schemas, and manage data seamlessly through natural language.

databases
mcp-1panel

mcp-1panel

3.6

by 1Panel-dev

1Panel MCP Server is an implementation of the Model Context Protocol (MCP) server for 1Panel, providing a range of tools for system, website, certificate, application, and database management.

os_automation
mcp-server-weaviate

mcp-server-weaviate

3.6

by weaviate

Weaviate MCP Server is a protocol server designed to interact with the Weaviate vector database, providing functionalities for inserting and querying data.

databases
elasticsearch-mcp-server

elasticsearch-mcp-server

3.6

by cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction. This server enables searching documents, analyzing indices, and managing cluster through a set of tools.

databases
mcp-server-bigquery

mcp-server-bigquery

3.6

by LucasHild

A Model Context Protocol server that provides access to BigQuery, enabling LLMs to inspect database schemas and execute queries.

databases
mcp-tinybird

mcp-tinybird

3.6

by tinybirdco

An MCP server to interact with a Tinybird Workspace from any MCP client.

databases
MCPServerForMSSQL

MCPServerForMSSQL

3.6

by shakunvohradeltek

This repository contains the SQL Server MCP (Model Context Protocol) integration for Claude, allowing direct querying and analysis of SQL Server databases using natural language.

databases
notion-mcp-server

notion-mcp-server

3.6

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