{"repo":"teaguesterling/duckdb_mcp","free":true,"listed":false,"github":"https://github.com/teaguesterling/duckdb_mcp","clone":"git clone https://github.com/teaguesterling/duckdb_mcp.git","description":"A simple MCP server extension for DuckDB","language":"C++","stars":62,"topics":[],"license":"Apache-2.0","category":"mcp-servers","readme_excerpt":"DuckDB MCP Extension A Model Context Protocol (MCP) extension for DuckDB that enables seamless integration between SQL databases and AI assistants like Claude. Features - Run as MCP Server : Expose your DuckDB database to AI assistants with built-in tools for querying, describing, and exploring data - HTTP Transport : Run as an HTTP server with authentication for web-based clients - Act as MCP Client : Connect to external MCP servers and query their resources using SQL - Custom Tools : Publish parameterized SQL queries as tools that AI assistants can discover and call - Multiple Formats : Output results as JSON, JSONL, Markdown (token-efficient), CSV, or plain text Quick Start As an MCP Server (for AI Assistants) Create init-server.sql : Add to Claude Desktop configuration: Now Claude can query your database directly! As an HTTP Server Run DuckDB as an HTTP server that any HTTP client can connect to: Then connect via HTTP: As an MCP Client Built-in Server Tools Tool Description ------ ------------- query Execute SQL SELECT queries (supports json/markdown/csv format) describe Get table or query schema information list tables List all tables and views database info Get database overview export Export query results to files execute Run DDL/DML statements (disabled by default) Publishing Custom Tools All parameters are VARCHAR. Pass JSON as string literals, not json object(...) or JSON type expressions. Example: Optional parameters omitted by callers are substituted as SQL NULL .","default_branch":null,"files":null,"tree":[],"storefront":"/r/teaguesterling","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/teaguesterling/duckdb_mcp/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."}