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

데이터베이스 관리

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.

주요 기능

Raw SQL and psql command execution
Natural language to SQL conversion
Automatic .env file detection for database credentials
0 GitHub stars
Schema-aware query generation
Safe handling of write operations with user confirmation

사용 사례

Querying and filtering Kindle highlights or book metadata
Analyzing reading patterns through SQL-based data aggregation
Inspecting database table structures and schemas

소개

주요 기능

Raw SQL and psql command execution
Natural language to SQL conversion
Automatic .env file detection for database credentials
0 GitHub stars
Schema-aware query generation
Safe handling of write operations with user confirmation

사용 사례

Querying and filtering Kindle highlights or book metadata
Analyzing reading patterns through SQL-based data aggregation
Inspecting database table structures and schemas