ktanaka101_mcp-server-duckdb
If you are the rightful owner of ktanaka101_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 DuckDB, a database engine suitable for local analysis. It supports both read and write operations, although it can be configured to run in a read-only mode to ensure data integrity and prevent unintended modifications. This server is particularly useful for applications that require efficient local data processing and analysis.
Features
- Database Interaction: Enables execution of SELECT, INSERT, UPDATE, DELETE, and CREATE TABLE queries.
- Read-Only Mode: Provides an option to run the server in a mode that prevents any write operations, ensuring data integrity.
- Table Management: Includes tools for listing tables and describing table schemas.
- Automatic Database Creation: Automatically creates the database file and parent directories if they do not exist.
- Security: Prevents unintended database modifications by disabling write operations in read-only mode.
Tools
read-query
Execute SELECT queries to read data from the database.
write-query
Execute INSERT, UPDATE, or DELETE queries to modify data.
create-table
Create new tables in the database.
list-tables
List all tables in the database.
describe-table
Get schema information for a specific table.
