lab1702/duckmcp
If you are the rightful owner of duckmcp 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.
The DuckDB MCP Server provides secure, read-only access to DuckDB databases and data files, supporting multiple data sources and offering rich metadata and powerful querying capabilities.
Tools
Functions exposed to the LLM to take actions
get_tables
List all available tables and views in the database.
get_schema
Get the schema (columns and types) for a specific table.
describe_table
Get detailed information about a table including schema and row count.
execute_query
Execute a SQL query against the database (read-only mode enforced by DuckDB).
summarize_table
Generate statistical summary of all columns using DuckDB's SUMMARIZE function.
get_database_info
Get general information about the database and connection.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client