Skills
.Work. You
Rest

database

Official

Query Gertrude's DB safely in read-only mode.

Data & Analytics#SQL#database#schema#query#data-analysis#psql#read-only
Authorgertrude-app
Version1.0.0
Installs0

System Documentation

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;"

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: database
Download link: https://github.com/gertrude-app/gertrude/archive/main.zip#database

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository