Bỏ qua tới nội dung
TakoAPI
Quay lại kỹ năng

db-readonly

bởi reed1898

Browser & Automation
835Lượt tải do clawskills.sh công bố
0Lượt xem
0 lượt thíchĐăng nhập để thích kỹ năng này
—Chưa có đánh giá
Đánh giá của bạn

Tóm tắt

Run safe read-only queries against MySQL or PostgreSQL for data inspection, reporting, and troubleshooting.

Mô tả

Kỹ năng này làm gì

Runs read-only queries against PostgreSQL or MySQL databases. Supports SELECT, WITH, and EXPLAIN statements, and can export results to CSV, TSV, or JSON. Blocks INSERT, UPDATE, DELETE, DROP, and ALTER to prevent accidental data modification.

Enforces read-only access at the skill level, so exploratory database work can't accidentally modify or delete data.

Khi nào nên dùng

  • Inspecting table schemas before writing a migration
  • Counting rows to verify a data import completed
  • Sampling user records to debug a reported issue
  • Exporting query results to CSV for a stakeholder report
  • Running EXPLAIN on a slow query to diagnose performance

Quy trình ví dụ

ĐẦU VÀO

User asks: Show me the 10 most recent orders with their totals

AGENT
  1. 1

    Reads PGHOST, PGDATABASE, PGUSER, PGPASSWORD from environment

  2. 2

    Constructs a SELECT query with ORDER BY created_at DESC and LIMIT 10

  3. 3

    Runs scripts/db_readonly.sh postgres with the query

  4. 4

    Returns the result rows to the user

ĐẦU RA

A table of 10 order rows showing id, created_at, and total columns

Yêu cầu

  • PostgreSQL connection environment variables: PGHOST, PGDATABASE, PGUSER, PGPASSWORD
  • MySQL connection environment variables: MYSQL_HOST, MYSQL_DATABASE, MYSQL_USER, MYSQL_PASSWORD

Cài đặt

clawhub install reed1898/db-readonly

Chạy lệnh CLI, hoặc dán prompt vào Claude Code, Cursor, Codex hay coding agent bạn đang dùng.

Liên kết