# DuckDB

> Use this tool when you need to rapidly analyze structured data files, such as CSV, JSON, and Parquet, with a lightweight and efficient in-memory database solution. DuckDB provides core functionalities like file-to-table loading, table management, and SQL query execution, solving problems related to local data analysis and processing. It offers a simple interface with automatic file type detection and structured JSON responses, making it ideal for data analysts and developers who require fast and flexible analytical capabilities.

Canonical page: https://skillsregistry.net/skills/dacort-mcplucker  
JSON: https://api.skillsregistry.net/v1/skills/dacort-mcplucker

## Description

MCPlucker is a Go-based MCP server that provides direct access to DuckDB's analytical capabilities through five core tools: file-to-table loading (CSV, JSON, Parquet), table management, schema inspection, and SQL query execution with configurable result limits. Built with the go-duckdb driver and MCP Go SDK, it uses an in-memory DuckDB instance by default and includes comprehensive error handling, automatic file type detection, and structured JSON responses for all operations. The implementation follows a clean architecture with separate packages for database management, server logic, and tool implementations, making it ideal for data analysts and developers who need fast, local analytical processing of structured data files without the overhead of a full database setup.

## Trust

- **Trust score (0–1):** 1.00
- **Verification tier:** verified
- **Last scanned:** 2026-09-28

## Facts

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

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/dacort-mcplucker)
- **Repository:** <https://github.com/dacort/mcplucker>

## 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": "dacort-mcplucker"
    }
  }
}
```

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