How does the skill handle database credentials?

The skill automatically searches for a DATABASE_URL in your local .env file or falls back to a default local development connection string.

Can I use this skill to run regular terminal commands?

No, for security reasons, the bash tool is strictly restricted to executing psql-specific commands only.

Is it safe to perform delete or update operations?

Yes, the skill is programmed to show you the generated SQL and ask for manual confirmation before executing any write or destructive operations.

Does this skill support non-PostgreSQL databases?

No, this skill is specifically designed for PostgreSQL using the psql command-line tool and connection strings.

PostgreSQL Query Assistant

Name: PostgreSQL Query Assistant
Author: dfujiwara

bydfujiwara

0•

数据库管理

Executes SQL queries and translates natural language into database commands for local PostgreSQL instances.

This skill empowers Claude to interact directly with local PostgreSQL databases, specifically optimized for the Kindle notes management system. It allows users to perform data inspections, run complex queries, and manage database records using either raw SQL syntax or intuitive natural language prompts. By automatically detecting schemas and requesting confirmation for destructive operations, it provides a safe and efficient interface for data management and analysis within the Claude Code environment.

主要功能

01Raw SQL and psql command execution

02Natural language to SQL conversion

03Automatic .env file detection for database credentials

040 GitHub stars

05Schema-aware query generation

06Safe handling of write operations with user confirmation

使用场景

01Querying and filtering Kindle highlights or book metadata

02Analyzing reading patterns through SQL-based data aggregation

03Inspecting database table structures and schemas

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dfujiwara/kindle-notes-reminder psql

For use in Claude.ai and ChatGPT

Download Skill