How does pgtool differ from using standard psql?

pgtool is specifically designed for AI agents, providing structured JSON output that is easier for Claude to parse and reason about compared to the plain-text tabular output of psql.

Does pgtool support cross-schema exploration?

Absolutely. You can list schemas, filter tables by specific schemas, and view relationships across the entire database or within specific namespaces.

Can pgtool handle large datasets safely?

Yes, pgtool enforces best practices such as adding LIMIT clauses to SELECT queries and providing row estimates to prevent fetching excessive data.

What configuration is required for pgtool to work?

The skill requires a .pgtool.json file in your project root containing database connection details like host, port, user, and password.

PostgreSQL Explorer & Debugger

Name: PostgreSQL Explorer & Debugger
Author: ThilinaTLM

byThilinaTLM

0•

データベース管理

Explores, debugs, and manages PostgreSQL databases using AI-optimized JSON outputs and comprehensive schema discovery tools.

pgtool is a specialized CLI utility designed to give Claude Code a structured, high-level interface for interacting with PostgreSQL databases. It enables AI agents to perform deep schema exploration, map complex foreign key relationships, search for specific data patterns across tables, and analyze query performance without raw psql overhead. By providing JSON-first responses, it ensures that Claude can accurately interpret database structures, suggest precise fixes for data issues, and optimize SQL queries using built-in EXPLAIN ANALYZE capabilities.

主な機能

010 GitHub stars

02Detailed table inspection including indexes, constraints, and column types

03Global search functionality across all table and column names

04Safe query execution with JSON formatting and automatic row limits

05Performance debugging with query plan analysis (EXPLAIN/ANALYZE)

06Automated schema discovery and ERD-style relationship mapping

ユースケース

01Debugging data integrity issues by verifying constraints and foreign key links

02Rapidly mapping and understanding an unfamiliar legacy database schema

03Optimizing slow-running SQL queries directly within the Claude Code environment

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add thilinatlm/agent-skills pgtool

For use in Claude.ai and ChatGPT

Download Skill