Query and analyze the Gertrude PostgreSQL database with read-only access.
npx skills add https://github.com/gertrude-app/gertrude --skill database-gertrude-app
Please help me install this Agent Skill. Skill: database Source: https://github.com/gertrude-app/gertrude/tree/main/.claude/skills/database Command: npx skills add https://github.com/gertrude-app/gertrude --skill database-gertrude-app
This Skill helps you explore and analyze the Gertrude PostgreSQL database without risking changes, using a read-only connection to answer schema questions, generate queries, and validate hypotheses.
Connect with the read-only user and run a simple query: psql -U readonly -d gertrude -c "SELECT COUNT(*) FROM parent.parents;"
High-intent search queries and answers about installing and using this skill.
Query the Gertrude PostgreSQL database using the read-only user connection via psql. Run SELECT queries against schema-qualified tables to inspect data, summarize counts, and validate assumptions without risk of accidental modifications under read-only access.
Yes. Use schema introspection commands through psql to examine table structures, columns, and relationships. This helps you understand data organization before composing SELECT queries or debugging schema-related issues.
Connect with psql using the readonly user, then write and execute SELECT queries—including joins and aggregations—to summarize data, verify row counts, and validate hypotheses against the PostgreSQL database without modifying it.
Use read-only SELECT queries with structured examples and schema-qualified table names to test hypotheses, inspect results, and debug data problems. The read-only connection prevents accidental changes while you analyze and refine queries.
Yes. Connect using the readonly user account via psql to establish a read-only PostgreSQL connection. This configuration ensures safe access to query and analyze data without modification privileges.
dversozaQuery PostgreSQL databases read-only via psql for schema introspection and EXPLAIN plans.
RedHatProductSecurityExport security review findings into Markdown and SARIF report formats.
Sake-TeamApply PostgreSQL best practices for query optimization, schema design, indexing, and security.
w95Execute read-only SQL queries against multiple PostgreSQL databases.
