{"repo":"mustafahasankhan/duckdb-mcp-server","free":true,"listed":false,"github":"https://github.com/mustafahasankhan/duckdb-mcp-server","clone":"git clone https://github.com/mustafahasankhan/duckdb-mcp-server.git","description":"MCP (Model Context Protocol) server for DuckDB — auth and friendly SQL support out of the box","language":"Python","stars":17,"topics":["agentic-ai","ai-agents","duckdb","llm","mcp","model-context-protocol","python","sql"],"license":"MIT","category":"mcp-servers","readme_excerpt":"DuckDB MCP Server A Model Context Protocol (MCP) server that gives AI assistants full access to DuckDB — query local files, S3 buckets, and in-memory data using plain SQL. 🌟 What is DuckDB MCP Server? --- What it does This server exposes DuckDB to any MCP-compatible client (Claude Desktop, Cursor, VS Code, etc.). The assistant can: - Run arbitrary SQL against local CSV, Parquet, and JSON files - Query S3 / GCS buckets directly or cache them as local tables - Inspect schemas, compute statistics, and suggest visualizations - Use DuckDB's analytical SQL extensions (window functions, GROUP BY ALL , SELECT EXCLUDE , etc.) Tools Tool Description --- --- query Execute any SQL query. Results capped at 10 000 rows. analyze schema Describe the columns and types of a file or table. analyze data Row count, numeric stats (min/max/avg/median), date ranges, top categorical values. suggest visualizations Suggest chart types and ready-to-run SQL queries based on column types. create session Create or reset a session for cross-call context tracking. Resources Three built-in XML documentation resources are always available to the assistant: Resource URI Content --- --- duckdb-ref://friendly-sql DuckDB SQL extensions (GROUP BY ALL, SELECT EXCLUDE/REPLACE, FROM-first syntax, …) duckdb-ref://data-import Loading CSV, Parquet, JSON, and S3/GCS data; glob patterns; multi-file reads duckdb-ref://visualization Chart patterns and query templates for time series, bar, scatter, and heatmap --- Requiremen","default_branch":null,"files":null,"tree":[],"storefront":"/r/mustafahasankhan","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/mustafahasankhan/duckdb-mcp-server/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}