database

Name: database
Availability: InStock
Author: Gertrude

Query and analyze the Gertrude PostgreSQL database with read-only access.

4|Updated Aug 3, 2022

Search Tags:#SQL #database #schema #query #data-analysis #psql #read-only

Ready to run

npx skills add https://github.com/gertrude-app/gertrude --skill database-gertrude-app

💬 Prompt for ChatGPT / Claude Chat▼

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

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.

Core Features & Use Cases

Schema Introspection: Inspect schemas and table structures to understand data organization.
Read-Only Queries: Run safe SELECT queries to summarize data, verify counts, and validate assumptions without modifying data.
SQL Guidance & Debugging: Get structured query examples and explanations to help debug data issues or design reports.

Quick Start

Connect with the read-only user and run a simple query: psql -U readonly -d gertrude -c "SELECT COUNT(*) FROM parent.parents;"

Frequently Asked Questions about database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I query the Gertrude PostgreSQL database safely without modifying data?▼

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.

Can I inspect database schema and table structures in Gertrude?▼

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.

How do I compose and run SQL queries to analyze Gertrude data?▼

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.

What's the best way to debug database issues and validate SQL queries?▼

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.

Do I need special permissions to access the Gertrude database?▼

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.