# DuckDB

> Use this tool when you need to efficiently analyze large datasets locally or perform ad-hoc data analysis. It enables AI agents to execute SQL queries, create tables, and inspect schemas through a controlled interface, with options for read-only mode for enhanced security. Ideal for use cases requiring high-performance analytical database backend, such as generating insights from local files or providing data-driven recommendations.

Canonical page: https://skillsregistry.net/skills/ktanaka101-duckdb  
JSON: https://api.skillsregistry.net/v1/skills/ktanaka101-duckdb

## Description

This DuckDB MCP server, developed by ktanaka101, provides a flexible interface for language models to interact with DuckDB databases. It enables AI agents to execute SQL queries, create tables, and inspect schemas through a controlled interface. The server can be run in read-only mode for enhanced security and integrates with Claude Desktop. By leveraging DuckDB's column-oriented architecture, it allows AI systems to efficiently analyze large datasets locally. This implementation is particularly useful for AI assistants designed to perform ad-hoc data analysis, generate insights from local files, or provide data-driven recommendations using DuckDB as a high-performance analytical database backend.

## Trust

- **Trust score (0–1):** 0.50
- **Verification tier:** unverified

## Facts

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

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/ktanaka101-duckdb)
- **Repository:** <https://github.com/ktanaka101/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": "ktanaka101-duckdb"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/ktanaka101-duckdb` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/ktanaka101-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