skills/impertio-studio/postgresql-claude-skill-package/postgres-impl-indexing-strategy/Gen Agent Trust Hub
postgres-impl-indexing-strategy
Pass
Audited by Gen Agent Trust Hub on Jun 17, 2026
Risk Level: SAFE
Full Analysis
- [SAFE]: The skill's content is entirely instructional and provides diagnostic SQL queries for database performance tuning. It correctly adheres to PostgreSQL best practices, such as recommending concurrent index creation for live tables.
- [COMMAND_EXECUTION]: The skill provides SQL commands for database auditing and schema management, including
CREATE INDEX,EXPLAIN ANALYZE, and queries against system catalogs likepg_indexandpg_stat_user_indexes. These are standard operations for its intended use case. - [EXTERNAL_DOWNLOADS]: The skill references external URLs exclusively from
postgresql.org, which is a well-known and trusted service for database documentation. - [INDIRECT_PROMPT_INJECTION]: The skill defines patterns for analyzing user-supplied queries and schemas. While this involves processing external data, the provided SQL templates use robust PostgreSQL features like
regclassto handle identifiers safely, minimizing risks associated with untrusted database metadata.
Audit Metadata