# DuckDB MCP Server

> Use this tool when you need to execute SQL queries on various database sources, including local, in-memory, or cloud-stored databases, to retrieve and analyze data. It solves problems related to data access and querying, providing flexible connections and configurable result limits for efficient data retrieval. Ideal for AI assistants and IDEs, it takes SQL queries as input and returns query results as output.

Canonical page: https://skillsregistry.net/skills/boettiger-lab-mcp-server-duckdb  
JSON: https://api.skillsregistry.net/v1/skills/boettiger-lab-mcp-server-duckdb

## Description

Enables AI assistants and IDEs to execute SQL queries on local DuckDB databases, in-memory databases, or cloud-stored databases with support for flexible connections and configurable result limits.

## Trust

- **Trust score (0–1):** 0.68
- **Verification tier:** scanned
- **Last scanned:** 2026-09-02

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-02

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/flzhs4wg8q)
- **Repository:** <https://github.com/boettiger-lab/mcp-server-duckdb>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "boettiger-lab-mcp-server-duckdb"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/boettiger-lab-mcp-server-duckdb` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/boettiger-lab-mcp-server-duckdb/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt