# pgroonga-mcp

> pgroonga-mcp — askdkc-pgroonga-mcp. Use this tool when you need to perform read-only PostgreSQL searches and diagnostics with advanced full-text search capabilities. It solves problems related to efficient data retrieval and analysis by utilizing PGroonga indexes for normalization and variant lookup. The tool accepts Model Context Protocol inputs and provides diagnostic outputs, ideal for use cases requiring in-depth PostgreSQL data examination.

Canonical page: https://skillsregistry.net/skills/askdkc-pgroonga-mcp  
JSON: https://api.skillsregistry.net/v1/skills/askdkc-pgroonga-mcp

## Description

Provides read-only PostgreSQL search and diagnostics over Model Context Protocol, using PGroonga indexes for full-text search, normalization, and variant lookup.

## Trust

- **Trust score (0–1):** 0.67
- **Verification tier:** scanned
- **Last scanned:** 2026-08-29

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/tc34jqkh7w)
- **Repository:** <https://github.com/askdkc/pgroonga-mcp>

## 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": "askdkc-pgroonga-mcp"
    }
  }
}
```

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