Do I need a separate graph database like Neo4j?

No, this skill enables graph-like capabilities within PostgreSQL by utilizing tables for entities and edges, combined with vector and full-text search extensions.

What search methodologies does it support?

It generates SQL for Local Search (n-hop entity expansion), Global Search (community-level summaries), and Hybrid Search (combining vector and keyword results).

How does it handle data extraction?

The skill generates custom LLM prompts (entity_extraction.md and edge_extraction.md) tailored to your specific schema to help automate the population of your graph.

Does it support languages other than English?

Yes, it includes specific indexing strategies for Japanese and English using PGroonga's TokenMecab and TokenBigram tokenizers.

What is the primary purpose of the GraphRAG PostgreSQL skill?

It allows developers to build relationship-aware Retrieval-Augmented Generation (RAG) systems directly within PostgreSQL by automating schema and query generation.

GraphRAG for PostgreSQL

Name: GraphRAG for PostgreSQL
Author: titabash

bytitabash

0•

Database Management

Automates the design and implementation of GraphRAG systems using PostgreSQL, pgvector, and PGroonga.

This skill transforms natural language project descriptions into production-ready GraphRAG architectures within a PostgreSQL environment. It leverages pgvector for semantic search and PGroonga for advanced full-text indexing, automatically generating entity/edge schemas, specialized query patterns for local and global search, and LLM-driven data extraction prompts. It is ideal for developers who want to build sophisticated, relationship-aware RAG systems without leaving the PostgreSQL ecosystem.

Key Features

010 GitHub stars

02Support for advanced features like time-series relationship tracking and community detection

03Domain-specific LLM prompts for automated entity and relationship extraction

04Automated entity and relationship (edge) schema design based on natural language requirements

05Generation of specialized SQL patterns for Local, Global, and Hybrid search queries

06Integration of pgvector for semantic vector search and PGroonga for hybrid search capabilities

Use Cases

01Building a relational knowledge base for complex technical documentation and API references

02Managing evolving character relationships and world-building elements for creative storytelling

03Implementing advanced RAG for troubleshooting logs to perform root cause and impact analysis

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add titabash/claude-plugins graphrag

For use in Claude.ai and ChatGPT

Download Skill