Can it help me with database performance issues?

Absolutely. It provides access to official guides on indexing, performance tips, and the usage of EXPLAIN ANALYZE to optimize your queries.

Why does this skill fetch live documentation instead of answering directly?

PostgreSQL documentation is comprehensive and frequently updated. Fetching live docs ensures Claude provides the most accurate syntax and version-specific features while avoiding 'hallucinations' from memory.

Does this skill support PL/pgSQL and triggers?

Yes, it can specifically query the documentation for stored procedures, triggers, and the PL/pgSQL procedural language for complex backend logic.

Does it provide information on server administration?

Yes, it includes documentation for configuration files like postgresql.conf and pg_hba.conf, as well as procedures for backup, restore, and high availability.

PostgreSQL Official Guide

Name: PostgreSQL Official Guide
Author: PsychQuant

byPsychQuant

0•

Database Management

Retrieves real-time, accurate SQL syntax and database configuration details directly from the official PostgreSQL documentation.

The PostgreSQL Guide skill ensures Claude provides authoritative and up-to-date information by querying the live PostgreSQL documentation instead of relying on potentially outdated training data. It covers everything from basic SQL syntax and data types to advanced topics like PL/pgSQL, performance tuning with EXPLAIN, and high-availability replication. This skill is indispensable for developers and database administrators who require precise documentation for complex queries, server configuration files like pg_hba.conf, and version-specific features.

Key Features

01Comprehensive references for functions, operators, and JSON handling

02Guidance on performance optimization and query analysis

030 GitHub stars

04Detailed syntax guides for all SQL commands and data types

05Real-time fetching of official PostgreSQL documentation

06Administrative support for backups, replication, and security configuration

Use Cases

01Configuring server-level settings and authentication in postgresql.conf and pg_hba.conf

02Generating complex SQL queries involving window functions or JSONB operators

03Troubleshooting database performance issues using official EXPLAIN documentation

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add psychquant/psychquant-claude-plugins postgresql-guide

For use in Claude.ai and ChatGPT

Key Features

01Comprehensive references for functions, operators, and JSON handling

02Guidance on performance optimization and query analysis

030 GitHub stars

04Detailed syntax guides for all SQL commands and data types

05Real-time fetching of official PostgreSQL documentation

06Administrative support for backups, replication, and security configuration

Use Cases

01Configuring server-level settings and authentication in postgresql.conf and pg_hba.conf

02Generating complex SQL queries involving window functions or JSONB operators

03Troubleshooting database performance issues using official EXPLAIN documentation

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add psychquant/psychquant-claude-plugins postgresql-guide

For use in Claude.ai and ChatGPT