db-executor

What problem does it solve?

Prevents accidental data loss and unsafe database changes by enforcing a safety-first workflow for querying and modifying PostgreSQL databases.

Core Features & Use Cases

• Safe Write Operations: Enforces WHERE validation, performs dry-run previews with affected row counts and sample rows, and requires explicit confirmation before executing UPDATE or DELETE statements.
• Flexible Execution: Runs queries via native psql or auto-detected Docker containers and supports CSV-formatted outputs for efficient parsing.
• Schema Discovery & Inspection: Provides table search, schema inspection, and list-tables helpers to find and understand table structures before writing queries.
• Use Case: Inspect a users table, preview the rows that would be affected by an UPDATE, and safely apply the change only after verifying the dry-run and typing yes to confirm.

Quick Start

Ask the skill to run a SELECT or to preview and then safely execute an UPDATE/DELETE while following its mandatory dry-run and explicit yes confirmation.