postgres-cli

What problem does it solve?

PostgreSQL users need a reliable way to inspect schemas, run safe diagnostics, and query or validate data without relying on untrusted community tooling.

Core Features & Use Cases

• Direct psql database access: Connect and run one-shot SQL or execute SQL files for inspection and debugging.
• Schema and operational introspection: List tables, functions, roles, databases, and extensions to understand what’s really in the database.
• Production-focused safety patterns: Use read-only constraints, wrap risky writes in transactions with EXPLAIN-first workflows, and follow conventions for multi-tenant, PHI, and analytics contexts.

Example use case: When a user asks why a metric changed, you can query the relevant tables, inspect the schema for constraints or new columns, and run EXPLAIN on any suspect query to diagnose performance regressions.

Quick Start

Ask the skill to connect using your project-scoped DATABASE_URL and run the specific read-only query or schema inspection you need.